473,320 Members | 1,990 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Creating spreadsheets with asp.net - How name them?

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='MyFirstSheet'>. 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
Oct 16 '08 #1
1 1150
On Oct 16, 5:32*pm, WISEMANOFNARNIA <COHENMAR...@lycos.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='MyFirstSheet'>. *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 <ExcelWorksheettogether 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&r...ExcelWorksheet

Hope this helps
Oct 16 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Alan | last post by:
Hi there, Are there Excel charting gurus here?? If so then please read on... Sorry for the cross-post but I'm not familiar with the Excel groups. I've posted to asp.general because if I have...
5
by: Guy Incognito | last post by:
Hello, I've written an asp.net application that creates Excel documents. It works by creating an excel document in XML format. But I wonder if I'm reinventing the wheel. I know that there are...
2
by: Jim S | last post by:
To my surprise and chagrin, newer versions of Access have disabled the functionality that lets users change the data in linked tables that point to a range in an Excel workbook. This is "because of...
2
by: rdemyan via AccessMonster.com | last post by:
I currently have code that brings up a form where the user can see a list of spreadsheets on my ftp site, select one and then download and import the spreadsheet into a table. All of this...
1
by: Mitch | last post by:
I am using Access to create an Excel spreadsheets with graphs related to rows on the sheet1 to the graph on sheet2. I am using the same data but different subsets of the data to make different...
1
by: dsbsnag | last post by:
I am using Access 2003 on Windows XP I'm a school teacher and need help achieving the following: I have three spreadsheets with various information in them. But, they have a common cell named...
11
by: Andy Burchill | last post by:
Hi there, I am trying to find out what the best way of creating an excel spreadsheet is, this will need to be done dynamically by an aspx website on the server side. The main way would be to...
7
by: jkwok | last post by:
Hi, I have a spreadsheet which I've imported into one table, 'Assets', in Access. In the table, I have to separate the data based on one attribute: 'empID'. empID is the employee ID and can occur...
0
by: Emile van Sebille | last post by:
Greg Lindstrom wrote: Here's some code from years back that adds sheets to a workbook and then renames them. Sheets = , , ] replist =
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.