Removing grids
 

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.

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.

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.