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
0 answers

HapiJS: Corrupt File Download via Browser - Works via Curl

I'm struggling with an issue with HapiJS 11.1.4 and replying with a stream to serve the browser a file. The resulting download is corrupt. The main endpoint is /api/library/export and uses ExcelJS to generate a stream containing data for an XLSX…
kurt343
  • 145
  • 1
  • 13
2
votes
2 answers

get selected cell's value and address in Office.js excel

I am working on a Excel Web Add-In using Office.js. I need to get selected cell's Address and Value. Please be clear that here user will select only one cell. This should happen when user click on cell in worksheet.
user3881465
  • 239
  • 2
  • 5
  • 19
2
votes
1 answer

Problems setting up simple test project - Exceljs and Browserify

I'm trying to set up a simple test project to test ExcelJS via a browser application, and for the life of me I can not get Browserify to work properly. I bundle my code into a bundle file with the appropriate require calls and the resulting bundle…
John Riley
  • 468
  • 1
  • 6
  • 23
2
votes
2 answers

How to change global variable value and return the same in javascript

While printing Query, it just printing "Undefined" but i need the value fetching from the excel to be printed. this.getQuery = function(excelpath, sheetName, queryName) { var query; var workbook = new path.Workbook() …
Venugopal P
  • 217
  • 1
  • 2
  • 9
2
votes
0 answers

node exceljs is writing 0 byte file

I'm trying to append an array of integers as a row to an xlsx file. What I have creates the file and doesn't produce an error, but my file explorer (OS X) then says that the produced file is zero bytes and Microsoft Excel for Mac will not even open…
Austin
  • 6,921
  • 12
  • 73
  • 138
2
votes
0 answers

npm protractor xlsx file wait and retry

I am trying to run protractor with multi capabilities (around 30 browsers with diff versions) The data sheet is xlsx and is one sheet, which will be consumed. After each run the xlsx row will be updated that it has been 'USED' I use exceljs to write…
erchristopher
  • 53
  • 1
  • 1
  • 5
1
vote
0 answers

Cell colours not getting overridden with excelJS

The function is taking a xlsx file as input initially it will validate the file and mark all error cells red and download it. User will remove the errors on red cells and reupload the file In the excel sheet The first row in the file is…
Madhur Gera
  • 11
  • 2
1
vote
1 answer

How to add a complex formula in exceljs - JavaScript

I'm currently working on a project that requires to export data in multiple xlsx sheets. In one of them, I need to add formula in cells that verified some conditions before adding some data from the first sheet. Here is one of them: Ref !== null ?…
Bearcat29
  • 13
  • 3
1
vote
1 answer

How can i insert checkbox button into cell with nodejs

I want to insert checkbox button into cell and I want to check it when it true how can i do How can I insert checkbox button into cell with nodejs.checkbox button and I try to use exceljs, excel4node, xlsx i can't do it. Pls help!!!!
Gorrof
  • 11
  • 1
1
vote
1 answer

Export with dynamic column names in Excel js library Node js

I am trying to export excel file with dynamic columns and rows some columns contain values or some not. Please help me to solve that issue. I am using nodejs exceljs library. It's exporting data with static columns correctly but when I am trying to…
Learner
  • 177
  • 2
  • 15
1
vote
1 answer

Custom functions with TODAY() autorefresh when unrelated cells change

I have a custom function which takes a date as an input. I can also use TODAY() as an input like this: MY_CUSTOM_FUNCTION(TODAY()) and everything works fine. Let say in my spreadsheet I have 2 cells which have values A1:…
TDo
  • 686
  • 4
  • 9
  • 22
1
vote
1 answer

How can I embed a Highchart Image into an Excel File?

I'm having trouble trying to embed a Highchart's chart image into an Excel file. I am basically trying to use an existing "Export Excel" button on a website to now export a static image of the Highchart displayed on the website into an excel file.…
Rabiya
  • 23
  • 5
1
vote
1 answer

How to change the position of header columns of excel file using NodeJS

I have a dynamic JSON data fro which I am creating a Excel file using jsno2xls library nut here the resulting excel file header are like Year,DOB,Name and Age and I want excel data in this format Name,Age,DOB and Year.Is there any way I can perform…
Digvijay
  • 2,887
  • 3
  • 36
  • 86
1
vote
1 answer

Migrate ReactDOM.render with async callback to createRoot()

Does anyone know what is the exact equivalent of this code for React 18, what happens with the async part? ReactDOM.render(chart, container, async () => { //code that makes some chart cells styling and adds cells to a worksheet via exceljs })
Bozhidar Petrov
  • 113
  • 8
1
vote
1 answer

Can't download excel file from api - xlsx/csv

I return workbook as arraybuffer from api then trying to download on react side with blob. It downloads file but csv file has bunch of numbers not the proper data. Current Output { type: 'Buffer', data: [67,40,3,10....] } -from api .... return…
Fatih Can
  • 321
  • 4
  • 12
1 2 3
…
33 34