Multiple spreadsheets in one HTML file in Excel 2000

[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

 

[Arvi Laanemets]

Hi

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.

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