Excel

Split Workbook

3min

Overview

The Split Workbook action divides an input workbook into multiple workbooks based on a given row number.

Document image


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.



Updated 17 Apr 2024
Doc contributor
Doc contributor
Did this page help you?
PREVIOUS
Parse OLE Date
NEXT
XLS To XLSX
Docs powered by Archbee