Excel Tools

check if there are empty column after notes. If not copy the content data from the sheet and paste it into new sheet and try it out it might work.

Hello,

I am using "Import Excel to Database" smart service and getting an error  "???Unknown column '' in 'field list'???" while writing to the data base. When I check the logs its adding one null column by default, Can anyone please help me in understanding the cause for this error and how to fix it?

insert into `MyTableName` (`ID`, `EID`, `Name`, `Notes`,``) values (\'1\', \'2\', \'gh\',\'\')',1054

Hi Ze-Yang,

As noted in our Plug-in Policies, content is free and made available as-is. All plug-ins are use-at-your-own-risk, and their functionality is not guaranteed by Appian.

HI - similarly to Content Tools, it should work with newer versions thank the "Compatible Version(s):" listed. Compatible Version(s) is a referenced of what the author says they have tested with when submitting the app. Appian has great backwards compatibility, so newer versions than listed should not be an issue.

Is this plugin compatible with Appian 20.1?

Hi Ze-Yang, free apps on the AppMarket are developed and supported by Community contributors. You can comment on AppMarket listings with feedback or contact appmarket@appian.com for more information. If you have a patch, you can request permission to update another person's app and if granted submit the new version through our AppMarket Submissions site

AppMarket FAQ

AppMarket Submissions

May I know where to report the bug or provide a patch

Observe a bug, when import excel file failure, this tool still occupy database and block other database operation

When import a excel sheet with empty cell (in database this column is a integer type), get

Problem:  An error occurred in executing an Activity Class.
Details:  ???Incorrect integer value: '' for column 'CONTACT1' at row 1???

May I know this tool do not allow null value for integer? I test my database schema, column with integer type can be null