We Use Cookies

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with this.

See our cookie policy.

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