I go through the this link
How to split spreadsheet into multiple spreadsheets with set number of rows?
But I have few queries how to set base file path and how to call this function. I am new to ubuntu so please help me
Asked
Active
Viewed 278 times
0
-
Well for a start you don't do it from Ubuntu. The answers in the question you link to use Visual Basic which _is run from inside MS Office_. – DavidW Apr 06 '20 at 17:37
-
@DavidW But my requirement is do it in ubuntu – Akhilesh Jha Apr 06 '20 at 18:06
-
Then I don't think the answers in the question you linked will help you at all – DavidW Apr 06 '20 at 18:19
-
@DavidW Could you please help me. My requirement is to process xlsx file which may have more than 3 Million record that why I want to break it so that I can process it in small chunks – Akhilesh Jha Apr 06 '20 at 18:22
-
I don't know the answer, sorry. – DavidW Apr 06 '20 at 18:48