How to fetch Columns and sub columns from excel and write into word

[Rohit_Patil1 (Rohit Patil)]

Hi, I want to Fetch the columns and sub columns from excel to word.
Say suppose I have Gender(Main Column) and “Male Female and Other” are the sub columns.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @Rohit_Patil1

Would you like to preserve the table format or only the text from excel you need?

This workflow saves only text from excel

6. UiPath | Insert DataTable in Document | Pass Data from Excel to MS Word | UiPath Word Automation

[Gokul001 (Gokul Balaji)]

Hi @Rohit_Patil1

Welcome to UiPath community

Check out this thread

How can i read sub-columns in main column?

Read Table.xaml (31.6 KB) in initialization state, call this read_table.xaml , pass in excel path and sheet name and assign out_transactionData output to the REFramework dt_TransactionData variable, thats all [image]

Insert Data Table in Word Document UiPath | UiPath Word Automation | UiPath RPA

Regards
Gokul

[Rohit_Patil1 (Rohit Patil)]

Hi sangeetha, Thanks for response. I want the data to word in below format.
Gender is the column and Male, Female, Other are subcolumns

[Rohit_Patil1 (Rohit Patil)]

Hi, Thanks for response. I want output in below format.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@Rohit_Patil1
Please check with this
Workflow.xaml (10.2 KB)

[Rohit_Patil1 (Rohit Patil)]

Hi Sangeetha, Thanks for the Response. When I open the xaml file, it is showing invalid data or file.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

In which project combination the XAML file is opening?

[Rohit_Patil1 (Rohit Patil)]

Currently it is opening from downloads. Is there any setting to do before opening the file? Please refer below screenshot for more details.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@Rohit_Patil1 My document is in vb, windows but for you, it is opening in windows legacy project.
BlankProcess6.zip (12.8 KB)

[Rohit_Patil1 (Rohit Patil)]

Okay. Thanks Sangeetha!