Ask HN: How would you chunk a large Excel file?

Let's say you had an Excel file with 10,000 rows and you wanted to break it up into many Excel files each with 500 records. Each new file should have the header fields from the original. How would you do it? I did it by writing a node script but I'm wondering if there's an easier way.

Edit: Guys this is just an example. I'm looking for a general solution. It could be 10 million rows.

Comments URL: https://news.ycombinator.com/item?id=40485185

Points: 7

# Comments: 13

https://news.ycombinator.com/item?id=40485185