New ask Hacker News story: Ask HN: How would you chunk a large Excel file?
Ask HN: How would you chunk a large Excel file?
2 by codingclaws | 3 comments on Hacker News.
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.
2 by codingclaws | 3 comments on Hacker News.
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
Post a Comment