All templates
Excel AutomationBeginner
Launch Excel
Robomotion•Updated 9 months ago

Overview
Opens Microsoft Excel and creates a new empty workbook. Starter template for any Excel automation.
Launch Excel
Excel spreadsheets are used to store and analyze large amounts of structured data. Robomotion offers a dedicated group of nodes to automate basic tasks in Excel spreadsheets, such as launching them.
What Launch Excel can do
Download Fixturessubflow thenBuild Default Path(Core.Programming.Function) setsmsg.default_excel_path = $Home$/templates/excel-automation/launch-excel/fixtures/sample.xlsxand initialisesmsg.retry_count = 0.Core.Dialog.InputBoxtitledLaunch ExcelpromptsSelect the excel file...with that default →msg.selected_file.Validate(Core.Programming.Function,outputs: 2) — requiresmsg.selected_fileto match/\.xl\w*$/i(covers.xls,.xlsx,.xlsm,.xlsb); otherwise falls through toCore.Flow.Stop.Robomotion.MicrosoftExcel.OpenExcelopensmsg.selected_filewithoptVisible: trueand returnsmsg.excel_app_id.Core.Trigger.Catcharound the open — on failure it incrementsmsg.retry_count, sleeps 2s viaCore.Programming.Sleep, andCore.Flow.GoTojumps back to theRetry Pointlabel; after one retry it stops withfailedand reasonExcel open failed after 1 retry.
Behind the scenes
- The flow intentionally leaves Excel open after launch — there is no paired close/save. This is a pure "open" demo template meant to be extended.
- The extension check uses a regex (
\.xl\w*$) rather than a file-picker filter, so it matches the full Excel family (.xls,.xlsx,.xlsm,.xlsb) while still rejecting unrelated paths. - The single-retry pattern (
Core.Trigger.Catch+Core.Flow.Label+Core.Flow.GoTo) is reusable boilerplate for any "try once, retry once, then fail" open/launch node.
More excel automation templates
See all 5 →- Consolidate Excel ReportsCombines rows from multiple Excel workbooks in a folder into one consolidated sheet. A reporting helper that removes repetitive copy-paste work.
- Launch Excel and Extract TableOpens an Excel workbook and reads its first table into a structured message variable. Ideal starting point for data-driven flows.
- Manipulate Excel Data Using SQLLoads Excel data into an in-memory SQL engine and runs a SELECT / UPDATE statement against it. Gives you database-level expressiveness over spreadsheet data.
- Search and Replace Excel ValuesPerforms a find-and-replace across an Excel worksheet and saves the result. Handy for bulk corrections or masking sensitive fields.