By using Read CSV will return the output in datatable but with excel application scope it Opens an Excel Workbook and provides a scope for Excel Activities. When this Activity ends, the Workbook and the Excel application are closed. If a WorkbookApplication variable is provided in the Output > Workbook property field, the spreadsheet is not closed after the activity ends. If the specified file does not exist, a new Excel file is created. This activity can only be used if the Microsoft Excel application is installed on your machine.
to read its data you have to use “Read Range” activity from excel category. This activity will return its output as a datatable.
here you can use Data1 as a datatable same like csv and you have already done that in your workflow sample.
would you mind to share UI function on how to read column A data and determine which process to run thru? shall I use “If” or “switch” function? specifically, I will have “A, B, C,D” in column A2,A3,A4 and A5 and if UI read “B”, go to “B recorded process”, and etc.
I have similar to do but need to create a New column Sr. No in excel that would print serial numbers upto 100. I am not able to get how to print number to excel row by row? Can anyone tell me please?