Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hi,
I've got a problem with a file with 4 columns and many rows (approx. 30000). And the problem is that all data is in grid, and when I open this file it takes me more than 10 minutes (processor athlon 2600+, 768MB RAM) and IMHO it's too long. When the file is already opened I try to remove grid and save the file. And then opening the file takes a few seconds. And the question is: how can I decrease opening time of the file. I think that I can't use MS EXcel for opening and removing grid (time), and if anybody knows how to do this in other way i will be appreciate. I see two ways; first fastest application which open and remove grids (but which?) or second opening in some way this file without grids (plain data). Please help me. |
#2
![]() |
|||
|
|||
![]()
I appologize but what do you mean by the data is in "Grid"?
"Zapiszsie" wrote: Hi, I've got a problem with a file with 4 columns and many rows (approx. 30000). And the problem is that all data is in grid, and when I open this file it takes me more than 10 minutes (processor athlon 2600+, 768MB RAM) and IMHO it's too long. When the file is already opened I try to remove grid and save the file. And then opening the file takes a few seconds. And the question is: how can I decrease opening time of the file. I think that I can't use MS EXcel for opening and removing grid (time), and if anybody knows how to do this in other way i will be appreciate. I see two ways; first fastest application which open and remove grids (but which?) or second opening in some way this file without grids (plain data). Please help me. |
#3
![]() |
|||
|
|||
![]()
bj napisał(a):
I appologize but what do you mean by the data is in "Grid"? It means that all cells are bordered:) BUT i've already got a solution (data wasn't in excel xls format - somebody just wrote that(what i hadn't check earlier), but it was simply html code) and I wrote some procedure in delphi which converts html to csv. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing Hyperlink | Excel Discussion (Misc queries) | |||
Removing trailing spaces from cells ? | Excel Worksheet Functions | |||
How do I stop excel removing zeros? | Excel Discussion (Misc queries) | |||
Removing Hard Borders from Excel Spreadsheet | Excel Worksheet Functions | |||
Removing ' character from cells | Excel Discussion (Misc queries) |