Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ibu
 
Posts: n/a
Default increasing the number of rows of a worksheet beyond 65536?

is it possible to increase the number of rows of a worksheet beyond 65536? if
yes, how? if no, any workarounds? I need to read in a text file in CSV format
with more than 1,000,000 lines.

thanks!
  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi

Split your file to several files with <65536 rows in each. You can use any
text editor, capable open your file, for this. Create a copy of original
file, and delete all rows except # first ones (# being the number of rows
you want to left in file). Then create a next copy of original file, and
delete # rows at top, and then all rows except # first ones, and so on.


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"ibu" wrote in message
...
is it possible to increase the number of rows of a worksheet beyond 65536?

if
yes, how? if no, any workarounds? I need to read in a text file in CSV

format
with more than 1,000,000 lines.

thanks!



  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

NO, that is the limit.

If you must read more, you will need to manage it manually, maybe split the
csv file and read them into multiple sheets, or read the CSV file in VBA and
place in on separate sheets. The first is definitely simpler.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ibu" wrote in message
...
is it possible to increase the number of rows of a worksheet beyond 65536?

if
yes, how? if no, any workarounds? I need to read in a text file in CSV

format
with more than 1,000,000 lines.

thanks!



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



All times are GMT +1. The time now is 03:37 PM.

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

About Us

"It's about Microsoft Excel"