Create Word Documents that correspond excel sheet names

Help Studio
, ,
1

I have an automation where i have a excel workbook with Multiple sheets. I need to create Microsoft word documents that correspond to those sheet names and add information to those sheets. How would i create word documents that correspond to the excel sheets? I have attached a excel with different sheet names. If somebody could respond with a workflow of how to create word files that correspond to the attached excel sheet
boo2.xlsx (11.7 KB)
names that would be great.

2

Hi @NATHAN_MORA ,

Here is the workflow and output.

NATHAN_MORA.zip (64.1 KB)

image
image1862×872 53.3 KB

Here I have used the
Balareva.Excel.Activities
BalaReva.Word.Activities.

Regards
Balamurugan.S

3

Balupad,
Thanks for the response i will check it out, is there a way around this without having to have the Brava Word Packages?

1 Like
4

Nice Work Thank You

1 Like
5

balupad,
How would i make folders corresponding to the excel sheet names and then create a word document inside the folders corresponding to that sheet name? Any Ideas?

6

Nice method, thank you!

1 Like
7

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