Automation Action: Insert CSV into XLS File (97 - 2003)
Custom Action Available From Library
Inserts CSV data into a 97 - 2003 XLS sheet.
Requires a file to have already been created, and the worksheet name to be provided where the CSV will be inserted.
Please note:
- A new header row will be created at the top of the worksheet or where data first occurs within the sheet.
- If data is present within the first row, it will be overwritten. It is recommended to reserve the first row for headers and within cell A1 enter a placeholder value.
- Having the XLS file open within another program at the same time may cause errors.
System Requirements
This custom action requires the "Microsoft.ACE.OLEDB.12.0" driver to function. This can be downloaded here