Hi All,
I have an error where my excel for the first time scans the data from excel sheet searches in the website and get those values and write it in the excel sheet…but the same column is over written in the excel sheet and returns as already those column exists…
First excel sheet scan
Second excel sheet scan
There are two caseNo on the second excel sheet. Please check and change the column name.
Regards,
Srenivasan Kannan
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
ashokkarale
Anil_G
Yoichi
yangyq10
postwick
chandreshsinh.jadeja
aravindbalineni123
Parvathy
aya
PRASHANT_GABHANE