Hi SrenivasanKanna Sir,
Yes Sir, there is two case number where I need to process those in websites to get the values…
Hi SrenivasanKanna Sir,
Yes Sir, there is two case number where I need to process those in websites to get the values…
@SOURAV_KUMAR_DAS no problem , we can not have the same column name in a sheet , Just change
caseNo
caseNo1
Then everything will be ok .
Cheers !
Hi SrenivasanKanna Sir,
My question is in that excel sheet it has only Casetype, caseno and year columns based on that it scraps the value from website and write it down in same excel sheet while writing, it’s again writing the caseno and year one more time Sir…
So what is the solution to avoid one more time rewriting…
can you post the screenshot of the next item, I mean below type into activity items?
Remove all the ranges which yo mention as A1,B1 etc… and keep it as empty “” like this in read range as well as write range
And after you getting some information use row.Items("column name where you want to insert the value under the column " and assign a variable
for example like this
Do you understand what am trying to say
here use row.item(“causeList”) so that values will be written under the CauseList column
use the same format above the all write range
I think you are not reading all the data , You have done only range of C1
In write range use Counter if you are not using loop.
Ex:
Assign Activity = Var_Counter =1
Write Cell Activity
“C” + Counter
Assign Activity
Var_Counter = Var_Counter +1
you gave row(“column name”).tostring???
Okay plz give me sometime . I will work with your workflow and let you know