increasing the number of rows of a worksheet beyond 65536?

[ibu]

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!

 

[Arvi Laanemets]

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.

 

[Bob Phillips]

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)