What is the best way to insert values from an array into a row?

Question

What is the best way to insert values from an array into a row?

Is there a way to insert values from an array into separate cells in exceljs?

I attempted the following approach:

const columns = ['string', 'string2', 'string3'];

for(let i=0; i < columns.length; i++) {
    workSheet.getRow(1).values  = [dto.columns[i]];
}

However, this code only adds one item from the columns list :/

Does anyone have a suggestion on how to solve this issue? I need to add objects from the array individually, not as a group like this:

workSheet.getRow(1).values  = ['string','string2', 'string3'];

This method does not suit my requirements :( Appreciate any assistance

javascript typescript exceljs

Answer 1

Answer №1

To avoid always getting the last item inside the values property, you can reassign the value within the for loop by initializing the values as an empty array before the loop begins. This way, each item will be properly added to the values array.

const columns = ['string', 'string2', 'string3'];
workSheet.getRow(1).values = [];
for(let i=0; i < columns.length; i++) {
    workSheet.getRow(1).values.push(dto.columns[i]);
}

Answer 2

To avoid always getting the last item inside the values property, you can reassign the value within the for loop by initializing the values as an empty array before the loop begins. This way, each item will be properly added to the values array.

const columns = ['string', 'string2', 'string3'];
workSheet.getRow(1).values = [];
for(let i=0; i < columns.length; i++) {
    workSheet.getRow(1).values.push(dto.columns[i]);
}

What is the best way to insert values from an array into a row?

Answer №1

Similar questions

Tips for developing a versatile code for passport.authenticate

Troubleshooting import issues when starting with Webpack

Interactive Typescript slider with drag functionality

Avoid displaying hidden images or loading content upon clicking a tab

Adjusting Text Size Depending on Width

Editing the app.js file can cause it to malfunction and stop working

Implementing HTTP GET and POST requests in Angular 2 allows for the functionality of displaying, adding, and deleting objects within a list

Retrieving data from an anonymous function in AngularJS and outputting it as JSON or another value

Using Angular 2 to pass a function as an argument to a constructor

Using EventEmitter for Component Communication in Angular 2

Tips for assigning a value to a data property within a different Vue component

Understanding the grammar of the Web Speech API

Altering the appearance of a div following the execution of a header redirect

Utilizing turbolinks enables the page to be reloaded upon form submission

Avoid allowing multiple clicks on the submit button without disabling the validation group

When attempting to tab, the cursor is not entering the textbox as expected

Determine if a specific checkbox with a particular id has been selected using JQuery

What is the process for appending a file extension to a Next.js URL?

How can Firebase and Ionic be used to customize the password reset template for sending verification emails and more?

Angular not firing slide.bs.carousel or slid.bs.carousel event for Bootstrap carousel