increasing the number of rows of a worksheet beyond 65536?

I

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!
 
A

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.
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top