Re:Displaying recordset in excel -date sort failing

[abhi1024]

I have an asp page and I am using the ContentType method of the Response object to displaying the recordset in excel.The problem I am having is that the excel file generated has everything format type set to general.The recordset generated contains date, and when users are trying to sort the excel file using date,its treating date as general and sorting is failing.
I havent been able to find any help on the internet.Can I cast the field to set it to certain data type
Please help
Thanks
Abhishek

 

[mwolf00]

I have a dynamically created excel file where the date sort works just fine -

Here's the line from my SQL Server SP

'<td>' + convert(varchar(20), r.datetimecreate, 1) + '</td>'

It's just text but excel knows to make it a date...

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

Tsunami Relief Inform​

 

[abhi1024]

The problem is when trying to display the recordset in a web page the sort works fine , its just when displaying in excel , it treats date as text .
When I try to format any of the cell in excel , it doesnt seem to let me manually change the type from general to anything (number,text etc

 

[Lothario]

Then why dont you sort the records before sending them to excel sheet...

I mean do the sort in the query itself and then display on the excel sheet...

-L

 

[abhi1024]

I already have a sort option,but the users need to sort more than once