Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
12 replies
Subscribers
4 subscribers
Views
5615 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
I have a query regarding Export SQL and Report Data to EXCEL - V2 plugin. W
deeptip
Certified Senior Developer
over 8 years ago
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
0
Tom Ryan
Appian Employee
over 8 years ago
Can you post the complete error that you are seeing, including the stack trace?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
deeptip
Certified Senior Developer
over 8 years ago
2016-04-05 10:20:39,260 [http-/0.0.0.0:8080-4] ERROR com.appiancorp.analytics.excel_export.ExportCdtToExcel - java.lang.NumberFormatException: For input string: ""
java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:592)
at java.lang.Integer.parseInt(Integer.java:615)
at com.appiancorp.analytics.excel_export.ExportHelper.getCell(ExportHelper.java:41)
at com.appiancorp.analytics.excel_export.ExportCdtToExcel.run(ExportCdtToExcel.java:102)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
deeptip
Certified Senior Developer
over 8 years ago
the other one..
2016-04-05 10:20:39,320 [http-/0.0.0.0:8080-4] ERROR com.appiancorp.analytics.excel_export.ExportCdtToExcel - java.lang.IllegalArgumentException: Sheet index (4) is out of range (0..0)
java.lang.IllegalArgumentException: Sheet index (4) is out of range (0..0)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.validateSheetIndex(XSSFWorkbook.java:1043)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.getSheetAt(XSSFWorkbook.java:834)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.getSheetAt(XSSFWorkbook.java:67)
at com.appiancorp.analytics.excel_export.ExportCdtToExcel.run(ExportCdtToExcel.java:94)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tom Ryan
Appian Employee
over 8 years ago
Is this the latest version of the plugin from Forum?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
deeptip
Certified Senior Developer
over 8 years ago
Yes,Export SQL and Report Data to EXCEL - V2
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
siddharthg837
over 8 years ago
Hi Deepti - regarding your error - "Sheet index (4) is out of range (0..0)" - its because the input you are passing in your sheet number input of the service is 4, however the template/document used in this service doesn't have 4 sheets defined probably.
In terms of volume of data - whats the volume we are trying to pull in here?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
deeptip
Certified Senior Developer
over 8 years ago
The template has the required number of sheets. As I said, this works when no. of rows are reduced.Volume of data is not very high, somewhere between 100-150 rows in one tab and <10 rows in the other tabs
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sachin Pandey
A Score Level 1
over 8 years ago
That's an acceptable amount of data for the excel. Are you using the latest version of the plugin?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
deeptip
Certified Senior Developer
over 8 years ago
Yes we are.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tom Ryan
Appian Employee
over 8 years ago
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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>