I am looking to read a specific column of Excel in Appian. suppose I have 3 columns in Excel roll no. , name, and email. So, I want to read all the values in the column email as an array of Strings.
Discussion posts and replies are publicly visible
Hi ,
Please go through the Excel Tools plugin. You can read the excel sheet which is in Appian using a function readexcelsheetpaging in the plugin and from there you can index email column as array of strings
hii there I have tried readexcelsheetpaging but it is not working. the only readexelsheet function Is working but it returns all data in from of list of variants.
if we are getting all the details in the excel sheet, then we can use index function to index the particular column and get the required data and if it is in list of variants, use touniformstring() Function - Appian 23.3 to convert that to list of text
Have you tried excelreadcellsbyname() ?
Syntax: excelreadcellsbyname(<Document Id>, { 1 }, { "A1" })
not working
Unknown said:not working
I wouldn't necessarily expect it to work though since, per your screenshot, you haven't actually supplied the correct parameters for this rule call...
Also it looks as if the Sheet Number for this rule is 1-indexed, not 0-indexed (though annoyingly it doesn't specify in the rule info). Interestingly the sister function, excelReadCellsByNumber(), does specify this: