Exporting HTM spreadsheet data to Excel

[Al]

We have found that when trying to export a large HTM file to Excel format
that some columns get shifted after about 2100 rows of data

Anyone else have that problem?

Both IE6 and IE7 were tested and produced the same column shifting

Any suggestions?

Thanks
Al

 

[Joel]

I suspect the problem is with the webpage and not excel. I have donw a lot
of downloading of files to excel using the Internet>application tool and find
more inconsistency with the HTML than with Excel.

If you don't need formating to be downloaded, it is probably better to
download to CSV and then import the CSV into excel.

 

[Al]

Thanks for the reply. I will pass that on to the client.

Unfortunately in this case, the client is generating the HTM code from SAS
and I don't know how easy it will be for them to make that change to a CSV
file instead. They may need the HTM format for the web interface part of the
system. Maybe they could double up the routine and generate two separate
outputs, one to HTM (which looks fine with IE) and one to CSV for the Excel
part of their system.

The part that bothers us is the fact that IE displays the data perfectly, it
is the Export to Excel that doesn't work properly after about 2100 rows.