Return
-
Title
'Select to file' export to Excel in automation overwrites entire contents instead of the worksheet. -
Description
'Select to file' export to Excel in automation overwrites entire contents of Excel workbook instead of the worksheet specified in the 'Advanced' properties. 'Overwrite file' is unchecked. This results in the loss of worksheets within the file.
-
Cause
Issue only occurs when a suffix is added to the output file -
Resolution
WORKAROUND
1. Do not select a Suffix in the 'select to file' activity
2. Add a 'copy file' activity to the task and add date suffix there
STATUS
Issue fixed in version 3.8. The latest release can be downloaded here.
-
Defect ID
QAT-5683