in an excel file,
cell A1 contains month value which is stored in rc1
cell A2 contains GL Acc which is stored in rc2
cell b2 contains gl acc value is stored in rc3
cell a3 contains gl description is stored in rc4
cell b3 contains gl description value is stored in rc5
in another excel file
cell A1 contains GL Acc
cell B1 contains GL Acc VALUE
cell c1 contains gl description value
cell C2 contains MONTH VALUE
HOW TO USE IF activty for this
like, if rc1 has month value it shouldread that cell orelse it should read c2 cell because in c2 the month value is present
could you please tell what is the requiremnt
and output that you need
I have to automate two excel files
first excel file has above mentioned cells
second excel file has below mentioned cells
By using read cell activity, i have read the cells and stored in variables and passed that cells to create columns and column values
but in second file,the cell values changed
how to solvee it
could you please provide sample input
still need to get clarity
Hi @anjani_priya ,
You can read file first to get data table, then check row.toString
if have value month
else get c2
but to clearly, can you share input file and your expect output
regards,
how to do if else for this
Can you explain more clearly, the picture above is the input and the picture below is the output or what?
pls clearly your requirements to quickly have solution
regards,
above is present in one excel
below is present in another excel
my requirement is that iam trying to automate excel file which has above cells iam reading that cells and making them as separate column
but in below cells changed
how to use if else in this condition?
I really don’t understand your request,
I understand that you need to read the value in excel using “read cell”
but in different files, the “cell” position changes and you cannot read it
that’s right?
Here, in my opinion, we need to divide the cases, what formats do we have
For each type, there will be a specific way to get it, or you can read the entire file, “read range” and then get each value according to the rules of each file.
hope it help,
I have done whole workflow by reading cells
i have read above cells because i have to create columns with 5 cells
this is one excel file
in another excel file the cells changed to.,
i have to automate both excel file at a time by creating columns of this cells
You can read range then check number of row columns
I have to use if else only because in 1st excel file I read cells in if else
Can you share your source and input file?
