Node package to read, manipulate and write spreadsheet data and styles to XLSX and JSON.
Questions tagged [exceljs]
508 questions
0
votes
1 answer
Read Excel file from Google Cloud Storage
I am trying to read a spreadsheet uploaded to Google Storage from Nodejs App running on App Engine.
The function offered by @google-cloud/storage package in Nodejs is createReadStream(). I am pass this stream to the Exceljs object.
The code is as…
thewebjackal
- 785
- 8
- 17
0
votes
0 answers
Nothing gets written while writing multiple rows into multiple sheets in a workbook using exceljs
I am trying to read a log file and then write the data into workbook containing multiple worksheets on the basis of set of conditions. I addRow to sheet whenever I encounter a particular node's data. Nothing is written in final workbook. The problem…
av92
- 120
- 1
- 10
0
votes
1 answer
ExcelJS CSV conversion fails to respect formulae
I'm using ExcelJs to convert an excel to .csv. Many a columns in the determined based on formulae.
var workbook = new Excel.Workbook();
workbook.xlsx.load(results.rows[0].map) //reading from PostGres bytea field
.then(function () {
…
lonelymo
- 3,972
- 6
- 28
- 36
0
votes
1 answer
How to custom ( style ) excel file with " exceljs " in Angular 7
I'm using ExcelJS to export excel file from JSON, the export works good but I need to add some changes in the excel file likes: color - font - width and etc.
And also I'm asking if I can write in an excel file already customized with a model.
Here…
Omar Mellouk
- 13
- 3
0
votes
1 answer
export html table to excel Angular 6
I have an object like this:
obj = {'a': [1, 2, 3], 'b': [0, 0,0], 'c': [1, 0, 4]}
I display it in a html table like this:
Code | sum1 | sum2 | sum 3
a | 1 | 2 | 3
b | 0 | 0 | 0
c | 1 | 0 | 4
And I want to export this…
Tenzolinho
- 922
- 2
- 15
- 35
0
votes
2 answers
Protractor ExcelJS.Click() returns ScriptTimeoutError and fails the tests
In my tests, the Protractor Test script is clicking on a button to download a file.
Bellow is the code snippet:
var today = new Date(),
timeStamp = moment(today).format('MMDDYYYY');
let G = GV;
let file =…
nhrcpt
- 862
- 3
- 21
- 51
0
votes
1 answer
How can I create a spy on a third party library with nested object - Excel.Workbook.xlsx.WriteFile()
I am using a third party npm library - exceljs to generate excel reports. The library has a function to write the generated file to disk.
Here is some code snippet
const workbook: Excel.Workbook = new Excel.Workbook();
// code to generate the report…
Geoff Kabule
- 139
- 2
- 11
0
votes
1 answer
Excel add-on instances
Is it possible to make the excel add-on in sync in two workbooks.
Following is the use case:
a. Our add-on required login, after login user can use the application.
b. When user open's add-on in other workbook, the add-on is starting from beginning.…
madireddy
- 107
- 3
- 13
0
votes
0 answers
ExcelJs : Workbook closes automatically after invoking Office.context.document.getFileAsync
Following is the one of the functionality in our product
a. Once user clicks on 'update' button, reads the Excel in byte format and send it to the server(java application server which saves that byte to database)
b. After getting success response,…
madireddy
- 107
- 3
- 13
0
votes
1 answer
Excel js, unable to make rest call
We are developing a excel plugin using Excel JS. The server code written in java and deployed in wildfy server.
Through excel plugin I'm unable to make the rest call to retrieve the user data. The aim is to perform login operation and retrieve the…
madireddy
- 107
- 3
- 13
0
votes
0 answers
Web Scraper: Generate Excel sheet from JSON data extracted from a website using the library Axios, cheerio and Exceljs
I want to generate the data in an excel sheet that i have extracted from a website in JSON format.
I have use this line of code to get the data in JSON format:
return new Promise((resolve, reject) => {fs.writeFile('scraper.json',…
Pikachu
- 35
- 3
0
votes
1 answer
How to solve ExcelJS 'Object doesn't support property or method assign' exception in IE 11
I use the component ExcelJS in my React application. The component works perfectly in all the major browsers (Chrome, Firefox, Edge), however in Internet Explorer it throws an exception related to the Javascript method assign():
Object doesn't…
CiccioMiami
- 8,028
- 32
- 90
- 151
0
votes
1 answer
How to insert multiple hyperlinks in the same cell
How can I add multiple hyperlink lines into the same cell using excelJS
https://github.com/guyonroche/exceljs
For instance: one cell would hold Google \n Gmail as hyper links
WalksAway
- 2,769
- 2
- 20
- 42
0
votes
2 answers
Downloaded xlsx file using exceljs and nodejs is opening in libreOffice but shows corrupt in excel 2007
This is my code. It creates a xlsx file which is opening in libreoffice but shows corrupt in excel-2007
also workbook.xlsx.write(response) downloads .zip file
Please help.
var Excel = require("exceljs");
var express = require("express");
var…
Abhinav Ankur
- 11
- 2
0
votes
1 answer
Exceljs writing file
I am getting data from DB and trying to populate the excel file. Unable to populate the excel file.
The code for writing data is as follow.
await users();
console.log("data " + JSON.stringify(test));
…
Adeel Tahir
- 187
- 2
- 10