Exporting Html using php to Excel with multiple worksheets

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hdogg
    New Member
    • Mar 2007
    • 7

    #1

    Exporting Html using php to Excel with multiple worksheets

    I embed this on top of my pages:

    header("Content-Type: application/vnd.ms-excel");

    This makes it so my page downloads as Excel...

    However, I want more than one worksheet.
  • devsusen
    New Member
    • Feb 2007
    • 136

    #2
    Hi,
    using different header type will produce output in non-HTML format. but if u need Excel file with multiple worksheets u need to use some excel writer script. u can use PEAR - Excel writer for this purpose.

    Originally posted by hdogg
    I embed this on top of my pages:

    header("Content-Type: application/vnd.ms-excel");

    This makes it so my page downloads as Excel...

    However, I want more than one worksheet.
    susen

    Comment

    Working...