Stack Overflow
Stack Overflow

Questions tagged [exceljs]

Node package to read, manipulate and write spreadsheet data and styles to XLSX and JSON.

508 questions
0
votes
1 answer

How to push values from array into row?

How to push values from array into row in exceljs? i try with this: const columns = ['string', 'string2', 'string3']; for(let i=0; i < columns.length; i++) { workSheet.getRow(1).values = [dto.columns[i]]; } but this code add only one item…
user14011238
0
votes
1 answer

How to filter by a column in exceljs with Javascript before transcribing results to Google Sheets API via Node

I have written a script which uses the following: // https://nodejs.org/ // https://developers.google.com/sheets/api/quickstart/nodejs?hl=en // npm install googleapis@39 --save // https://www.npmjs.com/package/exceljs I need to somehow map or…
Pieter Poggenpoel
  • 1
  • 2
0
votes
1 answer

Grouping various rows using exceljs for angular

I have been using exceljs to create excel files and downloading them. I have currently run into the problem of grouping them something like this: Click here for grouping example Is there any way of doing this using exceljs? I have tried…
Ish Montalvo
  • 171
  • 1
  • 11
0
votes
1 answer

Excel data validation using Excel js

I need help with cell validation. I have the min and max value. I have already stopped users to enter special characters in a cell. However, in testing I found that users can enter % in a cell and excel is not prompting the user for the invalid…
Meet
  • 243
  • 2
  • 13
0
votes
1 answer

Excel add-in custom functions compatible with existing com Add-in UDF

I have existing custom function created in Com Add-in. To support MAC and online I am creating a web Add-in. I have included the equivalent add-in in the manifest. but the web add-in does not recognize the custom function created in com add-in when…
Vikas Sawant
  • 43
  • 1
  • 10
0
votes
1 answer

My firebase cloud function doesn't execute the code inside the nested foreach that inserts the table row

The "INDEX" sheet is created and has all its data and the sheets titled with the "product code" are created but completely blank. The console log function inside the inner foreach loop does print the data on each iteration but yet the insertRow…
Michael Sam
  • 31
  • 4
0
votes
2 answers

Need to create Excel File and download in client browser - Is it possible to create a file stream and send it in the Node Express response?

I'd like to create an Excel File stream in Node Express and send the Excel file in the Node Express response to then be downloaded by the client browser. Problem is I'm completely inexperienced with streams and I'm not even sure this is possible. A…
Joe Schmoe
  • 31
  • 3
  • 6
0
votes
2 answers

How to use JS Excel API in my web application using data from my server

Is it possible to run js excel api in my web application using data from my server. I want to use this api as a replacement of html data table. Need a step by step guide if possible and what are the T&C for any commercial use.
blueCoder
  • 17
  • 5
0
votes
1 answer

ExcelJS: doesn't save file properly

I wrote an script and here's an snippet from my code: let workbook = new Excel.Workbook(); await workbook.xlsx.readFile('./input.xlsx'); await workbook.xlsx.writeFile('./output.xlsx'); console.log('file saved!'); I know how async/await works and…
Masih IT
  • 52
  • 10
0
votes
1 answer

input function using user prompt

I've posted this question before without success. I have some lines making one user menu getting data from exceljs. 1 - How to put while condition inside this function, to get all rows to menu? Looks like switch(input) doesn't accept loop. The logic…
user13054316
0
votes
1 answer

exceljs reading one cell than parsing into await page.$eval

let's see this one now! I have one code placing a string into input type then clicking on submit. I need to read one excel to get the string then place on that input. The problem is I'm getting error because I can't use await.page inside the excel…
user13054316
0
votes
2 answers

how to download the excel file on clicking a button using npm package exceljs

I have created a get api in nodejs where I am using a third party package exceljs, The get api is working fine and when I am calling the get api in browser as http://localhost:3000/createExcel it is downloading the file as excel sheet but I want…
Ronak07
  • 894
  • 5
  • 26
0
votes
1 answer

Using exceljs node package create xlsx file

I am using exceljs 3.8 to create new xlsx file but some reason below code not working ? createNewExcelFile: function (excelFilePath) { //excelFilePath: Provide path and file name for excel file // load exceljs module …
jsduniya
  • 2,464
  • 7
  • 30
  • 45
0
votes
1 answer

I need to sum the columns by a particular condition and display in the row as total using exceljs nodejs

Here is my excel file I generated using exceljs.I need to add the weight for every grnNo and display the result as a total at the end of that particular grnNo,Something like this. Here is my code var userss = inward.aggregate([{ …
naveen
  • 25
  • 7
0
votes
1 answer

addConditionalFormatting is not found in exceljs

I am using exceljs 3.8.2. In documentation there is an method addConditionalFormatting for conditional formatting. But after installation this method is not found. I am using below code. import { Workbook, Worksheet, Cell, Fill, Row } from…
Manoj
  • 4,951
  • 2
  • 30
  • 56
1 2 3
…
33 34