#1   Report Post  
Zapiszsie
 
Posts: n/a
Default 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.
  #2   Report Post  
bj
 
Posts: n/a
Default

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   Report Post  
Zapiszsie
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing Hyperlink Shawn Excel Discussion (Misc queries) 2 May 16th 05 04:11 PM
Removing trailing spaces from cells ? Don Guillett Excel Worksheet Functions 0 April 10th 05 03:32 PM
How do I stop excel removing zeros? tomcat Excel Discussion (Misc queries) 2 January 21st 05 05:40 PM
Removing Hard Borders from Excel Spreadsheet Battery Dude Excel Worksheet Functions 1 January 11th 05 04:28 AM
Removing ' character from cells Don Excel Discussion (Misc queries) 5 December 21st 04 05:41 PM


All times are GMT +1. The time now is 11:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"