Sending Excel 97/XP/2000/2003/2007 Output from ASP.NET 2.0

re: Sending Excel 97/XP/2000/2003/2007 Output from ASP.NET

hova — Tue, 20 Feb 2007 21:25:21 GMT

How do you solve the green triangle problem with this method? I've used it before, even with the mso: declarations, and it randomly get green triangles with the error "This number is stored as text!".

It's completely random too, it only works for some data sets of a particular size, and the starting point is random as well.

The only foolproof way I could think of working around it was outputing and redirecto to .csv files.

re: Sending Excel 97/XP/2000/2003/2007 Output from ASP.NET

rob — Thu, 10 May 2007 16:36:32 GMT

Hi i know it's a bit late but when i was solving the same problem you have with the green triangle i found a solution and so here it is:

<td align=right style='width:46pt' x:num> any_number </td>

re: Sending Excel 97/XP/2000/2003/2007 Output from ASP.NET

Annoyed — Wed, 25 Jul 2007 22:14:06 GMT

Please modify the title to "Sending Excel 97/XP/2000/2003/2007 Output from ASP.NET 2.0".

...some of use are still working with the 1.1 Framework.

re: Sending Excel 97/XP/2000/2003/2007 Output from ASP.NET 2.0

mab — Fri, 27 Jul 2007 17:54:03 GMT

Apologies for not being clear. In light of all the changes -> .Net 2.0, 3.0, and upcoming 3.5 it is important to understand which version.

You could achieve a similar affect using .net 1.1 it just takes a little more effort :)

re: Sending Excel 97/XP/2000/2003/2007 Output from ASP.NET 2.0

nmah — Thu, 27 Dec 2007 00:23:02 GMT

Mark, what can be done to 'easily' eliminate the msgbox that appears when trying to extract data from a website to excel? It all worked just fine in xp, but vista has issues.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1772697&SiteID=1