Re: .xslx files and the million plus row problem

[Uten <uten null net>]

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.