Hi, Im trying to copy data from one excel file to another.
Excelfile1: .xls file, 3 columns with data, all in string format
Excelfile2: .xlsx file, contains an empty table
What I wanna do is copy the data from Excelfile1 to Excelfile2 to filter my data in the table. Column three in Excelfile1 contains both integers and floats, but as strings originally. Example of values in the column: “2000” and “199,44444”. When I try to read the whole sheet with “Read Range” activity from “Excel Application Scope” it somehow converts “2000” to 2000 (an integer) and “199,44444” to “199,44444”. This executes problems in my table and I get wierd values. How do I solve this problem? What method can I use to convert “199,44444” to 199,44444? Or even better, “199,44444” to 199.