I built a DT, 5 columns consisting of 3 strings and 2 integers.
One of the string colums is a date column.
When its written to an excel sheet which is entirely formatted as general I was under the impression the integers would be recognised as such.
Excel sees the date as indeed a date even though ive set it in the build dt as a string it changes the column to a date column, perfect.
The original text im reading is lets say 1 - 1, this is in Excel formatted as text.
This particular column gets split in Uipath, added to the built DT as seperate columns, set as integers.
It works fine, can do operations within excel, just wondering why its seen in Excel as general and not integer as stated in the built dt.
I can preformat the column to be written as number or format the column as number after the write but just wondering why ?
In Excel I have this cell “2 - 2” , this is formatted in Excel as text.
This gets read in uipath, saved into a dt var.
I built a dt with preformatted columns, yes they are integers.
I split the “2 - 2” into “2” “2”.
These get added to the built dt in seperate colums, then written to Excel.
one reason could be that The exported data, is stored in a DataSet variable. The data contained in the DataSet object only contains the value itself from an ExtractionResult , without the reference and confidence level.
We convert this variable to a spreadsheet using excel activities.