CodeToad Forums » ASP » how to display large data in .xls file without the data getting hidden
|
|
|
I'm generating an excel sheet from ASP file using the below code :-
Response.ContentType = "application/vnd.ms-excel"
<HTML xmlns:x="urn:schemas-microsoft-com:office:excel">
One of the columns in that excel displays large data (>2000 chars)...so wat we have done is .........
written a function to restrict the first 650 chars in the column n then the next 650 in the next row....and so ..on...it keeps on appending new rows.......
The problem is some data is going below the border(bottom) of the column that it is getting hidden...........how do we avoid this?
plz let me know if any solution available.
Thanks in advance.
|
|
|
|
|
|
|
|