Multiple spreadsheets in one HTML file in Excel 2000

  • Thread starter Thread starter Pankaj
  • Start date Start date
P

Pankaj

Hi everyone,

I am programatically generating the data and saving it as
HTML/XML format of Excel 2000. Everything works fine but
Excel 2000 seems to need one HTML file per spreadsheet.
What I would to do is have all the sheets in one HTML
file. However, I have not been able to do so.

I have tried setting the x:WorkSheetSource HREF property
to an anchor defined in the same document.

<x:WorksheetSource HRef='#myanchor'/>

However, excel takes all the data after the xml tag and
renders it on the same sheet.

Does anyone know of a way to have all the data in one HTML
file. I do not need IE to render the file correctly, just
Excel 2000.

Thanks for any help you might give me.

Sincerely,

Pankaj
 
Hi

Pankaj said:
Hi everyone,

I am programatically generating the data and saving it as
HTML/XML format of Excel 2000. Everything works fine but
Excel 2000 seems to need one HTML file per spreadsheet.
What I would to do is have all the sheets in one HTML
file. However, I have not been able to do so.

I have tried setting the x:WorkSheetSource HREF property
to an anchor defined in the same document.

<x:WorksheetSource HRef='#myanchor'/>

However, excel takes all the data after the xml tag and
renders it on the same sheet.

Does anyone know of a way to have all the data in one HTML
file. I do not need IE to render the file correctly, just
Excel 2000.
Click to expand...


I'm afraid you can do nothing about it! HTML pages (and an Excel file saved
as HTML is a web page) doesn't have tab's - every web page is a separate
file
 
Back
Top