Welcome Guest, Not a member yet? Register   Sign In
Reading large Excel files
#9

(08-14-2017, 11:51 PM)Paradinight Wrote: Wouter60 what about csv?

With csv Spout runs flawlessly. My csv-file is 33,800 rows, 15 columns. Spout reads it in 3.78 seconds! And a memory peak of only 3.75 MB.
The same table as an xlsx file won't import at all. I set the time limit to 600 (10 minutes). After that, I get a message that the time limit was exceeded.
My Excel file has only one worksheet. I tried the example Projack89 pointed out. Didn't work.

For now, I'm very happy with the csv option. It's lightning fast!
Thanks for helping me out.
Reply


Messages In This Thread
Reading large Excel files - by Wouter60 - 08-14-2017, 12:01 PM
RE: Reading large Excel files - by Paradinight - 08-14-2017, 12:15 PM
RE: Reading large Excel files - by InsiteFX - 08-14-2017, 12:23 PM
RE: Reading large Excel files - by Wouter60 - 08-14-2017, 01:04 PM
RE: Reading large Excel files - by dsivic - 08-14-2017, 01:23 PM
RE: Reading large Excel files - by Wouter60 - 08-14-2017, 02:03 PM
RE: Reading large Excel files - by Paradinight - 08-14-2017, 11:51 PM
RE: Reading large Excel files - by Wouter60 - 08-15-2017, 11:27 AM
RE: Reading large Excel files - by projack89 - 08-15-2017, 02:32 AM
RE: Reading large Excel files - by tksains - 08-23-2017, 08:36 PM



Theme © iAndrew 2016 - Forum software by © MyBB