Excel Tools

We have index application where users will download the exceptions into excel and upload it back to appian.We are using "Parse Excel to CDT" plugin to read the excel content into CDT object. However "Parse Excel to CDT" plugin is failing when the excel file uploaded has empty rows at the end. We have upgraded the excel tools plugin to v1.9.11 as i can see from the release notes that the issue is fixed but still we are having the same issue. Can you  please help on this

10:30:31,227 INFO  [stdout] (Appian Work Item - 219162 - ProcessExec00 : UnattendedJavaActivityRequest) 2018-05-23 10:30:31,227 [Appian Work Item - 219162 - ProcessExec00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.exceltools.smartservice.ParseExcelFileToCDT -

10:30:31,228 INFO  [stdout] (Appian Work Item - 219162 - ProcessExec00 : UnattendedJavaActivityRequest) java.lang.NullPointerException

10:30:31,228 INFO  [stdout] (Appian Work Item - 219162 - ProcessExec00 : UnattendedJavaActivityRequest)        at com.appiancorp.ps.exceltools.smartservice.ParseExcelFileToCDT.run(ParseExcelFileToCDT.java:155)

Hi,

I am using "Export SQL to Excel" smart  service to export the data but getting the  error as " The following error was raised by the Export to Excel function: Row 0 has been flushed, cannot evaluate all cells".

I am getting this error when i tried to export more than 100 rows.Can you please check on this?

Thanks in advance!!

Hi wesj , Michael Chirlin updated the readme.pdf with this version of the Excel Tools plug-in. The download file now includes the updated documentation!

*Version 1.9.11 - 15May18

- Adding UTF-8 support

*Version 1.9.10 - 13May18

- Speeding up Export CDT to Excel

*Version 1.9.9 - 12May18

- Removing uniqueness constraint for backwards compatibility

*Version 1.9.8 - 9May18

- Fix bug with blank rows in Parse Excel File to CDT

*Version 1.9.7 - 8May18

- Fix bug with blank date fields failing to parse (Parse Excel File To CDT)

- Fix bug with blank template failing (Export SQL to Excel)

Hey, thanks for the great plug-in! Is there anyway you can update the documentation? Either updating the readme.pdf or provide a URL with the latest documentation would be great, particularly for the Parse Excel to CDT smart service.

*Version 1.9.6 - 1May18

- Allow csv import to have spaces in column headers

- Added smart service to convert html to csv (useful for old xls files which are actually html tables)

Hi Ben,  not particularly.  Having set the logging level to debug, I can see that the the plugin fails as soon as it enters the main try block of the run method.

We could be looking at a flawed installation (this is a new system)

Hi Richard , was Mike Cichy's answer to your discussion post helpful?

I've entered a question in the discussion forums.  But I'll ask it here  as well.  I cannot make this plugin work.  I have gone through all of the current discussions, and provided stack traces.  We've turned on debugging and examined the source to see where it may have a problem.

Is there any help to be had, or do we seek some other way of achieving our goals?