1 = CELL("filename") To get the current worksheet's name, you can use the function with or without the optional reference argument, referring to any cell on the current tab 1 = CELL("filename",A1) You can also get information about any other worksheet by referring to a cell on that sheet 1 Getting started with Excel actions After setting an Excel instance, either with the Launch Excel or the Attach to running Excel action, you may read from or write to an Excel file To read and extract data from an Excel document, use the Read from Excel Worksheet action Retrieve the value of a single cell, or a table of dataAnd for this we'll be using a mix of Power Query and Excel Formulas to get it done fast and easy!
How To Quickly Insert Sheet Names In Cells In Excel
