All I have created the following Flow to unfilter a spreadsheet, unhide columns and also select a cell. This is scheduled and runs each midnight, everyday
However im getting the following error:
Script Code is below:
function main(workbook: ExcelScript.Workbook) {
// ECPT (People) Tab
let dataSource = workbook.getTable("DataSource");
// Clear auto filter on table dataSource
dataSource.getAutoFilter().clearCriteria();
let people = workbook.getWorksheet("ECPT (People)");
// Set visibility of column(s) on people to true
people.getRange("A:AW").setColumnHidden(false);
people.getCell(3, 0).select();
// Dispositioned Roles Tab
let Dispositioned_Roles = workbook.getTable("Dispositioned_SupplyChain");
// Clear auto filter on table dataSource_Process
Dispositioned_Roles.getAutoFilter().clearCriteria();
let dispositioned1 = workbook.getWorksheet("Dispositioned Roles (POST ACE)");
// Set visibility of column(s) on process to true
dispositioned1.getRange("A:Z").setColumnHidden(false);
dispositioned1.getCell(2, 1).select();
// Eastern PServ Tab
let PServ = workbook.getTable("PServ_Contractor");
// Clear auto filter on table dataSource_Process
PServ.getAutoFilter().clearCriteria();
let Pserv1 = workbook.getWorksheet("Eastern PServ");
// Set visibility of column(s) on process to true
Pserv1.getRange("A:Z").setColumnHidden(false);
Pserv1.getCell(1, 0).select();
// ECPT (Process) Tab
let dataSource_Process = workbook.getTable("DataSource_Process");
// Clear auto filter on table dataSource_Process
dataSource_Process.getAutoFilter().clearCriteria();
let people2 = workbook.getWorksheet("ECPT (Process)");
// Set visibility of column(s) on process to true
people2.getRange("A:CU").setColumnHidden(false);
people2.getCell(3, 0).select();
}
How do I get the get.cell(x,x).select to work?
