Excel Tools

Hi sandhyam0001 and amitb0004  - I would suggest posting in Discussions https://community.appian.com/discussions/ if you have a question.  Your question will get the most visibility that way!  

while importing application it gives me an error>>>

"The specified file does not contain a valid package and cannot be imported. (APNX-1-4154-000)"

Hello,

Could you please redirect us to latest documentation/readme.pdf?

Hi Corrado de Candia where can we find more documentation of the plugin? Like a User Guide. Thanks !!!

When will you re-add the ability to take an arbitrary set of data, do appian-side processing/transformation to it, and write the result easily to an Excel file complete with word wrap enabled on the written cells?  The only previous way to do all of this was the Export CDT to excel, now removed, with no functional replacement at all.

I know I could create a scrap DB table with arbitrary text columns and write data to it, then invoke it with the SQL to excel smart service, but even this super cumbersome approach still doesn't (as far as I'm aware) contain the way to set / preserve word wrap on filled cells.

Hello,

We have upgraded to the latest version of this plug-in and encountering 'ERROR com.appiancorp.ps.exceltools.smartservice.ImportCsvToDatabase - Invalid object name' issue for the tables that were defined under a schema. It was working before. Kindly resolve the same.

Can we add documentation for the new functions and smart services added? THe one included does not have docs for Import Excel to Database

* Version 2.2.0  - 09 Nov 18

- Added Convert Excel to CSV Smart Service

- Added Import Excel to DB Smart Service

- Added LOAD CSV to DB Smart Service - fast CSV import for MySQL database that are not hosted on Appian Cloud

- Import CSV to DB can now decrypt EncryptedText fields (for importing into external DS)

- Deprecated CDT to/from Excel, Export Report, Export Excel Servlets (existing use will continue to work)

hi - I am using Import CSV to Database smart service and facing issues with some of the rows/records in the CSV.  

For one of the records it  give NumberFormatExceptions e.g "VALE SA-SP ADRCLIENT REF  41807091" .

Plug-in is not able to read entire string instead it gives me  java.lang.NumberFormatException: For input string: "CLIENT REF  41807091"" . In DB(MySQL) I am capturing this field as VARCHAR (35) .

Is there any limitation in terms of data/text which should be in CSV file ?

Please suggest !

@Agustinc - I took a closer look at the error and I agree with Mike.

The function that you are using is reading an Excel file, loading the content of a sheet into memory in the application server and converting this content into a dictionary that is then returned by the function. All of this processing and data transformation is handled by the application using heap memory.

Depending on the size of the spreadsheet, this is known to consume a lot of memory and in some cases, lead to a error when running out of memory. However, this does not indicate a defect.

I am not familiar with your use case but in general, I recommend against loading large amounts of data in Appian processes or expressions. The pattern I have used successfully in the past is to load the data from a spreadsheet directly into a database table - using the plugin Import CSV to Database - and then process this data in small batches. This prevents spikes in memory.

I hope this helps.