I have a recording which reads prices from a website with Xpath, “caches” them into a string variable and then appends the cached prices into a list variable with “expression value”. In the end, I write the values of the list variables in Excel and save the Excel file. Up to here, everything works perfectly.
In Excel, the prices are copied as a string from the list variables. Since I calculate with the prices, I convert the prices (string) into prices (number) with Excel functions.
Unfortunately, the Excel functions (String -> Number) do not work immediately when I open the Excel files manually. I have to double click on the cells and then on Enter, after that the Excel functions will work again. This is only the case if I fill the Excel file with the RPA.
Is there a solution?
Filling an Excel file with the RPA. Excel functions do not work.