Formatting column in uipath

Help Activities
, ,
1

i need to format the entire column in excel to general from date format ,how do i do that ?

exception :cant use balareva activities

2

Hi @poojaskyrathore ,

for this case can you use template excel?

  1. Prepare the template excel ( ex : column 1 is formated date, colum 2 formated date, etc)
  2. Get datatable from other source (database/excel)
  3. Using copy file from template path to desired path with new filename
  4. Write datatable to new excel from template
  5. save Excel

Or you can simply use this activity :

Regards,

3

Hi @poojaskyrathore
Welcome to UiPath community
To format the entire column in Excel to general from date format in UiPath, you can use the following steps:

  1. Open UiPath Studio and create a new project.
  2. Drag and drop the “Excel Application Scope” activity onto the design canvas and specify the file path of your Excel workbook.
  3. Drag and drop the “Read Range” activity inside the Excel Application Scope and specify the range of cells that you want to format.
  4. Use the “For Each” activity to loop through each column in the datatable that was read from the Excel sheet.
  5. Inside the “For Each” activity, use the “If” activity to check if the column contains date values.
  6. If the column contains date values, use the “ForEachRow” activity to loop through each row in the column.
  7. Inside the “ForEachRow” activity, use the “Assign” activity to assign the cell value to a variable.
  8. Use the “Format Value” activity to format the variable to the desired format, in this case, the general format.
  9. Use the “Write Cell” activity to write the formatted value back to the cell in the Excel sheet.
  10. Save and run the project.

Regards,
TuanNNA

4

Hi @poojaskyrathore

You can try with Format Cell activity

This activity allows you to set the format for all the cells in a specified range

Check out this tutorial

Regards
Gokul