KSmith
17 years agoOccasional Contributor
DataSink property expansion problem
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
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