Solved

Convert to Excel

Posted on 2002-05-22
25
920 Views
Last Modified: 2012-06-21
I don’t know if this thing can be applied or not!!

Is there a way to download the contents of a table in Excel sheet format?
0
Comment
Question by:noura79
  • 8
  • 5
  • 3
  • +5
25 Comments
 
LVL 32

Expert Comment

by:Batalf
ID: 7028125
0
 
LVL 4

Expert Comment

by:lokeshv
ID: 7028840
you want to do it for urself or want to provide this functionality ot ur users ?


Lk

0
 
LVL 5

Expert Comment

by:dkjariwala
ID: 7028896
Agree with Lk,

Is it for you or for your users ?
JD
0
 

Author Comment

by:noura79
ID: 7029146
I guess there is a kind of misunderstanding here!! I want the user to be able to download the contents of a mysql table lets assume that I have the following table
product_info(ID,BranchID,ProductID,Quantity,Price)
If the user is working at Brach #3 he will be able to view a part of the table (where BranchID=3) on the browser at that time he should have the option to download these information into Excel sheet format!!
so far the tables are displayed according to the BranchID but I don't know how to download those tables into .xls format????

thanks
0
 
LVL 5

Expert Comment

by:dkjariwala
ID: 7029202
What you can do is export data in CSV format.
Check latest phpMyAdmin.

It has option for exporting data in CSV format,Which Excel can import easily.

JD
0
 
LVL 5

Expert Comment

by:dkjariwala
ID: 7029207
0
 
LVL 40

Expert Comment

by:RQuadling
ID: 7029238
Getting the data into a spreadsheet can be handled via obdc or com (assuming you have a windows based-server with the necessary com libraries installed).

Alternatively, you can create a CSV file and get them to open it (or if the client is set to handle CSV files in Excel, simply opening the file should ask them to open or save the file).

What you cannot do is send the data from the server into a client's Excel. Not without some additional program running on the client. I suspect that there are ActiveX controls that would allow that to happen, but security risks would prevent me from using them and probably your users.

0
 
LVL 4

Expert Comment

by:lokeshv
ID: 7029241
how about writing your own script to do this...

like

$query="select * from ur_table where branch_id=$branch_id";

$qid=db_query($query);
if(!$qid){
       echo'Error :'.mysql_error();
       exit;
}
$str="";
while($row=mysql_fetch_array($qid)){
     $str.=$row[id].",";
     $str.=$row[branch_id].",";
     $str.=$row[quantity].",";
     $str.=$row[price];
     $str.="\n";
}

//send this string to user as files request to save.

header("Content-Type: application/octet-stream");

header("Content-Disposition: attachment; filename=ur_data.txt");
header("Content-Transfer-Encoding: binary");

echo $str;
}


so this data will be saved in a CSV file ..user can easily import it into the excel sheet.

you can also use "!","~" as elimiter if u want.

Hope this helps..

Lk

0
 
LVL 5

Expert Comment

by:dkjariwala
ID: 7029979
Oh,

I found some better option.
Check

http://www.hotscripts.com/Detailed/13890.html

JD
0
 
LVL 4

Expert Comment

by:lokeshv
ID: 7030080
JD

you have blocked the quesation ...

you are a regular user here...not a newbie..

and this kind of stuff ??

let the quesationer choose wats better soln for him.

Regards

Lk
0
 
LVL 32

Expert Comment

by:Batalf
ID: 7030205
dkjariwala : Have you tried that script yourself? Do you get an excel-file where each column is located in it's on column? All I'm getting is a tabseparated textfile showing in the browser. There are some excel headers but they doesn't seem to have any effect.

To me it seems that a solution like this is just as good:

1) Print all the columns of the db-table to the browser in a table
2) Copy the content of the browser-window into a new excel-sheet.

Batalf
0
 
LVL 5

Expert Comment

by:dkjariwala
ID: 7031195
Lk,

My mistake. I make sure I don't do that in future. Actually I got carried away in excitement of being Pro member.

JD
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 8

Expert Comment

by:GEM100
ID: 7196155
stick to giving the CSV file generated on the fly. It will open fine with Excel...
0
 

Expert Comment

