How to Read a particular column of excel ?

Forum|Forum|2 years ago
November 1, 2023
8 replies
0 views

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.

sriramk5349

Hi [mention:2d5cace542ae452882204fceb9f73b45:e9ed411860ed4f2ba0265705b8793d05],

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

V

vishalk3971Author

Participating Frequently

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.

sriramk5349

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

Sign up

Login with SSO

Login to the community

Login with SSO