Date Format _001

Help Studio
, ,
1

Hello guys I have 2 column in excel, i want the same format for column i in column 2

image
image335×331 14.2 KB

Below are the code

image
image318×738 26 KB
a

  1. Iam reading excel (Preserve format is enabled)
  2. Creating a data table and adding each data to the datatable and finally writing it in the excel sheet

But iam not getting the same format as of first format

2

@Gokul_Murali,

You will have to use Excel Process Scope activity Format Cells

The image shows the "Format Cells" dialog in an Excel-like application, with options for setting data type and custom format, and an area to specify the source range. (Captioned by AI)
The image shows the "Format Cells" dialog in an Excel-like application, with options for setting data type and custom format, and an area to specify the source range. (Captioned by AI)1248×329 31.5 KB

3

@ashokkarale

Can i use one format cell activity to change 3 column format

if yes, can you mention that also

4

@Gokul_Murali,

If the columns are in consecutive sequence like this

A spreadsheet with columns labeled "My Column," "D1," and "D2" containing dates from December 19, 2024, to December 31, 2024, with the headers highlighted in yellow. (Captioned by AI)
A spreadsheet with columns labeled "My Column," "D1," and "D2" containing dates from December 19, 2024, to December 31, 2024, with the headers highlighted in yellow. (Captioned by AI)441×541 7.24 KB

You can Format Cells using Range like this

This image shows an Excel automation interface highlighting the command to format cells within the range A to C on "Sheet1". (Captioned by AI)
This image shows an Excel automation interface highlighting the command to format cells within the range A to C on "Sheet1". (Captioned by AI)770×255 6.72 KB

But if they are apart from each other, you will have to use multiple Format Cells.

5
  1. Using read range activity store the data in a variable DT1.
  2. using For each Row in Data table = row in DT1.
  3. using Assign Activity and write the conditions-
    row(“Column2”) = DataTime.ParseExact(row(“Column2”).ToString(),“dd-MM-yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy-MM-dd”)

if any query you ask me .