by:bogdan_albei
ID: 7785126
This class will help you easily generate excel files via PHP http://pear.php.net/get/Spreadsheet_Excel_Writer-0.1.tgz . After the .xls files are generated you can send some headers, and then the content on the files so that the clients will be able to "download" the files.
0
 
LVL 40

Expert Comment

by:RQuadling
ID: 7790165
Something that may be what you want.

This is a simple Excel spreadsheet saved as HTML.

You could therefore create a HTML file with the correct headers and give the user the option of opening (send as html) or saving (send as octet-stream).

Edited by Computer101
<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>

</html>
0
 
LVL 40

Expert Comment

by:RQuadling
ID: 7790220
Sorry about the stupidly big post. I cut'n'pasted the wrong thing. I've asked CS to remove it.

Sorry.
Sorry.
Sorry.

0
 
LVL 40

Expert Comment

by:RQuadling
ID: 7791521
Another example.

<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 10">
<link rel=File-List href="example_files/filelist.xml">
<style id="Book1_31611_Styles">
<!--table
      {mso-displayed-decimal-separator:"\.";
      mso-displayed-thousand-separator:"\,";}
.xl1531611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:General;
      text-align:general;
      vertical-align:bottom;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl2231611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:General;
      text-align:general;
      vertical-align:bottom;
      border-top:1.0pt solid windowtext;
      border-right:1.0pt solid windowtext;
      border-bottom:none;
      border-left:1.0pt solid windowtext;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl2331611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:General;
      text-align:general;
      vertical-align:bottom;
      border-top:none;
      border-right:1.0pt solid windowtext;
      border-bottom:none;
      border-left:1.0pt solid windowtext;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl2431611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:General;
      text-align:general;
      vertical-align:bottom;
      border-top:none;
      border-right:1.0pt solid windowtext;
      border-bottom:1.0pt solid windowtext;
      border-left:1.0pt solid windowtext;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl2531611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:"Short Time";
      text-align:general;
      vertical-align:bottom;
      border-top:1.0pt solid windowtext;
      border-right:none;
      border-bottom:1.0pt solid windowtext;
      border-left:1.0pt solid windowtext;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl2631611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:"Short Time";
      text-align:general;
      vertical-align:bottom;
      border-top:1.0pt solid windowtext;
      border-right:none;
      border-bottom:1.0pt solid windowtext;
      border-left:none;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl2731611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:"Short Time";
      text-align:general;
      vertical-align:bottom;
      border-top:1.0pt solid windowtext;
      border-right:1.0pt solid windowtext;
      border-bottom:1.0pt solid windowtext;
      border-left:none;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl2831611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:General;
      text-align:general;
      vertical-align:bottom;
      border:1.0pt solid windowtext;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl2931611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:General;
      text-align:general;
      vertical-align:bottom;
      border-top:1.0pt solid windowtext;
      border-right:none;
      border-bottom:none;
      border-left:1.0pt solid windowtext;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl3031611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:General;
      text-align:general;
      vertical-align:bottom;
      border-top:1.0pt solid windowtext;
      border-right:none;
      border-bottom:none;
      border-left:none;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl3131611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:General;
      text-align:general;
      vertical-align:bottom;
      border-top:1.0pt solid windowtext;
      border-right:1.0pt solid windowtext;
      border-bottom:none;
      border-left:none;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl3231611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:General;
      text-align:general;
      vertical-align:bottom;
      border-top:none;
      border-right:none;
      border-bottom:none;
      border-left:1.0pt solid windowtext;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl3331611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:General;
      text-align:general;
      vertical-align:bottom;
      border-top:none;
      border-right:1.0pt solid windowtext;
      border-bottom:none;
      border-left:none;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl3431611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:General;
      text-align:general;
      vertical-align:bottom;
      border-top:none;
      border-right:none;
      border-bottom:1.0pt solid windowtext;
      border-left:1.0pt solid windowtext;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl3531611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:General;
      text-align:general;
      vertical-align:bottom;
      border-top:none;
      border-right:none;
      border-bottom:1.0pt solid windowtext;
      border-left:none;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
