Hi, i’ve a simple flowchart that open a dialog to select an excel file, read the B column from 2 to last row, add item readed into an array. How i can do this? The select file and read cell it’s done. But how i can read from specific cell (B2) to the last cell of B column? And how i can store the…

@Danny_Gi Welcome to the forum give a try on following part flow, we assume a string array will work (0therwise we adopt) read range - read the excel (all rows) to a datable - YourDataTableVar assign activty left side: arrColVals - datatype: String() - String array right side: YourDataTableVa…

Read column from excel then add to an array

Help Activities

prasath17 (Guru) March 16, 2021, 1:25pm 15

@Danny_Gi - Please check this post…

I guess, this is what you are looking for…In this post, I have first converted the datatable (one column) into an array later used that array in the input dialog acitivity(which you can ignore)

Topic		Replies	Views
Excel file to string array Help excel , activities , variable , question	5	1850	December 18, 2019
Read Excel in String Array Dynamically Forum datatable , excel , question	3	598	July 21, 2022
Read data from a column and assign it to array of string Help	11	7075	October 10, 2022
Read each excel cell and save it to an array Help excel , activities	1	3848	August 11, 2017
Excel: Read Column Help excel , activities	10	14469	October 29, 2018

Most Active Users - Yesterday
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu
More details...

Read column from excel then add to an array

Related Topics