By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,288 Members | 3,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,288 IT Pros & Developers. It's quick & easy.

Export to Excel From ASP: Text Data Interpretation issue

P: n/a
Hi,
I am using an export to excel functionality from my ASP
page.
I have set the content type as

Response.ContentType = "application/vnd.ms-excel"
The data i am exporting has values like 1-2, 2-5
Now when they get exported to excel, these values get
exported as 1-02-2003,2-05-2003.

This is a feature of excel.
To overcome it in excel we usually put single quotes
before the data so that it gets interpreted as text data
i.e '1-2, '2-5. The single quotes are not visible to the
user and the data is shown as 1-2,2-5 to the user. The
single quotes are visible only when the user clicks on the
individual cell.

But when i export it from ASP page as '1-2, '2-5, these
single quotes remain visible in the excel page. I thought
the single quotes should not have been visible to the user.
They disappear only when we manually double click the cell.
Could someone plz let me know how to overcome this issue
programatically?

Cheers
Saur
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Try outputting:

="1-2", ="2-5", etc...

(those are double quotes).

Regards,

Alan

"Saur" <sa*********@hotmail.com> wrote in message
news:02****************************@phx.gbl...
Hi,
I am using an export to excel functionality from my ASP
page.
I have set the content type as

Response.ContentType = "application/vnd.ms-excel"
The data i am exporting has values like 1-2, 2-5
Now when they get exported to excel, these values get
exported as 1-02-2003,2-05-2003.

This is a feature of excel.
To overcome it in excel we usually put single quotes
before the data so that it gets interpreted as text data
i.e '1-2, '2-5. The single quotes are not visible to the
user and the data is shown as 1-2,2-5 to the user. The
single quotes are visible only when the user clicks on the
individual cell.

But when i export it from ASP page as '1-2, '2-5, these
single quotes remain visible in the excel page. I thought
the single quotes should not have been visible to the user.
They disappear only when we manually double click the cell.
Could someone plz let me know how to overcome this issue
programatically?

Cheers
Saur

Jul 19 '05 #2

P: n/a
Hi,
Thanks a lot.
This seems to work.

Cheers
Saur
-----Original Message-----
Try outputting:

="1-2", ="2-5", etc...

(those are double quotes).

Regards,

Alan

"Saur" <sa*********@hotmail.com> wrote in message
news:02****************************@phx.gbl...
Hi,
I am using an export to excel functionality from my ASP
page.
I have set the content type as

Response.ContentType = "application/vnd.ms-excel"
The data i am exporting has values like 1-2, 2-5
Now when they get exported to excel, these values get
exported as 1-02-2003,2-05-2003.

This is a feature of excel.
To overcome it in excel we usually put single quotes
before the data so that it gets interpreted as text data
i.e '1-2, '2-5. The single quotes are not visible to the user and the data is shown as 1-2,2-5 to the user. The
single quotes are visible only when the user clicks on the individual cell.

But when i export it from ASP page as '1-2, '2-5, these
single quotes remain visible in the excel page. I thought the single quotes should not have been visible to the user. They disappear only when we manually double click the cell. Could someone plz let me know how to overcome this issue
programatically?

Cheers
Saur

.

Jul 19 '05 #3

P: n/a
check out http://www.greggriffiths.org/webdev/both/excel/ which covers
this topic.

saur wrote:
Hi,
Thanks a lot.
This seems to work.

Cheers
Saur
-----Original Message-----
Try outputting:

="1-2", ="2-5", etc...

(those are double quotes).

Regards,

Alan

"Saur" <sa*********@hotmail.com> wrote in message
news:02****************************@phx.gbl...
Hi,
I am using an export to excel functionality from my ASP
page.
I have set the content type as

Response.ContentType = "application/vnd.ms-excel"
The data i am exporting has values like 1-2, 2-5
Now when they get exported to excel, these values get
exported as 1-02-2003,2-05-2003.

This is a feature of excel.
To overcome it in excel we usually put single quotes
before the data so that it gets interpreted as text data
i.e '1-2, '2-5. The single quotes are not visible to the user and the data is shown as 1-2,2-5 to the user. The
single quotes are visible only when the user clicks on the individual cell.

But when i export it from ASP page as '1-2, '2-5, these
single quotes remain visible in the excel page. I thought the single quotes should not have been visible to the user. They disappear only when we manually double click the cell. Could someone plz let me know how to overcome this issue
programatically?

Cheers
Saur

.


Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.