How to write to new excel using write DataTable to Excel

Help Studio
, ,
1

Hello, Can you please help me with writing data to new excel.

I am using latest 2022 version
I am able to read data from a excel and now I want to write the data to new xls.
I am looking for write range , unfortunate I am not able to see the write range option, however I can see write datatable to excel. Can any one help how can can I use Write DataTable to Excel option and write to a new xls. I am adding a screenshot for reference.

image
image3540Ă—2319 293 KB

2

@RanjaniS You could use write range workbook activity,where you can mention the new file name and datatable to write.that activity automatically create new excel file and write datatable into it

3

Thankyou , I tried but I an getting below error

image
image819Ă—407 22 KB

4

@RanjaniS

Show me the screenshot of the activity
Datatable variable name is correct?

5

Hello @RanjaniS

syntax for destination is excel.sheet(“sheet name”)

image
image943Ă—633 16.5 KB

2 Likes
6

image
image778Ă—336 10.2 KB

Yes the Datatable variable name is correct

1 Like
7

Will try this option and upadte

8

@RanjaniS in excel path.xlsx is repeated and in sheet section just give “sheet2”

9

This worked, Thankyou so much for you help. :slight_smile:

10

@RanjaniS if it resolves the issue,then make it as solution and will be helpful for others

1 Like
11

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