Write data from excel to excel with different format

Learning Hub Academy Feedback
1

Hi Everyone!

I have one sample, pls support me.

I want to write data from excel file to excel file as below.

The destination file is excel file with name " ID2.xlsx ", I want to take some individual data from this and write into a new another excel file " ID3.xlsx "
Write Data to excel file.xaml (11.0 KB)

IN
IN1360×768 54.1 KB
Out
Out1360×768 53.7 KB

Thanks you!

1 Like
2

Hi Hadoanpapvn,

Do one thing first take B column into datatable than take F column into different datatable and than merge both datatable.

Let me know if any further information required.

Thanks and Regards,
Indrajeet Yadav

1 Like
3

Hi @indrajeet.droid

Sorry, could you pls do a example for me by XAML file ?

1 Like
4

hi @indrajeet.droid

I have created a program as attached file… The data has written but not correct and not enough.

Pls check!Write Range from excel to excel.xaml (10.3 KB)

1 Like
5

hi @ hadoanpapvn
let me create xaml for you

2 Likes
6

Hi @ hadoanpapvn

Please see the attached xaml file and let me know if any further information required

Thanks and Regards,
Indrajeet YadavDatatableExample.zip (16.7 KB)

1 Like
7

Hi @indrajeet.droid

Thanks you so much… But your way might difficult to me to understand ^^

I attachedWrite Range from excel to excel.xaml (10.3 KB)
my XAML file… could you pls optimize or edit ? Because this is the way easier for me to understand .

Thanks you so much.

1 Like
8

Hi @indrajeet.droid

I have tried with my way… But it only write the first row of 2 range I want as below.

I think the Read Cell Activity must be edit or declare…

Could you check as below and fix it to me ?

2
21360×768 53.2 KB
3
31360×768 73.4 KB

1 Like
9

I have tried to show result into MessageBox , the result as below.

It shown a first row in range only…

Is there any not correct in declare in Read Cell @indrajeet.droid ?

1
11360×768 66.7 KB
2
21360×768 65.7 KB

1 Like
10

@trunghai try thisDatatableExample.zip (16.3 KB)

1 Like
11

Hi @indrajeet.droid

Thanks you so much.

1 Like
12

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