Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting HTM spreadsheet data to Excel
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting HTM spreadsheet data to Excel
I suspect the problem is with the webpage and not excel. I have donw a lot
of downloading of files to excel using the Internetapplication 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" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting HTM spreadsheet data to Excel
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. "Joel" wrote: I suspect the problem is with the webpage and not excel. I have donw a lot of downloading of files to excel using the Internetapplication 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting data to Excel | Excel Worksheet Functions | |||
Exporting Quickbooks Data into Excel | Excel Discussion (Misc queries) | |||
Exporting data to Excel | Excel Discussion (Misc queries) | |||
Exporting a simple excel spreadsheet to ACT | Excel Discussion (Misc queries) | |||
Exporting spreadsheet data | Excel Discussion (Misc queries) |