Connect the names of the sheets with the data in the tables

I have a simple question: I want to connect specific sheet names in my workbook with a table that contains a range of dates. The sheet names should be something like "blablabla" + Table@1.

Although I have attempted to design a solution, it doesn't seem to be working as expected.

function main(workbook: ExcelScript.Workbook) {
  let i = 0;
  let sheets = workbook.getWorksheets();
  let dates = workbook.getTable("Months").getColumn(1).getRange().getCell(i, 1); 
  for (let sheet of sheets) {
    if (sheet.getName().includes("Capacity split -") && !sheet.getName().includes("Capacity split - Next quarters")){
      let newName = 'Capacity split -' + dates[i];
      console.log(newName);
      sheet.setName(newName)}};

}

I have included screenshots to provide a clearer explanation of what I am trying to achieve.

Screenshots of Tabs :

https://i.sstatic.net/WKkXJ.png

Data in the Table:

https://i.sstatic.net/8r6hv.png

The goal is to establish a connection between the first cell in the table and the corresponding tab.

Can you please assist me with this issue?

Thank you in advance!

exceltypescriptoffice-scripts

Answer №1

With the invaluable assistance of Jakob from Microsoft, we were able to successfully arrive at the following solution:

function main(workbook: ExcelScript.Workbook) {
  let i = 1;
  let sheets = workbook.getWorksheets();
  //Retrieve values from the table
  let dates = workbook.getTable("Months").getColumn(2).getRange().getValues(); 
  //Rename targeted sheets with temporary names
  for (let sheet of sheets) {
    if (sheet.getName().includes("Capacity split -") && !sheet.getName().includes("Capacity split - Next quarters") && !sheet.getName().includes("Capacity split - Dyn overview")) {
      sheet.setName(sheet.getName().replace("Capacity split -", "temp"))
    }
  }
  //Rename targeted sheets with final names    
  for (let sheet of sheets) {
    if (sheet.getName().includes("temp")){
      let newName = 'Capacity split - ' + dates[i][0];
      i+=1;
      sheet.setName(newName);
    }
  }
}

We extend our heartfelt gratitude to everyone for their time and support!

Nicolas.

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

A guide on leveraging typeof within function parameters to ensure accurate variances

Let's create a simple class hierarchy and a list of instances. The goal is to filter items from the list of instances based on their class. There are a couple of challenges: We cannot use the typeof T syntax. How can this be written? We cannot decla ...

typescripttypeof

Using Typescript to set the image source from a pipe

I've been working on creating a custom pipe similar to the code below: @Pipe({ name: 'imagePipe' }) @Injectable() export class ImagePipe { constructor(public someService: SomeService, public storage: Storage) { } transform(value: ...

angulartypescriptionic2

How can you export the type of a private class in TypeScript without exporting the class itself?

I am facing a dilemma in my module where the public method of a public class is responsible for creating and returning a new instance of a private class. The stipulation is that only MyClass should have the capability to instantiate MyClassPrivateHelper. ...

typescripttypescript-typings

What is the best way to retrieve a string from a URL?

Is there a way to extract only a specific string from a URL provided by an API? For instance: I'm interested in extracting only: photo_xxx-xxx-xxx.png Any suggestions on how to split the URL starting at photo and ending at png? ...

javascriptnode.jsregextypescriptparsing

Establish a Svelte and TypeScript "observe" script for developing vscode extensions

Hi there! As a newbie in TypeScript, Svelte, and VSCode extension development, I have my first question to ask ...

typescriptvisual-studio-codevscode-extensionssvelte

Can the return type of a function be determined dynamically at runtime by analyzing a function parameter value?

Let's delve into this concept with an illustrative example! interface Query { foo: any; } interface Mutation { bar: any; } type OperationName = keyof Query | keyof Mutation; const request = async <T>(args, operationName: OperationName): P ...

typescript

Find all objects in an array that have a date property greater than today's date and return them

I have an array of objects with a property called createdDate stored as a string. I need to filter out all objects where the createdDate is greater than or equal to today's date. How can this be achieved in typescript/javascript? notMyScrims: Sc ...

