It is necessary to extract data from several cells of excel files into one. It was possible to implement reading cells, but the writing is incorrect, since it writes only the last value. Help me please. What am I doing wrong?
[image]
[image]
Hi @sereganator, are u reading the cell from each excel cell and writing to CardsClient.xlsx?
Hi!
I am reading a fixed cell (E11) from multiple excel files. It needs to be written to CardsClient. But only the last value is recorded.
Then do this way
-
First use assign activity to get list of filepath from folder using directory.GetFiles(filepath) assign to ListFiles array
-
Then assign a string variable lets say strvar with value as “”
-
then use for each to loop through each file in listFiles array
inside the for each do the following
a. First read the cell and store in Limit variable
b. then use assign activity like this strvar = strvar+Limit
Then after exiting the loop use write cell to write the strvar variable to the excel file u need to write
Hope it helps you
Mark it as solution if it works
Regards
Nived N
Happy Automation
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.