Insert column to excel sheet

Help
1

image
we want to pick the price and value column from this excel
AggregationData.xlsx (15.6 KB)

and

image
image1142×425 11.9 KB
Splits_Rover_Staging_2019.xlsx (35.8 KB)

2

Hi @ashishmani

try to use add data column activity ‘column’ as “Price” and "Value "

Thanks
Ashwin S

3

can u make xmal plzzz

4

is their any one who tell me exact solution

5

@ashishmani

Please check attached workflow there check Aggregation Data excel output sheet.

GetColumns.zip (37.1 KB)

6

@ashishmani

Do you want to read that mentioned two columns right. Then try below steps.

  1. First use Read Range activity to read the data from excel file and will give you output as DataTable and say ‘DT’.

         requiredDT = DT.DefaultView.ToTable(False,"Price","Value").CopyToDataTable
7

we have to take data from aggregation and fill to split_rover excel sheet, beside the month of jan?feb?march like this…plzz understand my issue.

8

like this you want

image
image1316×97 5.31 KB

9

yes…

10

can some help me to solve this issue

11

Hi @ashishmani: Please try invoke method activity to set the ordinal of the columns price and value , steps:-

invoke
invoke1467×564 26.1 KB

1)Extract data columns price and value from data table 1
2) Add data columns to the data table 2
3)by default it will add the columns in the end
4)Now use invoke method to change the ordinal

12

i already try its not working…
plzz try to make xaml if pssobile.
thanks…

13

is their someone who tell me proper method or xaml

14

can anyone tell the solution

15

@kommijeevan you have solution

16

@ashishmani : Here is the xaml file , the data table with new formatted data is the last result . You just need to write the last data table created in to the second excel file of yours in appropriate position.ForumExcelColumnOrdinal.zip (71.2 KB)

17

no sorry to say, but this is not a solution, i think u not understand the issue.
we have to insert “price” and value column in split excel…beside the month of jan /feb/march.
so the month we have to pass from a varible, first we have to match month,
for wxample. if we pass the jan-2019 than, beside the jan we have to insert this two column.
thanks

18

@Kumari_Ekankika plzz read it