Get data excel

[gilang_mandiri]

Hello All

I have a question, how can I do this

I have an example

in column A and rows 1-5 contain “A,B,C,D,E”

in column A and rows 1-5 contains “1,2,3,4,5”

I want to make Output to Ms.Word like this
A1
B2
C3
D4
E5

thank you and please help me

actually i can get the data from excel but i can’t combine the data

[adiijaiin (Aditya Jain)]

hi @gilang_mandiri

Are these two different data tables?
Can you show in an excel?

[Krishna_Raj]

@gilang_mandiri

1. Read Data:

• Read Range (Sheet1, A:A) → dataTableLetters
• Read Range (Sheet1, A:A) → dataTableNumbers

2. Create Word Document:

• Word Application Scope → wordDocumentVariable

3. Combine Values:

• For Each Row (in dataTableLetters):
  • Append Text (to wordDocumentVariable): row(“ColumnA”).ToString + dataTableNumbers.Rows(row.Table.Rows.IndexOf(row))(“ColumnA”).ToString + Environment.NewLine

4. Save and Close Word Document:

• Word Save Document (inside “Word Application Scope”)
• Word Close Application (inside “Word Application Scope”)

[gilang_mandiri]

Yes Sir the data is in a different excel table

and then i need to write in word like this

[vrdabberu (Varunraj Dabberu)]

@gilang_mandiri

I have an example

in column A and rows 1-5 contain “A,B,C,D,E”

in column A and rows 1-5 contains “1,2,3,4,5”

I want to make Output to Ms.Word like this
A1
B2
C3
D4
E5

Hi @gilang_mandiri
→ Read Range Workbook

Output-> dt_Input
→ Please check the below query:

ListString= (From row In dt_Input.AsEnumerable()
   Select $"{row("Column1")}{row("Column2")}").ToList()

ListString is of DataType System.Collections.Generic.List(Of String)
→ Word Application Scope inside that use Append Text acitivity. Make sure to download UiPath.Word.Acitivities.
Output:

Workflow:

xaml:
Sequence3.xaml (9.6 KB)

Regards

[lrtetala (Lakshman Reddy)]

Hi @gilang_mandiri

Try this

OutDT=(From row In InputDT.AsEnumerable()
                   Let combinedValue = row(0).ToString & row(1).ToString
                   Select outputRow = InputDT.Clone.Rows.Add(combinedValue)).CopyToDataTable()

String.Join(Environment.NewLine, OutDT.AsEnumerable().Select(Function(row) String.Join("", row.ItemArray)))

Input:

Output:

Note: Make sure Uncheck the Add headers in Read Range

Cheers!!

[Adithyeshwar_goud]

check the xml file

test case 5.xaml (8.9 KB)

[gilang_mandiri]

thank u so much for the answer sir

[gilang_mandiri]

thank u so much for the answer sirr

[gilang_mandiri]

thank u so much for the answer sirrr

[gilang_mandiri]

thank u so much for the answer Sir