How to create output file for each line item in excel?

Help Studio
, ,
1

Hi All,

Scenario:
I have an excel input which has 20 line items. I want to create an output file for each of these line items in the “Output Folder” and name it according to the item’s value.

For eg :
Column Name → State List

  1. TN
  2. Kerala
  3. Andhra
  4. Karnataka

I want to create a separate file for all of these items in a folder. Please help ASAP.

Thanks in advance.

-Dev

2

@devanand.1292

Read Range for reading the excel input

For each row in datatable activity

create file activity inside of it

image
image765×681 22.8 KB

currentrow(“ColumnName”).tostring+“.xlsx”

cheers

1 Like
3

Thank you @Shiva_Nikhil :slight_smile:

It worked!!!

1 Like
4

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