Excel Data not as per Expected data

Help Studio
, ,
1

Expected_Output1.xlsx (11.8 KB)
Final_Output.xlsx (21.6 KB)

I have Final output . In that “I” column is EntryTimes. Below that I want the row of Normal only… Removw date and Day row…

After that I want the data to be written in Expected output based on Headers…

Plz help me with the code…

Thank you

2

Hi @Omkar_Shete_CTR,

Excel loves to reformat any data that you type, especially numbers, dates, and times.
I suggest the following:

  1. Use CSV instead of Excel
  2. Use Excel but change the column data type to text if you want to preserve your formatting
3

Thanks for your reply But plz explain how to get data and If i use CSV then how to do it?

4

Are you writing to Excel from a datatable?
If so, just use Write CSV instead of Write Range activity.

You can still open the CSV with Excel manually.

If you are not writing a datatable to Excel and using the bot to write data to an existing Excel file, then your best bet is to set the format of column “I” to Text so Excel doesn’t change your formatting.

To set the format, you can do it manually or use the bot to do it through several clicks.