i have data in one excel sheet,
ID | Amount | Date
E1 | 203.6 | 01/05/2018
E3 | 333.6 | 05/05/2018
.
.
ID | Amount | Date
E5 | 415.5 | 01/05/2018
E9 | 666.6 | 05/05/2018
and i want to dynamically split the data based on the headers, into 2 different excel sheets.
aanandsanraj
(Anandraj Rajendran)
January 13, 2020, 10:11am
2
Hi @Manoj_Gandham1 ,
Can you explain logic briefly ?
actually my original excel sheet contains,
and i want to take payments and invoices to 2 different excel’s.
thanks @aanandsanraj for the help its done.
aanandsanraj
(Anandraj Rajendran)
January 13, 2020, 11:38am
6
You are Welcome @Manoj_Gandham1
nikhil.s
(Robot)
August 26, 2020, 5:47pm
7
Assign: Cannot perform ‘=’ operation on System.Double and System.String.
Im encountering this problem with rowCount Assigning
Hi @nikhil.s
Actually the column data type is Double so you need to convert it. Use the below code to convert
dtExcel.Select("Convert([Column1],'System.String') ='Invoices'")
ajnaraya
(Ajay Narayanan)
November 6, 2023, 6:23am
9
I tried to replicate same things what you have mentioned. But getting error like this in the rowcount assign activity
aanandsanraj
(Anandraj Rajendran)
November 7, 2023, 11:41am
10
Please tell what are you trying to do? If possible share the xaml file
Yogeesh_G
(Yogeesh G)
November 8, 2023, 4:28pm
11
Hi
Step 1: Read the data into a data table
Use the Read Range activity to read the data from the Excel sheet into a data table.
Step 2: Split the data into two data tables
Create two empty data tables to hold the split data.
Iterate through the data table and add each row to the appropriate data table based on the value of the “Date” column.
If the value of the “Date” column is “01/05/2018”, add the row to the first data table.
If the value of the “Date” column is “05/05/2018”, add the row to the second data table.
Step 3: Write the split data to two Excel sheets
Use the Write Range activity to write the data from each data table to a separate Excel sheet.
Thank you