I am having a complex excel format
Here is the reference screenshot:-
I want to copy from row number 4 - 12 to 13 -21.
Can someone help with this?
I don't find any relevant action in advance excel
Hi Krunal
The latest version (2.2.18) now supports copying rows.
There is a new action Worksheet_CopyRows.
You need to pass as parameters:
In your example RangeStart = "A4:A12" and RangeEnd = "A13:A21"
Hope this helps :)
Hanno
Thanks Hanno.
Will try this
Hello @Hanno ,
I tried this and it helps me to a extend.
But what parameter should I pass to copy a whole row?
Not like A2 or something.
But maybe copy row 2 to row 5
So it copies whole row
To copy a whole row, you would use, in your example, RangeStart = "2:2" and RangeEnd = "5:5"
To copy a whole column, you would use, for example, RangeStart = "C:C" and RangeEnd = "G:G"
Hope this helps.
Thanks Hanno
That really helps
Let me give it a shot
Hi @Krunal Vyas,
You can use to read Cell_Read Action to read the value of a cell inside excel file and then Write that value into your desired cell in excel.
Cell_Read action
Cell_Write Action
Hope this will help you.
Kind Regards,
Sanjay Kushwah
Hello Sanjay,
Thanks for the suggestion, But we want to copy the entire row.
Here going cell by cell is very long process as well as we want to preserve formating.
Any other suggestion?
Copying a row or a range isn't currently supported, but it looks like the code isn't too complex to add to the extension.
Hi Krunal Vyas,
As mentioned by Sanjay Kushwah, we can follow the similar approach to achieve your usecase. I know it is a bit time taking to read and write by each cell but till we get some method to apply to the range of cell we can follow this approach. So hereby I am attaching the link to test the copy rows of excel functionality.
Here is the link to the demo.
You can find the implementation part in the Forge component of Advanced excel demo.
Regards,
Piyali Saha
your demo asking for login, please anonymous it.
I have marked it as anonymous please try again now.