Creating spreadsheets with asp.net - How name them?

[WISEMANOFNARNIA]

I have code in asp.net that is supposed to create a spreadsheet. It
works for some people, but others complain that the spreadsheet has no
'sheet1', and instead they are told it has an 'illegal sheet name'.
So I experimented: I thought the XML for the spreadsheet could start
with a tag like <sheet name='MyFirstSh eet'>. But putting that tag in
doesn't make a difference. In fact, I don't even know if the tag
exists in some kind of Excel xml language.
Does anyone have an idea of how I would specify a name for a sheet?
(technical note - I am using asp.net's Response.Write and passing it
xml)
Thanks,
Marvin

[Alexey Smirnov]

Re: Creating spreadsheets with asp.net - How name them?

On Oct 16, 5:32 pm, WISEMANOFNARNIA <COHENMAR...@ly cos.comwrote:

I have code in asp.net that is supposed to create a spreadsheet.  It
works for some people, but others complain that the spreadsheet has no
'sheet1', and instead they are told it has an 'illegal sheet name'.
So I experimented: I thought the XML for the spreadsheet could start
with a tag like <sheet name='MyFirstSh eet'>.  But putting that tag in
doesn't make a difference.  In fact, I don't even know if the tag
exists in some kind of Excel xml language.
Does anyone have an idea of how I would specify a name for a sheet?
(technical note - I am using asp.net's Response.Write and passing it
xml)
Thanks,
Marvin

Hi Marvin

Use Excel XML Schema Namespace and <ExcelWorksheet together with
<Nametags.

Examples:

http://support.microsoft.com/kb/271572

http://forums.codecharge.com/posts.php?post_id=83069

http://www.google.com/search?hl=en&rls=com.microsoft%3Aen-US&q=urn%3Aschemas-microsoft-com%3Aoffice%3Aexcel+ExcelWorksheet

Hope this helps