How to use Desktop Function CELL("filename",A1) for Web? or Excel Script ?

Contributor

Because my Excel Workbook was relocated without my knowledge, I am thinking of using Excel Function to display its location.

As-Is,

  1. Desktop view shows its location but not Web View.
  2. Excel Script workbook.getName returns only workbook name with extension
/**
 * This script logs the name of the workbook with extension.
 */
function main(workbook: ExcelScript.Workbook) {
    // Get the workbook's name.
    let name = workbook.getName();

    // Display the name in the console.
    console.log(name);
}

 

How to display Document location in Workbook ?

 

Thanks Ahead!

0 Replies