Create Sheet with todays date if not Present

[anmita]

Hello Everyone
1)How can we create a sheet with todays date if not present

2)Create a header in Same Sheet
Product Name | Product Type

3)Everytime we get data in output data table it should paste one by one
Example:
First time if we run
Product Name |Product Type
XXX | XXX

Second Time it when its run it should not overwrite
Product Name |Product Type
XXX | XXX
YYY | YYY

[Gokul_Jayakumar (Gokul Jai)]

@anmita

Second Time it when its run it should not overwrite

Hello @anmita
You can use append range activity for excel

How to use UiPath Append Range with Excel Example

[Manju_Reddy_Kanughula]

check this

Now.Date.ToString("dd/MM/yyyy")

[Sudharsan_Ka]

HI @anmita

@anmita

1)How can we create a sheet with todays date if not present

• Use Excel Application Scope
  • Get Workbook Sheets - This will get you all the sheet name in the List(String) “SheetNames” (I.e. the variable created)
    Create a variable there and change the scope of the variable
    

@anmita

2)Create a header in Same Sheet
Product Name | Product Type

• Below EXcel application Scope , Use Build Datatable activity and give your headers there
  
  

If Condition like

String.Join(",",SheetNames).Contains(Now.ToSTring("dd.MM.yyyy"))

True-> Leave empty
False-> Write range

• File Name -“Your excel Name”
• Sheet name - Now.Tostring(“dd.MM.yyyy”)
• Datatable will be the Build datatables output

@anmita

3)Everytime we get data in output data table it should paste one by one
Example:
First time if we run
Product Name |Product Type
XXX | XXX

One - You can add the details in add data row activity that will add you the details in teh Datatable one by one and at last write that datatable in the excel

How to add a DataRow to a DataTable in UiPath - Full Tutorial

Two - You can use Append Range Activity

UiPath Tutorial || Day 23 : Append Range Activity

Hope This Helps!

Regards
Sudharsan

[fernando_zuluaga]

Hey

here is your solution
BlankProcess1 (2).zip (11.7 KB)

Regards!

[anmita]

Thanks @Sudharsan_Ka , @fernando_zuluaga , @Gokul_Jayakumar and @Manju_Reddy_Kanughula for your detailed response