Transfer data from temporary file to new and final excel file

Help
1

Im almost done of my sequence and i just need to copy the content from my AccountList excel file to BTS file. My BTS file has a built-in lookup table so i just need to get few rows from the AccountList instead of getting all the data. Can you assist me on how to execute this? Thank you in advance

2

Hi @julius.mapili,

Based on what condition you are getting few rows from Account list.

3

Hi anil5,

Yes, infact i’ll be needing column “C” (Account Number), column “G” (Due Date), column “L,M,N,O” for invoice details and to be transfered to my final bts file

4

Hi @julius.mapili,

You can use the below condition to get the specific column names from Account list

dt.DefaultView.ToTable(False,“ID”,“Age”)

“ID”,“Age” - These are the column names, specify which all column names you want to get from your account list datatable.

dt - Specify the account list datatable.

Refer the sample xaml file with input

Test.xaml (28.2 KB)

Reading.xlsx (8.6 KB)

1 Like
5

Thank you so much. Appreciate your help!

6

Hi @julius.mapili,

Is the above solution working for your scenario.

7

i encountered couple of logic that actually put me on halt. I have an existing data table that can be used however there are values in the temp file that i need to omit first before transferring it to the final file.

8

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