Excel formulas when going from legacy to windows

[jelle.segers.Bpost (Jelle Segers)]

hi,

We are currently looking at migrating all our projects from windows-legacy to windows, but we ran into a problem:

All formulas in excel files that are using function or referals for datatables are not read.

To test I made a table in excel (see screenshot at the bellow)

In a legacy project I get the expected results when using read range.

In a windows project I get the following results when using read range (both workbook and in excel scope):

The columns using [@a] or Rows() give empty values in UiPath.
In one of my projects I noticed other table function like Index also don’t work, and also noticed other problems that I haven’t been able to replicate in my test (I thouged it was because it was because it was referring to a cell using a table func, but the value for Blad1!F$2=Rows(Table2) was read in my test)

Did anyone encounter similar problems? And how can these be fixed?

Also, is there somewhere a list with all the things that don’t work anymore when migrating from legacy to windows?

note, this test was done with:
Excel.Activities = 2.12.3
System.Activities = 22.4.4

[Muhammad_Nadeem_Abbas]

Please see the below post for migrating from legacy to windows:

Ways to Convert Legacy to Windows - Studio

I was looking for how to convert my process from Legacy to Windows. I found two ways that I leave described below, however I believe that the second is the best. Changing the projectInfo: [image] just put Windows. Performing the conversion in the process itself with the studio open: Right-click the project node in the Project panel and then select Convert to Windows . A new window is displayed. [image] About the second way, you can get more information in the documentation at the follow…

[Krishna_Raj]

@jelle.segers.Bpost

[InfoSet] - LegacyToWindows Migration # Information Index

About this [InfoSet] - LegacyToWindows Migration series The [InfoSet] series summarise a topic and offer information resources of different kinds. As the topic of Legacy-to-Windows migration is currently in focus, it was selected for the [InfoSet] series to provide further assistance. This information index is the landing page that lists all the different information resources. Blogs Tools & Guides Blueprint Block Topic Registration / Inventorisation / Prototyping Jump Start Guide …

check the above given thread