Studiox question of creating excel

Help StudioX
,
1

Hi,

How combine multiple CSV files and write them into excel file as one single output file with Studiox.

Thank you

2

@A_Learner

  1. For each file in folder to read all csv files in loop
  2. Read csv inside the loop with currentfile being passed
  3. Merge datatable activity and merge the csv read data to mergedt
  4. After loop use write range and write the mergedt into excel
    Amke sure to intialize mergedt using new datatable()

Cheers

3

Thank you, @Anil_G
This is Studiox
are the activities available?

4

@A_Learner

Yes all of those should be available in studiox as well

Cheers

5

merge data table not available.

Thank you

6

@A_Learner

Under activities …click the filter icon and select developer …then merge datatable will be visible

Cheers

7

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