Hello,

I have successfully used property expansion to read data from an Excel worksheet specified from a previous data source step (ref. ‘DataSource problem’, posted yesterday),  Now I would now like to write to an Excel spreadsheet using property expansion within a DataSink step, in the same manner.  Unfortunately, I receive a java exception “Failed to prepare testStep…”

e.g.: DataSink step contains the following property expansion in the Worksheet field:
${Excel data source – main worksheet#labelListWorksheet}

Results in:
java.lang.Exception: Failed to prepare testStep [Excel data sink - results]; java.lang.StringIndexOutOfBoundsException: String index out of range: 0


Thanks