Multiple worksheets in one Excel 2000 HTML file

X

xargon

Hi everyone,

I am programatically generating the data and saving it as HTML/XM
format of Excel 2000. Everything works fine but Excel 2000 seems t
need one HTML file per spreadsheet. What I would to do is have all th
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 ancho
defined in the same document.

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

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

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

Thanks for any help you might give me.

Sincerely,

Panka
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Update several ppt documents from a single excel file 0
HTML/XML format for Excel 2000. Multiple sheets in single HTML file 0
multiple worksheets in html - one file 0
Multiple spreadsheets in one HTML file in Excel 2000 1
Multiple excel spreadsheets in one HTML file 1
Cannot copy worksheet to another file 2
Excel-Html 0

Top