SetConnect

SplitXLS

File::SplitXLS
Description
Split one or all worksheets of an Excel workbook into separate workbook files.
Options
Excel file
The MS-Excel workbook (xls file).
Split All Sheets
If selected, all worksheets in the workbook will be extracted to individual workbook files.
Extract Sheet
If selected, the configured worksheet will be extracted to an individual workbook file.
Output Directory
The directory to which the workbook file(s) willl be saved. The filename will be the name of the extracted worksheet.
97-2003 / 2007
The format of the new workbook file. "97-2003 ..." will create an Excel 97-2003 compatible file (*.xls) and "2007 ..." will create an Excel 2007 or later compatible file (*.xlsx).

Documentation

Release notes