Choose particular spreadsheets from the office software

Question

Choose particular spreadsheets from the office software

My workbook contains sheets that may have the title "PL -Flat" or simply "FLAT"

I currently have code specifically for the "PL -Flat" sheets, but I want to use an if statement so I can choose between either sheet since the rest of the code is identical for both. Sometimes, both types of sheets are present in the workbook. I am open to various solutions to address this issue.

function main(workbook: ExcelScript.Workbook) {
        // Select the worksheet named "PL -FLAT"
        let flatSheet = workbook.getWorksheet('PL -FLAT');
        flatSheet.activate();

I've attempted to use the ternary operator (?) and write an if statement without success

javascript excel typescript office-scripts

Answer 1

Answer №1

Based on the documentation provided in this link, utilizing the if statement should resolve the issue. Here is an example of how it can be implemented:

let flatSheet = workbook.getWorksheet('PL -Flat');
  
if (!flatSheet) {
  flatSheet = workbook.getWorksheet('FLAT');
}

if (flatSheet) {
  flatSheet.activate();
}

Alternatively, you can use the getWorksheets method to retrieve a list of all sheets and then select the correct one based on its name.

let allSheets = workBook.getWorksheets();
let flatSheet = allSheets.find(s => s.getName() === 'PL -Flat');
if (!flatSheet) {
  flatSheet = allSheets.find(s => s.getName() === 'Flat');
}

if (flatSheet) {
  flatSheet.activate();
}

Answer 2

Based on the documentation provided in this link, utilizing the if statement should resolve the issue. Here is an example of how it can be implemented:

let flatSheet = workbook.getWorksheet('PL -Flat');
  
if (!flatSheet) {
  flatSheet = workbook.getWorksheet('FLAT');
}

if (flatSheet) {
  flatSheet.activate();
}

Alternatively, you can use the getWorksheets method to retrieve a list of all sheets and then select the correct one based on its name.

let allSheets = workBook.getWorksheets();
let flatSheet = allSheets.find(s => s.getName() === 'PL -Flat');
if (!flatSheet) {
  flatSheet = allSheets.find(s => s.getName() === 'Flat');
}

if (flatSheet) {
  flatSheet.activate();
}

Answer 3

Answer №2

To handle the possibility of both sheets not existing, utilizing a try/catch block can offer an effective solution.

function main(workbook: ExcelScript.Workbook) {
  let sheetNames = ['PL -FLAT', 'FLAT'];
  sheetNames.forEach(sheetName => {
    try{
      let flatSheet = workbook.getWorksheet(sheetName);
      flatSheet.activate();
      // your code
    } catch(error) {
      console.log(`Sheet ${sheetName} does not exist.`);
    }
  })
}

Answer 4

To handle the possibility of both sheets not existing, utilizing a try/catch block can offer an effective solution.

function main(workbook: ExcelScript.Workbook) {
  let sheetNames = ['PL -FLAT', 'FLAT'];
  sheetNames.forEach(sheetName => {
    try{
      let flatSheet = workbook.getWorksheet(sheetName);
      flatSheet.activate();
      // your code
    } catch(error) {
      console.log(`Sheet ${sheetName} does not exist.`);
    }
  })
}

Choose particular spreadsheets from the office software

Answer №1

Answer №2

Similar questions

How to retrieve an object's property within a component

Other options besides re-flowing and repainting

Tips for concealing the values within a selected dropdown list using jQuery

Creating a Bottom-Up Menu in React Native: A Step-By-Step Guide

React blank state - State remains undefined after calling setState

Attempted to identify whether an item exists in an array, and if it does, then add the item to the array; if not, then perform

Sending data in chunks using Vue.js

Is it possible for me to include the id attribute in an HTML element that has been generated using React

How to toggle element visibility when hovering in Angular?

Angular route fails to load the HTML file

Relaying event arguments from client-side JavaScript to server-side code-behind through ClientScript.GetPostBackEventReference

Changing SVG containing image tags into HTML canvas

Combining GET and POST requests in ExpressJS on a single route

Angular: Error when TypeScript object returns an array object value

Guide on adding pictures to an ExpressJS server

Retrieve the element located within a "block" element that is relative to the user's click event, without the

Jest does not recognize AnimationEvent as a defined element

What is the best way to implement function chaining in TypeScript?

Using Generic Types in TypeScript Files for React Components

Comparison between SSD and HDD animation speed in web hosting environments