Why my excel sheet is over writing the columns

Hi SrenivasanKanna Sir,

Yes Sir, there is two case number where I need to process those in websites to get the values…

1 Like

@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 !

2 Likes

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…

1 Like

can you post the screenshot of the next item, I mean below type into activity items?

2 Likes

Hi SrenivasanKanna Sir,

Workflow screenshot Sir…?

1 Like

@SOURAV_KUMAR_DAS yes please

2 Likes

Hi SrenivasanKanna Sir,

Sure Sir.

1 Like

Hi SrenivasanKanna Sir,

1 Like

@SOURAV_KUMAR_DAS,

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
image

2 Likes

Hi gulshiyaa,

Sure i will try it and let you know soon.

1 Like

Do you understand what am trying to say

2 Likes

Hi gulshiyaa,

Yes.

2 Likes

image

here use row.item(“causeList”) so that values will be written under the CauseList column

use the same format above the all write range

2 Likes

Hi gulshiyaa,

It’s not reading the second column of second data that’s case no…

1 Like

@SOURAV_KUMAR_DAS

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

2 Likes

Hi SrenivasanKanna Sir,

can you please elaborate me clearly Sir in a workflow…

1 Like

you gave row(“column name”).tostring???

2 Likes

Hi gulshiyaa,

Yes…

1 Like

Okay plz give me sometime . I will work with your workflow and let you know

2 Likes

Hi gulshiyaa,

Okay…

1 Like