![]() The script must run on a specified file name albeit this could be dynamic. This will allow you to browse for a script that you own or have shared access to. There is a bespoke action for Office Scripts, named Run Script. If you don’t know the name of your worksheet and you want this to run on your first sheet of the Excel Workbook, you can uncomment the const selectedSheet = workbook.getFirstWorksheet() expression that I have included in the above sample script. You may change these as appropriate to suit your use case. ![]() You will see that I have specified two input parameters, which will default to Table1 and Sheet1. Let newTable = workbook.addTable(selectedSheet.getUsedRange(), true) ![]() const selectedSheet = workbook.getFirstWorksheet() Alternatively, get the first worksheet (uncomment below and comment above) function main(workbook: ExcelScript.Workbook,Ĭonst selectedSheet = workbook.getWorksheet(SheetName) If you are ready to give this a try, the sample office script is below, ready for you to copy and paste into a new script, in my case called CreateTableInSheet. ![]() In the first column, create a reference to the repayment calculation in the original data. If you are unfamiliar with Office Scripts, you need to take a read-up here on the list of requirements and how to get started. In the Input Data, make two columns next to the variable interest rates.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |