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

excelJs currency format for Japanese Yen

For excelJs the numFmt works just fine for USD however can't figure out how to format the number for Japanese Yen. USD format that works: '$#,##0.00' // works just fine // style : { numFmt : '$#,##0.00' } Formats that I have tried for the Yen:…
Johnny Major
  • 228
  • 1
  • 2
  • 8
2
votes
0 answers

Exceljs - TypeError: Cannot read property 'sheets' of undefined

I got this issue when I tried to read an excel file and I have no clue what caused the issue. Can someone give me a hint? exceljs version: 2.0.1 TypeError: Cannot read property 'sheets' of undefined at _callee10$ (/Users/tvi/Documents/BCM…
Tri Vi
  • 33
  • 1
  • 5
2
votes
1 answer

extract image from excel in nodejs

I am trying to extract all image in excel with node js.can anyone suggests any npm module for this. Here is an image of the excel file that I m using for the test.
Hemant Rajpoot
  • 683
  • 1
  • 11
  • 29
2
votes
1 answer

How to store values from excel file into array for testing

I can't handle it() - expect() couple along with exceljs's readfile() function. With this code i get the following error : "UnhandledPromiseRejectionWarning: Error: 'expect' was used when there was no current spec, this could be because an…
C DV
  • 45
  • 5
2
votes
1 answer

Set cell value with getCell() in table Excel JS

I'm stuck on this and can't find an answer on any website. I'm trying to set the value of the cell but I'm getting the following error: The property "values" isn't loaded. Please call the load method and context.sync() ... I do understand I need to…
J. Lavoie
  • 335
  • 2
  • 5
  • 23
2
votes
1 answer

How to import desgin of an Excel Template in Angular as Object

I want to Import data from Excel, after modification i want to export the updated data. I am able to import data from Excel file using XLSX package, but while i export the new data, all the styling is gone. I want persist the Design/Style/Theme of…
Ravi Shankar Dubey
  • 191
  • 1
  • 1
  • 10
2
votes
1 answer

How to return a document from within a Promise using exceljs

I have limited node experience so please forgive me if this is elementary. I have a Controller method which should return a downloadable excel document. I am unsure as to how I should return a document for download, specifically around the response…
Loki
  • 43
  • 1
  • 7
2
votes
1 answer

How to download excel sheet with image in excel js

I'm unable to download excel sheet with images. I am using exceljs. Data is appending correctly but when it comes to image, it is not displaying. I am getting data through json and appending in excel sheet through javascript. var workbook = new…
karthik reddy
  • 21
  • 1
  • 3
2
votes
0 answers

How to remove or delete data from an existing excel file using exceljs?

I have an excel file on my system stored at a specific location and I am using exceljs library to read and write data into it. When my code runs, data is being written in the excel file as an output. When the same code runs again, I want to delete…
QA_hacks
  • 257
  • 1
  • 6
  • 15
2
votes
1 answer

What is best way to import "exceljs" lib to angular

I'm using exceljs(https://www.npmjs.com/package/exceljs) to import and export excel file in an angular 7 app. Here is how I import it : import {Workbook} from "exceljs";even if it work perfectly but after build production and look at main.js by…
every Bit
  • 399
  • 1
  • 4
  • 18
2
votes
1 answer

How to add multiple table with different data-set to the same sheet in exceljs

I have a button to export a excel file with the data(JSON format). I can able to do for one table but I want to have multiple tables(different datasset-JSON) in the same excel sheet and export that file as shown below. I'm using exceljs and…
Aarthi Chandrasekaran
  • 569
  • 2
  • 10
  • 21
2
votes
0 answers

While using npm exceljs in nodejs and generating excel it's not opening in Microsoft excel 2007

I have used exceljs npm in Nodejs application to generate the excel file of my preformatted data. It is working as expected and downloading the excel file. The file is opening in all software except the MS Excel 2007. It is showing the error as…
Easwar Moorthy
  • 41
  • 4
2
votes
0 answers

Generating file on Express server and initiating client-side download prompt?

I am working with the ExcelJS module to generate an Excel file, but am having difficulty achieving the desired flow. What I'd like to have is: User clicks a button on the front-end (built with React) to download an Excel file. This triggers a…
DevDW
  • 21
  • 3
2
votes
2 answers

How to maximise performance for table row addition of 50K+ rows using Excel JavaScript API office Add-IN

I m trying to add large number of rows to table. My Project has requirement for large table addition. Please let me know if there is a better alternative to maximize performance. Should I use Range object API? The code is as shown below. function…
Pranav Bhagwat
  • 287
  • 2
  • 11
2
votes
2 answers

export excel sheet cell with specified date format

I am exporting empty excel sheet with some header values. In that excel sheet I want to set the date format like (mm/dd/yyyy) for date field. How to set the specified format for that cell. Here I defined excel sheet cells: var InstructionSheet =…
N15
  • 305
  • 2
  • 4
  • 17
1 2 3
…
33 34