Export to Excel problem

[rwiegel]

I am using the following code to export to excel:

Response.ContentType = "application/ms-excel";
Response.AddHeader("Content-Disposition", "inine;filename=text.xls");
OdbcDataReader reader = cmd.ExecuteReader();

excelGrid.DataSource = reader;
excelGrid.DataBind();
excelGrid.RenderControl(writer);

On a few rows (3 out of 623), I receive an error that the cell data is
too large. A log file is created and the data it was trying to insert
is stored in the log file. The data is all around 980 character (with
spaces). This seems way to small to be the maximum characters allowed
in an excel cell.

Does anybody have any ideas?

Thanks in advance,

Ryan

 

[Mark Rae]

Does anybody have any ideas?

1) What is the "exact" error message?

2) Why are you using ODBC and not OleDb, AAMOI...?

 

[rwiegel]

1) What is the "exact" error message?

2) Why are you using ODBC and not OleDb, AAMOI...?

--http://www.markrae.net

Thanks for the reply.

1) The exact error is: HTML ERROR in Cell data too large

2) The mailhost claims they only support ODBC

 

[Mark Rae]

Thanks for the reply.

1) The exact error is: HTML ERROR in Cell data too large

2) The mailhost claims they only support ODBC

The mailhost...? What mailhost...? What are you actually doing here...?
Which line is generating the error...?

 

[Mike]

Get him Mark. . .

http://www.google.com/search?hl=en&q=Export+DataGrid+to+Excel+ASP.NET

theres all kinds of ways to export your datagrid to Excel and even make nice
and pretty charts.

Mike
'IGotYourDotNet'
http://igotyourdotnet.blogspot.com/

 

[rwiegel]

The mailhost...? What mailhost...? What are you actually doing here...?
Which line is generating the error...?

--http://www.markrae.net

The error occurs when opening the excel file....it is an excel error
and is not caught in as an exception in the code. Its not a problem
with ODBC because all of the data gets populated fine in the datagrid,
the only problem is when it gets exported to excel. Somebody told me
that excel can hold up to 32,000 characters, but can only display 1024
in the formula bar. How can I check if the data is there? And is it
usable?

 

[Mark Rae]

but can only display 1024 in the formula bar.

That's correct:
http://support.microsoft.com/kb/211580

How can I check if the data is there?

I don't think you can through the standard worksheet - it's probably
available to functions and VBA, though...

And is it usable?

Depends what you want to use it for...

And I still don't know why you're using ODBC...

Or what "mailhost" is, or what it has to do with this...

 

[rwiegel]

That's correct:http://support.microsoft.com/kb/211580


I don't think you can through the standard worksheet - it's probably
available to functions and VBA, though...


Depends what you want to use it for...

And I still don't know why you're using ODBC...

Or what "mailhost" is, or what it has to do with this...

--http://www.markrae.net

sorry i didn't mean mailhost i meant webhost

I believe my client wants to be able to do keyword searches on the
data in the excel.....can it still find data that can't be displayed?

 

[Mark Rae]

sorry i didn't mean mailhost i meant webhost

LOL! OK, but I *STILL* don't know why you're using ODBC...

I believe my client wants to be able to do keyword searches on the
data in the excel.....can it still find data that can't be displayed?

This clearly isn't an ASP.NET question - I suggest you post a message in the
Excel newsgroup...

 

[rwiegel]

LOL! OK, but I *STILL* don't know why you're using ODBC...


This clearly isn't an ASP.NET question - I suggest you post a message in the
Excel newsgroup...

--http://www.markrae.net

ok thanks for your help