chris dunn-5 wrote:
>
> As has been noted in many random places the .xslx sheets contain over a
> million rows as a matter of course.
>
Is a spreadsheet supposed to be able to handle a million rows? I thought
there was a limit of 655xx on each sheet. So to handle the data you would
need something like 15-16 sheets and counting. Cut and past and handling all
the sheets *ugh*.
I'm not to fluent in the workings of gnumeric but as I understand it the
data may reside in a database and be pulled from there?
Depending on the task at hand would it be advisable to consider another tool
to process or preprocess your data? Something like R
(http://www.r-project.org/)? or maybe even awk?
I think I saw someone mentioning that the gnumeric file format is xml based,
so you should be able to create a gnumeric file with awk or your favorite
data processing language and gzip. Take a look at
http://projects.gnome.org/gnumeric/doc/file-format-gnumeric.shtml
Just a few thoughts.
Best regards
Uten
--
View this message in context:
http://old.nabble.com/.xslx-files-and-the-million-plus-row-problem-tp35023951p35028860.html
Sent from the GnuMeric mailing list archive at Nabble.com.
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
