Stack Overflow
Stack Overflow

Questions tagged [exceljs]

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

508 questions
4
votes
2 answers

import Excel from "exceljs" throwing error on browser TypeError: Cannot read property 'prototype' of undefined

I am building my webpage using react. I want to download my reducer's store data into a xlxs file. For that I am using exceljs package. I have install the exceljs using npm i exceljs. But when I tried to import exceljs to my componenet I am getting…
Sourabh Banka
  • 1,080
  • 3
  • 24
  • 48
4
votes
1 answer

Exceljs data validation list cause error in Ms. Excel

I use exceljs node module and add dropdown data validation worksheet.getCell(cell).dataValidation = { type: 'list', allowBlank: true, formulae: ['"One,Two,Three,Four"'], showErrorMessage: true, errorStyle: 'error', errorTitle: 'Error', …
CherryBelle
  • 1,302
  • 7
  • 26
  • 46
4
votes
0 answers

Prompt the user to save the .xlsx file in a particular directory

I'm using npm exceljs to export an .xlsx file. My issue is that instead of saving it to a default directory(./sor.xlsx), I want the .xlsx file to open up and let the user choose where to save the file. Code: workbook.xlsx.writeFile("./sor.xlsx") //…
bikash
  • 433
  • 1
  • 6
  • 18
3
votes
2 answers

How can I write xlsx to file in browser with ExcelJS?

I am trying to create an xlsx file in the browser and find https://github.com/exceljs/exceljs very powerful. However, I can't find a way how to save my xlsx object to a file. Probably I need to use Buffer, but how to generate a file from it? const…
Kirill Novikov
  • 2,576
  • 4
  • 20
  • 33
3
votes
1 answer

How to generate xlsx file trough Express with Exceljs and send it to client?

I want to separate controllers and services in my Express app, currently, I have a service that generates an XLSX file using ExcelJS, I want to reuse the service so, I don't want to pass the response object to the service, is there a way I can…
Luis Carlos Cruz Castillo
  • 160
  • 10
3
votes
2 answers

Node Js heap out for memory using excelJS package

I am using nodejs to create excel files on the server, when calls is greater then 20 heap memory error I got. I have use following technique as well but all in vain. npm install -g increase-memory-limit increase-memory-limit I have follow below…
hu7sy
  • 983
  • 1
  • 13
  • 47
3
votes
0 answers

Cannot read property 'xlsx' of undefined

I am using the exceljs library in angular. I am trying to export excel using the stream WorkbookWriter as there 2M+ records but getting the following error Here is the sample code import * as Excel from 'exceljs'; var options = { filename:…
Vaibhav Gupta
  • 51
  • 6
3
votes
1 answer

SheetJS: transpose row values from array to object

I am trying to create an array, where each "Working Day" is an object with an index and start/end date but I have no clue how to manipulate the JSON to have a specific structure. I am using the following package:…
mrks
  • 5,439
  • 11
  • 52
  • 74
3
votes
3 answers

How to export dropdown list(with options) from JSON to excel in Angular 8?

I am trying to export JSON data to excel which has a dropdown list. Is it possible to create the dropdown(with options) in excel if we pass an array as a cell value? I am trying to use the inbuilt library XLSX to achieve this but not able to see…
Bravo
  • 61
  • 2
  • 7
  • 26
3
votes
0 answers

Add html table into excel using ExcelJs library in Angular

I want to export html table into excel using excelJS library in angular. Is it possible?
Vikas Gore
  • 31
  • 5
3
votes
1 answer

Unable to export to excel using json data with xlsx using angular 8

I am unable to export an array of object to excel sheet with xlsx library using angular 8. here is my sample code to export json data to excel with multiple sheets. inside my app.html file.
Noob_coder
  • 31
  • 3
3
votes
0 answers

Excel function parsing in office-js

I would like to write an office-js excel addin that parses the used-range to find all formulas of the form "=foo(arg)" and populates an array with the addresses of the occurrences and the evaluation of arg. arg could for example be a cell reference…
Edmund Moshammer
  • 688
  • 7
  • 19
3
votes
1 answer

Insert a column in exceljs

I have an existing xlsx file, with 4 columns. [ A, B, C, D ]. I want to insert a new column between A and B to have => [A, B, C, D, E] where B is new and C, D, E are the old [B, C, D]. I haven't found a method in the doc page Doc :…
Kalkal
  • 161
  • 3
  • 14
3
votes
1 answer

Nodejs crypto.getHashes() returns an empty array

I was using exceljs' sheet protection feature when I encountered an error–Error: Hash algorithm 'sha512' not supported!. After taking a look into it's source files I discovered the cause of the error: crypto.getHashes() is returning an empty array.…
17KB
  • 90
  • 1
  • 1
  • 10
3
votes
2 answers

Sending an Excel file from backend to frontend and download it at the frontend

I had created an Excel file at the backend (Express JS) using Exceljs npm module. I have it stored in a temp directory. Now I would want to send the file from the back-end to the front-end and download it there when the user clicks a button. I am…
Navaneeth
  • 31
  • 1
  • 1
  • 3
1 2 3
…
33 34