Excel Automate - Create Dynamic Table using TypeScript!
When using an automation tool like Power Automate, in order to build your flows, it is often essential to create a table from data in an excel workbook as an early step. But what if your workbook contains an ever changing number of rows each time your flow runs? In this video we will learn how to use Excel Automate to write a script that will create a table from a dynamic range of data.
Here is the code:
function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
//Get dynamic chart range
let myRange = selectedSheet.getRange("A2").getSurroundingRegion().getAddress()
// Create a table with format on range myRange on selectedSheet
let table1 = workbook.addTable(selectedSheet.getRange(myRange), true);
table1.setPredefinedTableStyle("TableStyleLight1");
}
More Power Automate videos here: • Power Automate
Intro to Power Automate Cloud Flow series: • Intro to Power Automate Cloud Flows
Connect with me on LinkedIn: www.linkedin.com/in/jeremy-barden
My website: https://www.jeremybarden.com/
#typescript #typescripttutorial #excel #excelautomation #powerautomate #rpa #excel
In questa pagina del sito puoi guardare il video online Excel Automate - Create Dynamic Table using TypeScript! della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Jibbs Automations 28 gennaio 2023, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,657 volte e gli è piaciuto 24 spettatori. Buona visione!
