Node package to read, manipulate and write spreadsheet data and styles to XLSX and JSON.
Questions tagged [exceljs]
508 questions
0
votes
1 answer
Date weird timezone (GMT+0009)
I use ExcelJS to parse an Excel into a JavaScript Object.
Here is an excel sample :
As you can see, I must cover multiple format for date and hour. For the date I have no problem. But when it comes to hour, cells with "12:30" and "15:00" value are…
Clément Drouin
- 187
- 2
- 11
0
votes
0 answers
how to upload an excel file (exceljs) to s3
I am trying to change locally a excel file and then upload it to s3.
var s3 = new aws.S3({ accessKeyId: config._ACCESS_KEY_ID, secretAccessKey: config._SECRET_ACCESS_KEY });
var dataFile = await wb.xlsx.readFile(file).then(function () {
var sh =…
haly
- 15
- 5
0
votes
1 answer
Wait for promise to finish before continuing
I know many topics has been about promises and callback. I tried many ways but still, I don't succeed to solve it.
What I want is to edit a file locally, save it then upload it to S3. then another function is called to read from the file and display…
haly
- 15
- 5
0
votes
1 answer
exceljs giving an error in lines for worksheet.columns = [] array in Angular
When I create a worksheet.columns = [] of data its show me that it is wrong.I am using VSCode and below has all details.
Version: 1.52.1 (user setup)
Commit: ea3859d4ba2f3e577a159bc91e3074c5d85c0523
Date: 2020-12-16T16:34:46.910Z
Electron:…
M.P.K Dilshan
- 3
- 3
0
votes
1 answer
Unhandled Rejection (TypeError): fs.createWriteStream is not a function
I am having a Unhandled Rejection when I try to run the function xlsx.writeFile() on my React webapp.
import Excel from 'exceljs';
const workbook = new Excel.Workbook();
const worksheet = workbook.addWorksheet('simpleXlsx');
worksheet.columns =…
Mateus FlowinTech
- 75
- 8
0
votes
1 answer
add row before header excel js in angular
i'm exporting json to excel by using excel js. json is getting sucessfully exported to sheet .but now i want to add one row which describes details of sheet above the header text.
for more details please refer image
code as follows
import {…
Shriram Salunkhe
- 35
- 2
- 10
0
votes
1 answer
styles not getting copied from source excel file
I am trying to read -> manipulate -> create excel. I am using streams supported by exceljs module. most of it is working fine, but the styles do not seem to be copied over. Below is my relevant part of the code.
const readerOptions = {
…
opensource-developer
- 2,826
- 4
- 38
- 88
0
votes
1 answer
Excel file contains {"sharedString":0} instead of actual value
I am trying to read from a excel file, manipulate and create another excel file from it, i am using stream support for this. Most of it is working fine but i see resultant excel file containing {"sharedString":0} instead of actual values.
Below is…
opensource-developer
- 2,826
- 4
- 38
- 88
0
votes
1 answer
Is there any way to find the value of a cell in excel depending on the font colour by Using ExcelJs in NodeJS
Is there any way to find the value of a cell in excel depending on the font colour by Using ExcelsJs in NodeJS
for example, I want to get all values inside an excel where they are colour font is grey
I am using a Nodejs, with exceljs
if there any…
ihssan
- 87
- 4
- 10
0
votes
1 answer
Replacing a placeholder text in Excel using javascript
We have an excel report template that has some placeholder text(keys) that will be replaced by certain values among creating the report.
we have searched everywhere but couldn't find any solution with javascript ( i know we can do it with c#/.Net…
Mahamad Husen
- 229
- 1
- 13
0
votes
0 answers
Reading 200K rows excel and doing a DB operation using the data with nodejs
I am new to NodeJs. I have to read 200K rows Excel .xslx file and using that data need to call DB and based on the query result needs to do some logic. I have implemented reading and writing on excel using exceljs module. But When I call DB I want…
springbootlearner
- 1,220
- 4
- 26
- 48
0
votes
1 answer
Read from a stream using fetch and create a excel file
I am trying to read from a excel file and generate a copy of it / write to another excel file.
I have been able to read the file correctly and create a buffer object out of it, below is the relevant part of my code.
let fn =…
opensource-developer
- 2,826
- 4
- 38
- 88
0
votes
1 answer
Wait for Google translate api before writing to excel sheet
I can't figure out how to make my code wait for google translate before trying to write to the excel sheet. In the console i can see the translated data but in the excel doc it is still in the original language. i know I'm doing this all wrong but I…
Adrian Sultu
- 330
- 5
- 16
0
votes
1 answer
Downloading excel file using ExcelJS and node js not being downloaded in any browser
I was trying to send .xlsx file using exceljs and nodejs to the client as a downloadable file. So far I'm able to create employees.xlsx file but it's not triggering save file dialog in the browser. Here's what I've tried in my backend API:
My…
Kirubel
- 1,461
- 1
- 14
- 33
0
votes
2 answers
how can i use exceljs in fastify？
I use exceljs like this but it returns a error.
TypeError: pipe.write is not a function
and
"message": "Cannot read property 'summary' of undefined"
let workbook = new Excel.Workbook()
let worksheet = workbook.addWorksheet('calogs')
…
radiorz
- 1,459
- 4
- 18
- 36