ASP/VBScript generated Excel file is blank

Question

I have a bit of code that I've used many times to export an HTML table into an Excel file, and it works fine. But now I have a new report that I need to be able to export that works fine when viewed as an HTML page, but viewed in Excel the entire spreadsheet is blank - no grid, no data, nothing.

The above is the code I'm using, and there are no logic errors on the page that prevents it from being shown. Has anyone else had this issue, or knows how to solve it?

And before someone asks, yes. I've tried using CSS to show black text and borders, with no luck.

D'Arcy Rittich · Accepted Answer · 2010-08-19 16:43:33Z

1

It could be that you are including HTML or BODY tags. Make sure you are only using TABLE, TR and TD tags, as I have had problems with using HTML and BODY tags in the past.

answered Aug 19, 2010 at 16:43

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

tjsimmons Over a year ago

Holy crap, that did it. I've NEVER had this problem before, and I always included the HTML and BODY tags, for good style. Thanks.

tjsimmons Over a year ago

Aye, I had to wait for the timer to countdown, which happened while I was on lunch. Thanks again.

Collectives™ on Stack Overflow

ASP/VBScript generated Excel file is blank

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related