Re: creating excel sheets through php

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

the code should basically work the same as with any scripting code, you'd
have to port and fix up but the concept should be the same across the board.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


"anagai" <andy.nagai@xxxxxxxxx> wrote in message
news:1158121066.331737.210990@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
hi

not sure if this is the right place but I cant find much documentation
on this subject. All I want to do is to create multi worksheet excel
files on the server running php. I have found some code that uses xml
to do this, but not sure how to modify the code to format cells in
different colors and other formatting.

this code is in the head section of the php page. The body of the page
contains a table of data. This will create a excel file of name
specified

anybody know how to modify this code, i really cant find any examples
of this code. Theres reference on knowledge base, but as usual its
totally useless.



<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=us-ascii">
<meta name=ProgId content=Excel.Sheet>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:LastAuthor>Sriram</o:LastAuthor>
<o:LastSaved>2005-01-02T07:46:23Z</o:LastSaved>
<o:Version>10.2625</o:Version>
</o:DocumentProperties>
<o:OfficeDocumentSettings>
<o:DownloadComponents/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
@page
{margin:1.0in .75in 1.0in .75in;
mso-header-margin:.5in;
mso-footer-margin:.5in;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
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;
border:none;
mso-protection:locked visible;
mso-style-name:Normal;
mso-style-id:0;}
td
{mso-style-parent:style0;
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:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl24
{mso-style-parent:style0;
white-space:normal;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>New Order</x:Name>
<x:WorksheetOptions>
<x:Selected/>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>10005</x:WindowHeight>
<x:WindowWidth>10005</x:WindowWidth>
<x:WindowTopX>120</x:WindowTopX>
<x:WindowTopY>135</x:WindowTopY>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->

</head>



.

Relevant Pages

  • creating excel sheets through php
    ... not sure if this is the right place but I cant find much documentation ... but not sure how to modify the code to format cells in ... this code is in the head section of the php page. ... anybody know how to modify this code, i really cant find any examples ...
    (microsoft.public.office.developer.web.components)
  • Re: advanced programming
    ... but I was leaving it to the OP to sort out. ... He could modify the IF statement a little bit to suit his needs. ... is over his head. ...
    (microsoft.public.access.modulesdaovba)
  • Styles versus themes
    ... I can't quite get my head around the interaction of styles and themes. ... What I want to do is modify a style, such as Heading 1, and then save that as part of a theme. ... What I want is to use the theme like a style sheet but can styles only be saved in the document or attached template? ...
    (microsoft.public.word.formatting.longdocs)
  • Re: Work around for un-editable recordset which utilizes the max aggregate function
    ... I'll just modify the above comments with one idea that popped into my ... head after thinking about this all night. ... that stores the item, sale date, and sale location. ... My only hesitation here is that I don't like building temporary ...
    (comp.databases.ms-access)
  • Re: Mod or no mod for old JMP?????
    ... jesus we modify the shit out of marshalls all the time ... some ideas from aluminum kitchen head, ... camel head, some from plexi, some from clones, ... modify vintage heads, we just study them. ...
    (alt.guitar.amps)