.xl3631611
      {padding-top:1px;
      padding-right:1px;
      padding-left:1px;
      mso-ignore:padding;
      color:windowtext;
      font-size:10.0pt;
      font-weight:400;
      font-style:normal;
      text-decoration:none;
      font-family:Arial;
      mso-generic-font-family:auto;
      mso-font-charset:0;
      mso-number-format:General;
      text-align:general;
      vertical-align:bottom;
      border-top:none;
      border-right:1.0pt solid windowtext;
      border-bottom:1.0pt solid windowtext;
      border-left:none;
      mso-background-source:auto;
      mso-pattern:auto;
      white-space:nowrap;}
-->
</style>
</head>

<body>
<!--[if !excel]>&nbsp;&nbsp;<![endif]-->
<!--The following information was generated by Microsoft Excel's Publish as Web
Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->

<div id="Book1_31611" align=center x:publishsource="Excel">

<table x:str border=0 cellpadding=0 cellspacing=0 width=652 style='border-collapse:
 collapse;table-layout:fixed;width:489pt'>
 <col width=76 style='mso-width-source:userset;mso-width-alt:2779;width:57pt'>
 <col width=64 span=9 style='width:48pt'>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2831611 width=76 style='height:13.5pt;width:57pt'>&nbsp;</td>
  <td class=xl2531611 align=right width=64 style='border-left:none;width:48pt'
  x:num="0.375">9:00</td>
  <td class=xl2631611 align=right width=64 style='width:48pt'
  x:num="0.41666666666666669">10:00</td>
  <td class=xl2631611 align=right width=64 style='width:48pt'
  x:num="0.45833333333333298">11:00</td>
  <td class=xl2631611 align=right width=64 style='width:48pt' x:num="0.5">12:00</td>
  <td class=xl2631611 align=right width=64 style='width:48pt'
  x:num="0.54166666666666696">13:00</td>
  <td class=xl2631611 align=right width=64 style='width:48pt'
  x:num="0.58333333333333304">14:00</td>
  <td class=xl2631611 align=right width=64 style='width:48pt' x:num="0.625">15:00</td>
  <td class=xl2631611 align=right width=64 style='width:48pt'
  x:num="0.66666666666666696">16:00</td>
  <td class=xl2731611 align=right width=64 style='width:48pt'
  x:num="0.70833333333333304">17:00</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2231611 style='height:12.75pt;border-top:none'>Sunday</td>
  <td class=xl2931611 style='border-top:none;border-left:none'>In</td>
  <td class=xl3031611 style='border-top:none'>Out</td>
  <td class=xl3031611 style='border-top:none'>Out</td>
  <td class=xl3031611 style='border-top:none'>Out</td>
  <td class=xl3031611 style='border-top:none'>Out</td>
  <td class=xl3031611 style='border-top:none'>Out</td>
  <td class=xl3031611 style='border-top:none'>Out</td>
  <td class=xl3031611 style='border-top:none'>In</td>
  <td class=xl3131611 style='border-top:none'>In</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2331611 style='height:12.75pt'>Monday</td>
  <td class=xl3231611 style='border-left:none'>&nbsp;</td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl3331611>&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2331611 style='height:12.75pt'>Tuesday</td>
  <td class=xl3231611 style='border-left:none'>&nbsp;</td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl3331611>&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2331611 style='height:12.75pt'>Wednesday</td>
  <td class=xl3231611 style='border-left:none'>&nbsp;</td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl3331611>&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2331611 style='height:12.75pt'>Thursday</td>
  <td class=xl3231611 style='border-left:none'>&nbsp;</td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl3331611>&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2331611 style='height:12.75pt'>Friday</td>
  <td class=xl3231611 style='border-left:none'>&nbsp;</td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl1531611></td>
  <td class=xl3331611>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2431611 style='height:13.5pt'>Saturday</td>
  <td class=xl3431611 style='border-left:none'>&nbsp;</td>
  <td class=xl3531611>&nbsp;</td>
  <td class=xl3531611>&nbsp;</td>
  <td class=xl3531611>&nbsp;</td>
  <td class=xl3531611>&nbsp;</td>
  <td class=xl3531611>&nbsp;</td>
  <td class=xl3531611>&nbsp;</td>
  <td class=xl3531611>&nbsp;</td>
  <td class=xl3631611>&nbsp;</td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=76 style='width:57pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
 </tr>
 <![endif]>
</table>

</div>


<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>

</html>

0
 
LVL 40

Expert Comment

