How to get sheetname to column a1 in csv

Help Activities
6

@rahulgola… I appreciate your concern… Doing good, hope the same from you!

In that case to get sheet name, suggested link will help you.

The gist of the process you can try is mentioned below.

Usually, this process uses GetSheets method to get all the available worksheets in the workbook, but here u have only one sheet so you can you this process.

You have to use “Excel Application Scope” activity’s O/P variable. i.e of type UiPath.Excel.WorkbookApplication. (WorkbookApplicationVariable)

Now you have to use the expression:
WorkbookApplicationVariable.GetSheets - Use this in an assign activity.

Loop through the variable holding values from the above expression. you can get all the worksheets names.

Hope this solves your query for getting the worksheet name!