469,356 Members | 1,994 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,356 developers. It's quick & easy.

ASP(xlWorksheet.Cells) w/many text chars has #VALUE! error in XL s


I have an ASP page that loops through a SQL Server 2000 table, then
downloads an Excel sheet the users can save, etc. Works fine, except, I see
that in one particular "comments" field the Excel sheet returns a #VALUE!
error in the cell when there is a large amount of text. I've looked through
the MSKB, MSDN and many ng posts to see if there is a workaround or solution
to this, inclduing looking at the xlWorksheet properties (I've tried
'xlWorksheet.Cells(iRow, 11).WrapText = True), played with Orientation, etc.
But to no avail. Any help, suggestion or nod in the right direction would be
greatly appreciated.

Thanks in advance,
Jul 22 '05 #1
0 1224

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Tapiwa JONGWE | last post: by
5 posts views Thread by Sunshine | last post: by
1 post views Thread by dana lees | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.