Unable to copy proper data in excel

[Mathkar_kunal]

Hello,

I am tryong to copy data from same sheet from A7 to G2.
when automation pasting data it is writing some data in date formate and i am not understanding from where this date is coming.
check below ss.

help me on same.

[supriya117 (Supriya Allada)]

Hi @Mathkar_kunal

Give read cell activity if you want to read one cell instead of read range.

[lrtetala (Lakshman Reddy)]

Hi @Mathkar_kunal

Please try once check PreserveFormat

[Mathkar_kunal]

giving this error
checked both header and preserve ,tryied with only preserve option but same ,data copying with date

[mkankatala (Mahesh Kankatala)]

Hi @Mathkar_kunal

Do you please share the input file if your data is not secured one.

[rlgandu]

Hi,

Use vlookup activity to copy content from one column to another.

Thanks

[Mathkar_kunal]

i need to read range from a7 to F 1000

[lrtetala (Lakshman Reddy)]

@Mathkar_kunal

Try this

[supriya117 (Supriya Allada)]

@Mathkar_kunal

Then use read range and give range like this “A7:F1000”

[lrtetala (Lakshman Reddy)]

@Mathkar_kunal

If you want to copy data from A7 to G2

[Mathkar_kunal]

i need toi read range not cell as mentioned above

[Mathkar_kunal]

tried but not worked

[Mathkar_kunal]

Data.xlsx (20.8 KB)
please cehck file
let me know

[Mathkar_kunal]

how to do that ccan u please show image if u have workflow

[Mathkar_kunal]

still same

[mkankatala (Mahesh Kankatala)]

No @Mathkar_kunal

In your shared excel check that for all the rows of 3 to 6 the datatype is in the date format only.

If you want to copy only one cell value and paste in another cell better use the read cell workbook and write cell workbook.

[supriya117 (Supriya Allada)]

@Mathkar_kunal

Try this:
Main.xaml (27.9 KB)

Regards,

[rlgandu]

@Mathkar_kunal
Hi,

I hope this will help