by:RQuadling
ID: 7791547
With interactivity.


<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=FrontPage.Editor.Document>
<meta name=Generator content="Microsoft Excel 10">
<link rel=File-List href="Book2_files/filelist.xml">
</head>

<body>
<!--[if !excel]>&nbsp;&nbsp;<![endif]-->
<!--The following information was generated by Microsoft Excel's Publish as Web
Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->

<div id="Book1_17422" align=center x:publishsource="Excel"><object
 id="Book1_17422_Spreadsheet"
 classid="CLSID:0002E551-0000-0000-C000-000000000046">
 <param name=DisplayTitleBar value=false>
 <param name=Autofit value=true>
 <param name=DataType value=XMLData>
 <param name=XMLData
 value="&lt;?xml version=&quot;1.0&quot;?&gt;&#13;&#10;&lt;Workbook xmlns=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;&#13;&#10; xmlns:o=&quot;urn:schemas-microsoft-com:office:office&quot;&#13;&#10; xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;&#13;&#10; xmlns:ss=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;&#13;&#10; xmlns:html=&quot;http://www.w3.org/TR/REC-html40&quot;&gt;&#13;&#10; &lt;DocumentProperties xmlns=&quot;urn:schemas-microsoft-com:office:office&quot;&gt;&#13;&#10;  &lt;Author&gt;Richard Quadling&lt;/Author&gt;&#13;&#10;  &lt;LastAuthor&gt;Richard Quadling&lt;/LastAuthor&gt;&#13;&#10;  &lt;Created&gt;2003-01-23T14:05:03Z&lt;/Created&gt;&#13;&#10;  &lt;LastSaved&gt;2003-01-23T14:10:51Z&lt;/LastSaved&gt;&#13;&#10;  &lt;Company&gt;Carval Computing Limited&lt;/Company&gt;&#13;&#10;  &lt;Version&gt;10.4219&lt;/Version&gt;&#13;&#10; &lt;/DocumentProperties&gt;&#13;&#10; &lt;OfficeDocumentSettings xmlns=&quot;urn:schemas-microsoft-com:office:office&quot;&gt;&#13;&#10;  &lt;DownloadComponents/&gt;&#13;&#10;  &lt;LocationOfComponents HRef=&quot;file:///\\&quot;/&gt;&#13;&#10; &lt;/OfficeDocumentSettings&gt;&#13;&#10; &lt;ExcelWorkbook xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;  &lt;PublishObjects&gt;&#13;&#10;   &lt;PublishObject&gt;&#13;&#10;    &lt;Id&gt;17422&lt;/Id&gt;&#13;&#10;    &lt;DivID&gt;Book1_17422&lt;/DivID&gt;&#13;&#10;    &lt;SourceType&gt;SourceWorkbook&lt;/SourceType&gt;&#13;&#10;    &lt;HtmlType&gt;HtmlCalc&lt;/HtmlType&gt;&#13;&#10;    &lt;Location x:HRef=&quot;C:\Book2.htm&quot;/&gt;&#13;&#10;   &lt;/PublishObject&gt;&#13;&#10;  &lt;/PublishObjects&gt;&#13;&#10;  &lt;WindowHeight&gt;12660&lt;/WindowHeight&gt;&#13;&#10;  &lt;WindowWidth&gt;15180&lt;/WindowWidth&gt;&#13;&#10;  &lt;WindowTopX&gt;480&lt;/WindowTopX&gt;&#13;&#10;  &lt;WindowTopY&gt;135&lt;/WindowTopY&gt;&#13;&#10;  &lt;ProtectStructure&gt;False&lt;/ProtectStructure&gt;&#13;&#10;  &lt;ProtectWindows&gt;False&lt;/ProtectWindows&gt;&#13;&#10; &lt;/ExcelWorkbook&gt;&#13;&#10; &lt;Styles&gt;&#13;&#10;  &lt;Style ss:ID=&quot;Default&quot; ss:Name=&quot;Normal&quot;&gt;&#13;&#10;   &lt;Alignment ss:Vertical=&quot;Bottom&quot;/&gt;&#13;&#10;   &lt;Borders/&gt;&#13;&#10;   &lt;Font/&gt;&#13;&#10;   &lt;Interior/&gt;&#13;&#10;   &lt;NumberFormat/&gt;&#13;&#10;   &lt;Protection/&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s22&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s23&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s24&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s25&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;   &lt;NumberFormat ss:Format=&quot;Short Time&quot;/&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s26&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;   &lt;NumberFormat ss:Format=&quot;Short Time&quot;/&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s27&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;   &lt;NumberFormat ss:Format=&quot;Short Time&quot;/&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s28&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s29&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s30&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s31&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s32&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s33&quot;&gt;&#13;&#10;   &lt;Borders/&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s34&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s35&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s36&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s37&quot;&gt;&#13;&#10;   &lt;Borders&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;    &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;2&quot;/&gt;&#13;&#10;   &lt;/Borders&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10; &lt;/Styles&gt;&#13;&#10; &lt;Worksheet ss:Name=&quot;Sheet1&quot;&gt;&#13;&#10;  &lt;Table ss:ExpandedColumnCount=&quot;10&quot; ss:ExpandedRowCount=&quot;8&quot; x:FullColumns=&quot;1&quot;&#13;&#10;   x:FullRows=&quot;1&quot;&gt;&#13;&#10;   &lt;Column ss:Width=&quot;57&quot;/&gt;&#13;&#10;   &lt;Row ss:Height=&quot;13.5&quot;&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s28&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s25&quot;&gt;&lt;Data ss:Type=&quot;DateTime&quot;&gt;1899-12-31T09:00:00.000&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s26&quot;&gt;&lt;Data ss:Type=&quot;DateTime&quot;&gt;1899-12-31T10:00:00.000&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s26&quot;&gt;&lt;Data ss:Type=&quot;DateTime&quot;&gt;1899-12-31T11:00:00.000&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s26&quot;&gt;&lt;Data ss:Type=&quot;DateTime&quot;&gt;1899-12-31T12:00:00.000&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s26&quot;&gt;&lt;Data ss:Type=&quot;DateTime&quot;&gt;1899-12-31T13:00:00.000&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s26&quot;&gt;&lt;Data ss:Type=&quot;DateTime&quot;&gt;1899-12-31T14:00:00.000&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s26&quot;&gt;&lt;Data ss:Type=&quot;DateTime&quot;&gt;1899-12-31T15:00:00.000&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s26&quot;&gt;&lt;Data ss:Type=&quot;DateTime&quot;&gt;1899-12-31T16:00:00.000&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s27&quot;&gt;&lt;Data ss:Type=&quot;DateTime&quot;&gt;1899-12-31T17:00:00.000&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;Sunday&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s29&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;In&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s30&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;Out&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s30&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;Out&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s30&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;Out&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s30&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;Out&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s30&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;Out&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s30&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;Out&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s30&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;In&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s31&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;In&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;Monday&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s32&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s34&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;Tuesday&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s32&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s34&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;Wednesday&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s32&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s34&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;Thursday&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s32&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s34&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;Friday&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s32&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s33&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s34&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row ss:Height=&quot;13.5&quot;&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s24&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;Saturday&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s35&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s36&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s36&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s36&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s36&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s36&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s36&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s36&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s37&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;  &lt;/Table&gt;&#13;&#10;  &lt;WorksheetOptions xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;   &lt;ProtectObjects&gt;False&lt;/ProtectObjects&gt;&#13;&#10;   &lt;ProtectScenarios&gt;False&lt;/ProtectScenarios&gt;&#13;&#10;  &lt;/WorksheetOptions&gt;&#13;&#10;  &lt;PublishObjects xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;   &lt;PublishObject&gt;&#13;&#10;    &lt;Id&gt;31611&lt;/Id&gt;&#13;&#10;    &lt;DivID&gt;Book1_31611&lt;/DivID&gt;&#13;&#10;    &lt;SourceType&gt;SourceSheet&lt;/SourceType&gt;&#13;&#10;    &lt;HtmlType&gt;HtmlStatic&lt;/HtmlType&gt;&#13;&#10;    &lt;Location x:HRef=&quot;C:\Example2.htm&quot;/&gt;&#13;&#10;   &lt;/PublishObject&gt;&#13;&#10;  &lt;/PublishObjects&gt;&#13;&#10; &lt;/Worksheet&gt;&#13;&#10; &lt;Worksheet ss:Name=&quot;Sheet2&quot;&gt;&#13;&#10;  &lt;WorksheetOptions xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;   &lt;TopRowVisible&gt;0&lt;/TopRowVisible&gt;&#13;&#10;   &lt;LeftColumnVisible&gt;0&lt;/LeftColumnVisible&gt;&#13;&#10;   &lt;ProtectObjects&gt;False&lt;/ProtectObjects&gt;&#13;&#10;   &lt;ProtectScenarios&gt;False&lt;/ProtectScenarios&gt;&#13;&#10;  &lt;/WorksheetOptions&gt;&#13;&#10; &lt;/Worksheet&gt;&#13;&#10; &lt;Worksheet ss:Name=&quot;Sheet3&quot;&gt;&#13;&#10;  &lt;WorksheetOptions xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;   &lt;TopRowVisible&gt;0&lt;/TopRowVisible&gt;&#13;&#10;   &lt;LeftColumnVisible&gt;0&lt;/LeftColumnVisible&gt;&#13;&#10;   &lt;ProtectObjects&gt;False&lt;/ProtectObjects&gt;&#13;&#10;   &lt;ProtectScenarios&gt;False&lt;/ProtectScenarios&gt;&#13;&#10;  &lt;/WorksheetOptions&gt;&#13;&#10; &lt;/Worksheet&gt;&#13;&#10;&lt;/Workbook&gt;&#13;&#10;">
 <p style='margin-top:100;font-family:Arial;font-size:8.0pt'>To use this Web
 page interactively, you must have Microsoft. Internet Explorer 4.01 Service
 Pack 1 (SP1) or later and the Microsoft Office XP Web Components.</p>
 <a href="file:///\\files\owc\setup.exe">Click here to install the Office XP
 Web Components.</a>
 <p style='margin-top:100;font-family:Arial;font-size:8.0pt'>See the <a
 href="http://office.microsoft.com/office/redirect/10/MSOWCPub.asp?HelpLCID=1033">Microsoft
 Office Web site</a> for more information.</p>
