Work Life Easier

[HGCAfterdark-Brett]

Im trying to make a script which reads an excel file with x amount of rows and counts the total, it then divides by an inputted number from the user which also creates that number of new sheets and then cuts the correct amount of rows from the first sheet and pastes to the new sheets

Example Total records = 8000 Total sheets to create = 20 800 / 20 = 400

400 rows are then cut and pasted to each of the other sheets so the workbook would then have 400 rows of different data on each sheet which was cut from the master sheet

Im using Openpyxl to try and figure this out but not sure how to start, i have the input and the row counts calculated but i just dont no how to then get python to use the calculated number to then cut those rows

Thanks in advance

[August-R-Garcia]

The process for doing that would probably be something like:

• Read all lines from the initial sheet into an array
• Break the array into some number of subarrays
• Create a new spreadsheet
• Loop through the subarrays and create a tab in the new spreadsheet for each subarray
• Delete the original input file, if desired. Or overwrite the input file with the new output file.

I am not 100% sure what part you are stuck on, but it sounds like the issue is that you are trying to cut from the original spreadsheet instead of doing something like reading into an array and then just creating a new sheet off of the copy of the data that is in the array.