Hi guys ! I’m back with another problem !
Ok so I have two Excel docs, let’s call them Excel1 and Excel2.
- Excel1 is a file with the up-to-date data concerning the financial operations of the month.
- Excel2 is a big Excel file gathering all the financial operations of the year.
Excel1 has only one sheet : Sheet1.
Excel has 2 sheets : FinancialSynthesis and CurrentMonthOperations.
I’m supposed to copy datas from Sheet1 (from Excel1) to CurrentMonthOperations (from Excel2).
I first tried to delete the CurrentMonthOperations sheet, copy Sheet1 to Excel2 and rename it « CurrentMonthOperations ».
It worked BUT the problem is that the FinancialSynthesis sheet is using a lot of formulas connected to the CurrentMonthOperations sheet. And after I’ve done this, all the formula are displaying errors.
So, I tried to simply copy Sheet1 as a DataTable then write this DataTable in the correct cell of CurrentMonthOperations with ReadRange activity and WriteRange activity (from Worbook activities).
But I have a strange error of range ; it’s not doing what I want at all….
I checked that I was able to make a simply copy/paste manually from Excel1 to Excel2 and it was working well. So I guess I’m just not using the good activites of UiPath.
I’ll be sooo happy if you can help me ! I have to finish this part for tomorrow … ^^