Stack Overflow
Stack Overflow

Questions tagged [exceljs]

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

508 questions
2
votes
1 answer

How to read .xlsx data and push to array in .js script for photoshop

How to read .xlsx data and push to array in .js script for photoshop defaultkrt0iuh8hlot I am building some automation for work and have reached my limit of comfortable knowlege in scripting. I have an .xlsx file where: column A1 thru A20 represents…
MKriegerTW
  • 23
  • 4
2
votes
2 answers

Calling a async function with await inside worksheet.eachRow() in exceljs package

const Excel = require("exceljs"); const fs = require("fs"); const createConnection = require("./db.connection"); const SEGMENT = require("./models/segment"); const fileName = "test.xlsx"; createConnection(); //Db connection const readExcel =…
drake1994
  • 69
  • 11
2
votes
2 answers

Send email with Excel attachment using @nestjs/mailer

I'm trying to send email with excel attachment through @nestjs/mailer: await this.mailService.send({ //service with @nestjs/mailer to: messageTo, subject: messageTitle, template: 'application-approved', context: { …
BioStunt
  • 73
  • 6
2
votes
0 answers

Exceljs: Excel warning when opening file after some worksheets duplication

I am using Exceljs to generate excelfiles. From other issues I found that there is no API for duplicating worksheets so I have to do it by copying model from base worksheet to the target one. This works fine but when opening new document there is a…
vladPopovschii
  • 46
  • 4
2
votes
1 answer

Exceljs How to addRow and merge cells

So I need to generate an excel spreadsheet based on data from DB. Once I add in all the data from the DB I need to add in a new row at the bottom that says when the spreadsheet was generated like so: I don't know how to get the cells to merge here,…
Nayeer Mahiuddin
  • 187
  • 3
  • 16
2
votes
0 answers

Express CSV download link in email triggers download on mac but not windows

I'm using Express and ExcelJs to create a CSV that users can download. I'm sending the users an email using Sendgrid and putting the params in a link in the email that dynamically generates the CSV. Everything works locally, and on macs. But on…
thesofaking
  • 45
  • 1
  • 7
2
votes
1 answer

xlsx error : Removed Records: Document Theme from /xl/workbook.xml part (Workbook)

I have a node app where I'm fetching an excel file from an s3 bucket, and converting the buffer to excel file using the exceljs node library. When I try to open the converted xlsx file, I get a pop-up asking to repair the file as follows : When I…
Sai Krishna
  • 593
  • 1
  • 8
  • 25
2
votes
0 answers

exceljs wrapText doesnt work on merge cell

workSheet.getCell(`B7`).alignment = { vertical: 'middle', horizontal: 'left', wrapText: true // autoHeight }; its only work on 1 cell B7 if i tried to merge cell on B7 and F7 the text doesnt wrap. i have tried logic with get height…
Yogi Arif Widodo
  • 563
  • 6
  • 22
2
votes
2 answers

ExcelJs dynamic hyperlinks not routing

I created a workbook in Exceljs and added some worksheets dynamically do them. Basically I have a master worksheet that is the first thing you see when you open it up. However, I've also created player profiles for each person in my initial table.…
4156
  • 380
  • 4
  • 17
2
votes
0 answers

How to resolve Cannot read properties of undefined (reading 'Workbook') for EXcelJs?

I'm using exceljs plugin to export file from my angularjs application. I added it into bower.json and into package.json. package.json: bower.json: I added this is into my exportCsv function to export csv file $scope.export = function() { …
slema imen
  • 75
  • 1
  • 10
2
votes
1 answer

Floating point error while reading excel file from js

I am reading an excel file that has decimal, string, and Unicode characters when the user uploads it. I am seeing a floating point error when reading some decimal values(not all). For example, if a number is 0.15 then it is read as 0.150000000002. I…
nandhini venkateshwaran
  • 21
  • 1
2
votes
0 answers

Add image in streaming mode with exceljs

I'm developing a reporting system. In study the exceljs library I verified that the streaming mode due to the volume of data, and in the tests it would suit me and it really suited me perfectly. However, I have a problem, it does not let you add an…
Vinicius Ramos
  • 21
  • 1
2
votes
1 answer

Exceljs cell contains a function

I am trying to generate an Excel sheet using Exceljs on NodeJS. I need to get a particular cell (E4) for which I have this code written. var row = worksheet.getRow(4); var compInfra = row.getCell(5); The cell ('E4') contains a value as the result…
Raja
  • 71
  • 1
  • 5
2
votes
1 answer

exceljs conditional formatting of cells

I am using exceljs to create an excel workbook. A sheet will have a range of A1:AR106. My data objects will contain 3 properties (numtype, nummax, nummin). Only properties nummax and nummin will appear on the sheet. I can successfully create the…
99Valk
  • 203
  • 1
  • 7
  • 17
2
votes
1 answer

ExcelJS: Javascript Heap Out of memory when processing 100+ MB data

I'm trying to create an excel file with 100+ MB data using exceljs. Everything is fine from processing the data, creating columns and sheets, but the problem comes when writing the file using workbook.xlsx.writeFile(filepath) which the error was…
DMDJ
  • 357
  • 1
  • 6
  • 13
1 2 3
…
33 34