I have a query regarding Export SQL and Report Data to EXCEL - V2 plugin. W

Certified Senior Developer
I have a query regarding Export SQL and Report Data to EXCEL - V2 plugin.
We are using this plugin to export data from CDTs to excel sheet. We have a template with 4/5 sheets and we are using multiple of these nodes to write data into each sheet. Most of the times it works correctly where as some times it start throwing errors like "Parse error for input string:"" " or "Sheet index (4) is out of range (0..0)". If I reduce some of the data then this works fine again. I don't have huge data being written ,well most of the times it results in a file of size ~20kb so I doubt if that's the issue here. Any inputs greatly appreciated.

OriginalPostID-204653

OriginalPostID-204653

  Discussion posts and replies are publicly visible

Parents
  • The error regarding java.lang.NumberFormatException: For input string: "" is being thrown by the code writing the arbitrary cell mappings you may have specified in the cell_keys and cell_values fields. Review these fields to resolve that error.

    As previously mentioned, the error regarding sheet index is out of range is caused by a sheet not existing for the sheet number input. Note that as per the plugin documentation the sheet input is zero-indexed.

    More information: forum.appian.com/.../o
Reply
  • The error regarding java.lang.NumberFormatException: For input string: "" is being thrown by the code writing the arbitrary cell mappings you may have specified in the cell_keys and cell_values fields. Review these fields to resolve that error.

    As previously mentioned, the error regarding sheet index is out of range is caused by a sheet not existing for the sheet number input. Note that as per the plugin documentation the sheet input is zero-indexed.

    More information: forum.appian.com/.../o
Children
No Data