Need help with Logic for excel manipulation

Kore7989 · June 15, 2023, 1:11am

I need help with logic to get the desired out from an excel sheet. I want the code to be dynamic so can handle 1 or 2 or 3 company names up to 10 maximum. Any help with be appreciated. Thank you in advance.

Expected Input:

Anil_G · June 15, 2023, 1:52am

@Kore7989

Welcome to the community

Please follow

Use read range and read the excel data into datatable dt
Use build datatable and add required number of column of string type and make sure to assign a outdt variable in properties panel
Use a for each activity with input argument as Enumerable.Range(1,dt.Columns.Count-1)
Use an add data row activity with datatable as outdt and array row as {dt.Rows(0)(currentitem).ToString,dt.Row(1)(currentitem).ToString,dt.Rows(2).ToString…so on}
After the loop use write range on new sheet or excel and write the outdt

In step 4 numbers represent each row…currentitem represents each column for each iteration …and as index starts from 0 used 0 for first row and so on

Hope this helps

Cheers

system · June 18, 2023, 1:52am

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

Topic		Replies	Views
Developing specific loop StudioX studiox , question	4	443	August 29, 2023
Extract Data from one excel to another with condition Studio datatable , excel , activities , studio , data_manipulation	7	897	June 26, 2021
For each row data Activities excel , activities , studio , question	6	1851	January 16, 2022
Using loop on Decision Flow with multiple excel rows Studio datatable , excel , activities , question	2	924	March 8, 2020
Excel linq queries and flow required for complex data manipulation in Excel Studio datatable , excel , activities , studio , regex , question , activities_panel , linq , linq-query	11	93	October 25, 2024

Need help with Logic for excel manipulation

Related topics