Excel Format need to match with Expected output

Help Studio
, ,
1

Hello all,

I have an excel file data(Actual Data) and i want it to be pasted in Expected Output file with the validation of header as shown… In the expected output file(Template Data) First row is Headers (1 to 31 numbers are basically date headers)…I want to append my data into that file. Plz help with the code
Actual_Data.xlsx (9.4 KB)
Template_Data.xlsx (8.8 KB)

2

This can be done by the following steps:

  1. Read the actual excel sheet using Excel activities and get the data table as output as DT1.
  2. Build a new data table as required/matches the template as DT2.
  3. Use foreach row, read the values from dt1, and assign it to the variable as str_name, str_num etc.
  4. using a foreach row again in DT2, write the values to the designated columns using add datarow.
  5. repeat the process until you are done with all the rows.
  6. finally write the values in the Excel sheet using the write range

We have multiple solutions for this use case, however, it is the easiest way which I think from the top of my mind. I encourage you to try it yourself instead of seeking the xaml files.

Let me know if you face any problems.

3

I have done the for each row for first datatable and tried to extract the data but failed… So I want xmal file to find where I made the mistake… Plz try with the .xaml file

4

what is your error? share your XAML file here.

5

AppendPart.xaml (22.5 KB)
Plz can u tell me the remaining part? by coading

6

@Janet_Caroline Would you plz help me with the rest of the part code?
I need it Plzzzzzz

7

POC1.zip (22.8 KB)

Here is the code for your problem. please mark this as a solution if this addresses your query.

8

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