Best way to open big data spreadsheets

85 views
Skip to first unread message

martin...@toroleo.de

unread,
Aug 14, 2013, 11:11:37 AM8/14/13
to ruby...@googlegroups.com
Hello together,

i am writing a small programm that parses csv, xlsx or ods files, creates db tables for them and seeds them into the tables.

The Problem i am facing atm is that it takes very long for roo to parse the spreadsheet and create the object. Is there a silver bullet how to do this for large input files?

Does it make sense to split the files beforehand or is there a format that renders roo to be significantly faster concerning the parsing? How would you do that?


Thanks in advance
Martin

Monserrat Foster

unread,
Oct 17, 2013, 3:03:53 PM10/17/13
to ruby...@googlegroups.com
Hello Martin I'm having the same issue, did you find a way to do it? 
Reply all
Reply to author
Forward
0 new messages