I have a problem with my automation project. I have an table in sheet 1 and I stored in DataTable with output “dtable” and I want to write DataTable stored in to Excel sheet 2. Problem is that Colummn K is not inserted, is empty and i don’t know why. I try to move column , I make another formulas in Excel, etc…no chance
Many thanks in advance for your help
Welcome back to community
Both are Workbook activities
Can you provide us the input file.
Use read range activity → Store it in the DtRead
SheetName → “Sheet 1”
Use Write Range activity
I tried and I the same problem
Also I checked the cells from column K to see if something hiden there …but no chance.
Could you please share your file.
Test.xlsx (103.0 KB)
This is the Excel File …I think from Excel is the problem . But is defficult to say because poroblem is happend with 1-2 week ago when i come back from Holiday . Maybe the update come with some change in my project
As I can see in the attached file you are using LET function which is only supported by Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021, so I just wanted to know if you are using the above mentioned excel version.
If you are trying to read the datatable and find that the activity is throwing the error as Syntax Error, kindly make sure your have written all the formulas correctly in the method.
If any formula is returning the null value use the IF to check if the return value is null and use any custom value.
If formula itself contains any error use IFError method to correct it.
For me the excel is not supporting the LET method, I have changed the formula as below ss, where ever the value is returning as 0 you can see in the result screenshot that 0 were not get captured.
Check the result after applying the if condition in excel formula.
Thanks for your replay, but the formula has to check in an list of name which will be in sheet “Transportator” and will have 7146 row with 2 columns (1 columns will be the CODE Name and the second column will be the Name . The option will be with VLOOKUP , but no worked for me. I can’t share you all excel because is confidentialy . I tried with “= IF(DataTableAlex!R2=”“,”“,DataTableAlex!R2)” but still not worked. Is strange because worked in the past with “= LET” and now something happend. I think the problems comes from UiPath update or from Microsoft Office Update.
You have issue with Vlookup or issue with Copying data from Datatable to excel ?
I think I found the problem. After UiPath update something changed and is working via Excel.Activities.
So, i follow : App Integration - Excel- Exel Process Scope - Use Excel File - Read Range from (Excel Range) which has Headers and Visible Rows only and write DataTable to Excel.
I will add this in production and come back with feedback
@a.viziteu please check column format in excel
I checked from begining nothing column format. Main problem was when I’m back from Holiday I did update Microsoft Office and UiPath …and happend this problem . And until now I wasn’t know if problem from Excel or problem from UiPath .
So, I tested in production and working under Avaiable - App Integration- Range - Read Range es. Until now I used System- File - Workbook . Both are UiPath.Exel.Activities.
It worked also with al formulas in Excel (LET, IF , VLOOKUP and XLOOKUP , etc).
Thanks to all for sugestion and trying to help me
You can copy/paste activity
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.