Write range Wrkbook activity

[runkrithik]

In studiox, I could not able to enable write range workbook activity. Due to this, i could not able to copy a column/range from one excel workbook to another.
Please give me a solution.
Thanks in advance.

[Sudharsan_Ka]

HI @runkrithik

Welcome to community!

Checkout this thread

Copy Excel sheet from A.xlsx to B.xlsx (without read/write range to preserve format)

Hi @Ludwig_Wilhelm You can use copy paste range in modern excel activities like Excel process Scope Use excel file 1(A.xlsx) reference as Excel Use excel file 2(B.xlsx ) reference as Excel 1 copy paste range of modern Source will be ->Excel.Sheet(“sheet-ABC”) Destination will be ->Excel1.Sheet(“sheet-ABC”) And set what to copy as “All” To enable the modern Activities panel → Filter → Show modern Regards Sudharsan Regards Sudharsan

Regards
Sudharsan

[Anil_G (Anil Gorthi)]

@runkrithik

Welcome to the community

If you have excel installed you can use Write range activity else to get write range workbook activity

Activities → Filter Icon → Show Developer

cheers

[runkrithik]

Dear @Sudharsan_Ka and @Anil_G ,
I hope above given options available in Studio, but i need to enable this in studioX.

Please refer attached images.
Thanks in advance.

[Anil_G (Anil Gorthi)]

@runkrithik

Can you confirm the version you have please. As teh screenshot I shared is from Studio X itself

cheers

[runkrithik]

Dear @Anil_G ,

[Anil_G (Anil Gorthi)]

@runkrithik

I guess because of the older version it is not having these options in the studiox

Can you try using excel related activities under use excel option… where you can have a write range and read range

Cheers

[runkrithik]

Dear @Anil_G .
I’ll try to update the newer version.
Thanks for your help.