Excel Tools

Could you please help us on limitation of Import Excel to Database plugin in terms of Max col and Max row

• Upgraded log4j-core and poi-ooxml to fix status logger error and vulnerability fix.

Hello,

Was readexcelsheet function replaced by readexcelsheetpaged in the last version of the plugin?

Thanks in advance.

Hello,

Can we use Import Excel to Database smart service for Confidential-Internal classified excel document?

Thanks in advance.

Hello,

Could you please confirm whether this plugin is compatible with version 24.4?

Thank you in advance.

• Updated to Java 17 (min version now 24.2)
• Can now use excel functions on temporary documents before they are submitted on a form
• Added a new readExcelByHeaders function to enable advanced Excel data extraction based on header matching. This function supports exact, synonym, and fuzzy matching, includes regex-based header normalization, and allows for configurable matching rules to enhance data processing flexibility.

We are using the Excel tools plugin to read data from an uploaded excel file into a database table. The plugin is reading the display value of a cell instead of the actual value. For ex. Display value is 0 for actual value 0.003.

Current readexcelsheetpaging function will read the display value only. Can we request a new function (eg. readexcelsheetpagingwithRealValue) to get real value ?

Hi Sajai Swaminathan  did you find any solution for this.

Good Day Everyone!

I have a messy excel file as a input file and i need only relevant fields from that. Below is the file and need only the highlighted data to proceed further with the process. Can anyone help me on this ? 

Desired Output

You can use a connected system with all plugins by using docs.appian.com/.../fnc_system_a_getDataSourceForPlugin.html