Date format changed after data scrapping flow

manish.patel · January 4, 2021, 11:00am

Hello all,

I am scrapping table from web portal but after scrapping my date format is getting changed.
please check and advice

below is the screenshot

After scrapping data will be write into excel and when i am using excel data for next flow its showing 5th January into 1st May

so please help

NIVED_NAMBIAR · January 4, 2021, 11:05am

It is issue with the formatting in excel

Even u are scrapping date in dd-mm-yyyy hh:mm pm/am. But the excel cell is convert it as

mm-dd-yyyy hh:mm

Are u using excel application scope.for writing the datatable ,?

manish.patel · January 4, 2021, 11:10am

yes, i am using excel application scope

NIVED_NAMBIAR · January 4, 2021, 11:11am

Then try with workbook write range to write the datatable into the excel

Let’s see whether it works

manish.patel · January 4, 2021, 11:13am

yes tried with workbook append range but still same results

NIVED_NAMBIAR · January 4, 2021, 11:24am

Check this to change cell format of excel

system · January 10, 2021, 3:42pm

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.