Hi Friends,
I Have a .xlsm file(Macro file) and I have data in another excel file(.xlsx). I need to copy the range from .xlsx file and write into.xlsm file, can someone please help .
Hi Friends,
I Have a .xlsm file(Macro file) and I have data in another excel file(.xlsx). I need to copy the range from .xlsx file and write into.xlsm file, can someone please help .
hi @RenukaRPA
Greeting for the day
Follow the following steps:
The xlsm can only be read or used in UiPath in the excel scope…
Hope this helps
Good day
Thanks for your reply Shubham, To write the range , I am not aware of the sheet , i will not be able to see the sheet Name in the macro file I have.
Do you mean it can change?
You can get a list of all the sheet names in the excel of the xlsm and use that to populate. Does this help?
Hi.
Read Range: Out of present range. (Exception from HRESULT: 0x8002000A (DISP_E_OVERFLOW))
I’m reading .xlsm file and we are getting above error using uipath read range activity.
if you have any solution of that can you please suggest.
i don’t want to specify range.
i want to read whole file. so please help
Please refer the following post
Hope this helps
thanks buddy this is right. I have converted column type into text and it is worked. UiPath is read range activity worked. Thanks for sharing.
Thank you, it did help