Código de la App

Script Excel

function main(workbook: ExcelScript.Workbook)
{

let selectedSheet = workbook.getActiveWorksheet();

let worksheet = workbook.getActiveWorksheet();
let rows = worksheet.getRange(‘B5’).getSurroundingRegion();

let tabla = workbook.addTable
(selectedSheet.getRange(‘A1’).getSurroundingRegion(), true);
tabla.setPredefinedTableStyle(«TableStyleLight1»);
tabla.setName(«tb_txt»);
}