Excel
Split Workbook
3min
overview the split workbook action divides an input workbook into multiple workbooks based on a given row number inputs & outputs \[i] excel workbook ( file ) the original excel workbook that will be split \[i] sheet name ( string ) the name of the workbook sheet that will be split \[i] rows number ( int ) the number of rows based on which the split is made (maximum 10000) for example, if you have a file with 8000 rows and 1000 inputs, you will split the excel workbook into 8 files \[o] workbooks ( list\<file> ) a list of workbook parts resulting from the split operation important notes ensure that the row number specified for splitting is within the limits of the workbook to avoid unexpected behavior