Hello, I recently needed to export the specified row data under a sheet of a certain Excel.
For this purpose, I used the Active Choice Parameters plugin to create 3 parameters
- Excel parameter, use Groovy script to obtain the Excel list dynamically
- Sheet parameter (Active Choices Reactive Parameter, reference Excel parameter), obtain the corresponding Excel sheet according to the Excel parameter value
- Data parameter, (Active Choices Reactive Parameter, reference Excel and sheet parameters), obtain the available row data under the specified Excel and sheet according to Excel and sheet parameters
When changing the option of Excel parameters, what I expect is:
Excel parameter value changes => Sheet parameter Groovy script executed update sheet option list => Data parameter Groovy script executed update data option list.
The problem is, that the sheet value, got by the Data parameter Groovy script, is outdated.
It’s still the one before the Sheet parameter refresh not after.
As a test, I added the ‘_sheet’ suffix to the workbook value for the sheet parameter, and the data parameter is the string concatenation of the workbook and sheet.
As shown in the figure below, the sheet value obtained by the data parameter does not match the current value of the sheet parameter.
Is there something wrong with my usage?