Hi, I have attempted to open a 1232 line CSV file of 493KB in LibreCalc, and get an error message “The maximum number of rows has been exceeded. Excess rows were not imported!”
This is not a huge CSV, size or line-wise. Why has this occurred? Excel can handle much larger files. I thought Calc could handle around 65K lines.
LibreOffice 3, 3.4.5.2, build ID 350m1(build:2) running on LinuxMint 13
Thanks,
Greg
I’ll try to be more specific, but what do you need to know?
A not very large CSV file is simply choked LO at about line 1060 . It came out of a database dump.
Oh! OK, I didn’t understand what I was supposed to do with the (for f in seq 1 63000; do echo > “foobar,$f”; done) > foobar.csv, and that you suspected a corrupt source CSV. My CSV looks OK in a text editor. Nevertheless, I dumpted a fresh one, and it imported fine. So it apparently was a
problem with the CSV. If your code was to produce a 63k line text file, it did not, or I used it incorrectly. I simply pasted it into my console and executed. Only produced a 0 bype file and three 1 byte files. Suggestion? Thanks for your responses
May be there are too many separators in import (tab, comma, semicolon, space, …) Often the presence of “space” cause such problems
I’ll try to be more specific, but what do you need to know?
Did you create the example test file like I documented?
Have you loaded your failing CSV file into a text editor to look at the failing line?
Does it always choke on the same line?
(The probable cause is bad data in the CSV file that LO Calc barfs on.)
Can you be more specific? (In bash I created a simple CSV and LO 3.6.4.3 opened it instantly.)
This is how I created the test file:
(for f in
seq 1 63000; do echo > “foobar,$f”; done) > foobar.csv
@marietta_greg – Here’s similar code that works for me:
for f in `seq 1 63000`; do echo "foo,$f" >> foobar.csv; doneTwo notes – (1) I think that the AskBot text formatter ate some of @RonJon’s code, so that’s why it didn’t run. (2) There are some subtle differences in the way that comments and answers are parsed in the AskBot software…weird!
I got the same error, opening a .csv file in calc. The .csv file had quote marks (") delimiting all the text fields, as well as commas. I edited the .csv file, removing all the quote marks, and the error went away.
Time to upgrade … LibreOffice 3.4.5 is very old. Especially CSV import of files that do not strictly follow the CSV rules (and thus may have lead to “maximum number of rows exceeded” if for examples quotes don’t match or embedded quotes were not escaped) was significantly improved with LibreOffice 3.6, see https://wiki.documentfoundation.org/ReleaseNotes/3.6#Calc