</object></div>


<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>

</html>
0
 
LVL 40

Expert Comment

by:RQuadling
ID: 7791564
See

http://www.flight1721.co.uk/Book1.htm (no interactivity)

and

http://www.flight1721.co.uk/Book2.htm (with interactivity)

I have excel installed locally. You may find that Book2 does not work if you do not have excel installed.

Richard.
0
 
LVL 8

Expert Comment

by:GEM100
ID: 7796474
Create a CSV file structure, output it to browser with excel headers, will be much more simple... Or create html file with proper use of tables, and pass it with excel headers, very easy to do. Try this. Make html file  with HTML table tags and rename it to xls. Opening it in excel will give you proper cells. You can also use formulas inside...
0
 
LVL 40

Expert Comment

by:RQuadling
ID: 7799204
Ha!

That is just what Excel does. The code that they add in though means you can do EVERYTHING that you do in Excel into your html file.

Colours/borders/styles/charts/etc.

Everything, including VBA code!

Richard
0
 

Author Comment

by:noura79
ID: 7828644
sorry for this looooong delay but i did it long time ago by using very simple code by using a code in php that downloads the database contents to a text document and changed the extension to exl.
0
 

Expert Comment

by:modulo
ID: 7830714
Dear expert(s),

A request has been made to close this Q in CS:
http://www.experts-exchange.com/Community_Support/Q_20485266.html

Without a response in 72 hrs, a moderator will finalize this question by:

 - Saving this Q as a PAQ and refunding the points to the questionner

When you agree or disagree, please add a comment here.

Thank you.

modulo

Community Support Moderator
Experts Exchange
0
 
LVL 40

Expert Comment

by:RQuadling
ID: 7838608
Ok.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 7853152
Saving this Q as a PAQ and refunding the points to the questionner

Thanks RQuadling !

modulo

Community Support Moderator
Experts Exchange
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Consider the following scenario: You are working on a website and make something great - something that lets the server work with information submitted by your users. This could be anything, from a simple guestbook to a e-Money solution. But what…
Deprecated and Headed for the Dustbin By now, you have probably heard that some PHP features, while convenient, can also cause PHP security problems.  This article discusses one of those, called register_globals.  It is a thing you do not want.  …
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now