javascripthtmlarraysangulartypescript

increase the selected date in an Angular datepicker by 10 days

I have a datepicker value in the following format: `Fri Mar 01 2021 00:00:00 GMT+0530 (India Standard Time)` My goal is to add 60 days to this date. After performing the addition, the updated value appears as: `Fri Apr 29 2021 00:00:00 GMT+0530 (India St ...

javascriptangulartypescript

Abort S3 file upload using ASW-SDK

Is there a way to abort an upload without raising an error Upload aborted. when calling upload.abort()? import { PutObjectCommandInput, S3Client } from '@aws-sdk/client-s3'; import { Progress, Upload } from "@aws-sdk/lib-storage"; cons ...

javascripttypescriptamazon-s3aws-sdk

What is the best way to access a component's data within its method using Vue and Typescript?

Starting a Vue.js project with TypeScript and using single file components instead of class-styled ones has been my goal. However, I have encountered a recurring issue where I get error TS2339 when trying to reference my components' data using the "th ...

typescriptvue.js

Converting JSON to string in Typescript is causing an error where type string cannot be assigned to type '{ .. }'

Here's the code snippet I'm working with: interface ISource extends IdModel { source_type_id: number; network_id: number; company_connection_id: number; feed_id: number; connection_id: number; feed_ids: number[]; name: string; tag ...

javascripttypescriptvue.js

The geolocation feature is operational in the browser test, but it is not functioning properly on the

I am currently creating an application that requires accessing the user's location at a specific point in time. To achieve this, I have utilized the ionic native geolocation feature which communicates with the Google API for reverse geocoding. Everyt ...

androidcordovatypescriptionic-frameworkgeolocation

Releasing Typescript 2.3 Modules on NPM for Integration with Angular 4

Although there are instructions available in Writing NPM modules in Typescript, they are outdated and there are numerous conflicting answers that may not be suitable for Angular. Additionally, Jason Aden has delivered an informative presentation on youtu ...

javascriptnode.jsangulartypescripttypescript2.2

Trouble encountered when attempting to call a function within another function in StencilJS

I am currently following a tutorial on building a drag and drop file uploader using StencilJS for some practice and fun. However, I have encountered an error in the code. Below is a snippet of the code, but I can provide more if necessary. @Component({ ...

typescriptstenciljs

How can I get rid of the table borders and set colors for every other row in the

How can I remove the border lines from a table and assign colors to alternate rows in the table? Follow this link for the code: https://stackblitz.com/angular/kooxxyvddeqb?file=app%2Ftable-sticky-columns-example.css Thank you in advance ...

htmlcssangulartypescript

An unusual problem encountered while working with NextJS and NextAuth

In my NextJS authentication setup, I am using a custom token provider/service as outlined in this guide. The code structure is as follows: async function refreshAccessToken(authToken: AuthToken) { try { const tokenResponse = await AuthApi.refre ...

typescriptauthenticationnext.jsnext-auth

Error message stating 'Module not found' is displaying in the browser console

As a beginner with Angular CLI, I recently executed the following commands at the root of my Angular project. issue-management\src\webui>ng generate module pages\dashboard issue-management\src\webui>ng generate component pag ...

angulartypescriptangular-cli

Step-by-step guide on building a mat-table with nested attributes as individual rows

Here is the data structure I am working with: const families = [ { name: "Alice", children: [ { name: "Sophia" }, { name: "Liam" ...

javascripthtmlangulartypescriptangular-material

What is the process for setting the value of a TextField based on a Dropdown Selection?

I have a question regarding the code snippet below. I am wondering how to set the value of a specific TextField based on the selected item in a Dropdown component named ChildComponent. import * as React from "react"; import ChildComponent from './Ope ...

reactjstypescriptrenderingoffice-ui-fabrictsx

Class property in Typescript is initialized in the constructor, but is undefined in a member function

I'm encountering a recurring problem while developing an Electron application using Typescript. The backend has a set of controllers, with the AppController managing file system interactions and WindowController handling basic window functions. Here&a ...

typescriptelectroneventemitter