I am reading data from excel of which one Column is ‘Joining Date’ formatted as ‘dd-mmm-yyyy’. I have stored them in data table named ‘dtUserNotLoggedInDump’ in Uipath and while writing the data table ‘dtUserNotLoggedInDump’ to Google sheet by using DateTime.ParseExact For each row method it is taking much time because I have 3-4 thousand lines of data and For Each row writes the data row-by-row. I have also tried to check the ‘PreserveFormat’ box while reading the excel range but, even this takes time.
Is there any way I can change the format of entire column while writing from Excel to Google sheets (“dd-MMM-yyyy”) . It would be very useful. Thanks.
I have shared the code used in DateTime.ParseExact For each row method below for your reference along with the snapshot.
- Read Excel range and store in data table ‘dtUserNotLoggedInDump’
- Use For Each Row inside the Gsuite Application scope
- Assign str variable
JoiningDate = DateTime.ParseExact(CurrentRow(“Joining Date”).ToString,“MM/dd/yyyy hh:mm:ss”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MMM-yyyy”)
- Write above variable value back to current row of Data table
CurrentRow(“Joining Date”) = JoiningDate
- Google sheet Write range
Please help. I am very much new to Uipath. Thanks in advance.!