Excel operations1

Help Studio
,
1

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

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

2

Hi @Yogita_Gaikwad1

Try this

Convert.ToDateTime(CurrentRow(“Date”).ToString).Date.ToString(“dd-MM-yyyy”)

3

Hi @Yogita_Gaikwad1

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

Hope it helps!!

4

@Yogita_Gaikwad1
Read your Excel file and put For each over datatable.

image
image1068×708 21.9 KB

This will update your date column only with date.

5

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!!
Regards,

6

its not working

image
image715×497 23.2 KB

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

7

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

8

Hi @Yogita_Gaikwad1

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

Regards,

9

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

10

image

vDate_Of_Joining is variable in which store excel column

image

column name is Date of joining

image

and this is sheet 2 in which i write date

11

@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

12

@Yogita_Gaikwad1
Try this one

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

image
image1009×60 7.54 KB

14

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

15

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

16

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

17

@Yogita_Gaikwad1

  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

Cheers