Does anyone know of a way to force excel to recognize numbers as strings when using the write range activity with UiPath?
I am getting inputs from an excel file and saving it to a datatable variable. In a new workbook, I have a date field going into SAP that requires 8 characters in MMddyyyy format. If the month starts with a 0, excel is automatically removing the leading 0.
This is being done with many files, so manually opening excel and using UI to change the range to “text” format would take too much time/resources.
I believe the datatable coming from the excel input file is automatically converting it to a double or decimal type. Therefore, the only way I can think of is to clone the table, change the column datatype to string, then loop through each row and bring values over to the cloned table. I haven’t actually tested this though, thinking there may be other options. Any ideas?
EDIT: My attempt at changing the datatype to string did not work. Excel is still recognizing it as a number