Create separate CSV file for the data in each row of the Excel File

Help Studio
, ,
4

Hi,
please try these steps -

  1. Read your excel data and store it in a dt var, let say DT_Excel. (Using Read Range)
    2.Create a dat var “DT_Csv” using Build Data Table and mention all those column names that are present in your final Template.
  2. Take a "For Each " for DT_Excel and store your required variables in Variables, like
    VAR1 = DT_Excel.Row(index)(0).tostring
    VAR2 = DT_Excel.Row(index)(1).tostring
    VAR3 = DT_Excel.Row(index)(2).tostring
    VAR4 = DT_Excel.Row(index)(3).tostring and so on…
  3. then use a Add data row Activity inside it.
  4. in Properties of “Add Data Row”, your input Data Table will be DT_Csv and in arrayrow, insert your values as follows: {Nothing,Nothing,VAR1,Nothing,Nothing,Nothing,Nothing,Nothing,Nothing,Nothing,VAR2,VAR3,VAR4…}
  5. Inside the loop take write CSV Activity and provide your Data Table - DT_Csv and it will create different files for different rows

Hope this might help you
thanks.