Excel operations1

Excel1 | Excel2 |
Date | Date
4-3-2023 | 4-3-2023 00:00:00
1-2-2023 | 1-2-2023 00:00:00
2-2-2023 | 2-2-2023 00:00:00

Above there are 2 excel and i am taking date from 1st excel to 2nd but in 2nd excel while typing date it takes timestamp then how i remove it

Excel1 | Excel2
Date | Date
4-3-2023 | 4-3-2023
1-2-2023 | 1-2-2023
2-2-2023 | 2-2-2023

Hi @Yogita_Gaikwad1

Try this


Hi @Yogita_Gaikwad1

row(“Date”) = row(“Date”).ToString().Split(" "c)(0)

Hope it helps!!

Read your Excel file and put For each over datatable.

This will update your date column only with date.

Hi @Yogita_Gaikwad1

  1. Read the excel using “Read Range Workbook” activity.
  2. Use “For each row in Datatable” activity to iterate through the rows.
  3. Use “Assign Activity” and give the below condition
CurrentRow("Formatted Date")=CDate(CurrentRow("Date")).ToString("MM-dd-yyyy")
  1. Use “Write Range Workbook” activity and this will update the date in the Formatted Date column.

Note: Shared the workflow for reference.
Sequence3.xaml (8.4 KB)

Hope it helps!!

its not working

read first sheet of excel and take date from date column and write in second sheet of excel in date column

@Yogita_Gaikwad1 which one not working, you are mixing up please clear.

Hi @Yogita_Gaikwad1

Give the column name of second column sheet where you want to update and give the condition.


whenever you reading data from excel keep preserve format , and
there is activity called format cells ,
with using that you can alter column data type


vDate_Of_Joining is variable in which store excel column


column name is Date of joining


and this is sheet 2 in which i write date

@Yogita_Gaikwad1 you can’t convert datetime through CDate which contains dashes in format, you can convert system dates only with CDate.
Let me share another technique to convert date

Try this one

DateTime.ParseExact(CurrentRow("Date Of Joining").ToString,“d-M-yyyy”,Globalization.CultureInfo.InvariantCulture).ToString(“d-M-yyyy”)

@Yogita_Gaikwad1 Give me Project Folder by zip and place excel files also in it.

Salary_Slip_Final.zip (38.9 KB)
excel is Salary_Slip and change path in data folder config file
Salary_Excel_Details path of salary_Slip excel
Folder_Salary_Slip_Pdf path of Employee_SalarySlip

@Yogita_Gaikwad1 where you are facing issue can you highlight that part.
as i can see here is multiple types of format present


  1. Try using preserve format while reading excel
  2. If 1 also dors not work…then use format cells activity to display as you need
  3. Another way would be instead of read and write use copy paste range activty which will copy exactly