Stack Overflow
Stack Overflow

Questions tagged [exceljs]

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

508 questions
0
votes
0 answers

How to stream data concurrently for multiple requests in node js?

I am using node for server side and mysql for databse. I want to make a download functionality which gives user an option to download 1 million records in an .xlsx file. As the data size is too large , i had to go for streaming solution. But when…
Gaurav Bisht
  • 1
  • 1
0
votes
1 answer

Is it possible to create one storage for login token instead of multiple storages?

We've developed Excel JS add-in on React. Now we started with login functionality and faced with a following problem. Currently our custom login token should be saved in 3 workspaces (ribbon, task pane and custom functions). Is it possible to…
sveta_d
  • 103
  • 6
0
votes
0 answers

Why does foreach loop skip executing foreach code nested within?

I have got images in the 'images' folder named as such; 100.jpg 200.jpg and on.. I have an excel sheet that has values in the first (A) and second (B) column as such; A B 100 101 200 102 and on.. I tried writing a small program that renames…
mysamza
  • 387
  • 1
  • 6
  • 22
0
votes
1 answer

Angular Routing Problem after excel download

My Routing works if i dont download the excel file but if i download file and then use routing then it fails. The Line which seems to be problematic is this line: **const Excel = require('exceljs');** This line is inside function which download…
neo
  • 164
  • 1
  • 17
0
votes
2 answers

Exceljs+nodejs to serve excel stream

Suppose I want to use exceljs to serve excel to web clients. Also, suppose that I am using streaming (due to the files being potentially large and not wanted to keep them in memory). Is it possible to find out what the Content-Length header should…
nodel
  • 471
  • 6
  • 22
0
votes
0 answers

Office.js - Office.context.ui.messageParent does not get call after protecting a sheet in dialog box

I am working on a project which has Office.js implementation. In Excel, I am opening a dialog box on a protected sheet, adding some items which on turn invokes Office.context.ui.messageParent and insert items in new rows in sheet after unprotecting…
Rohan
  • 71
  • 7
0
votes
2 answers

Exceljs Angular 8 Change csv delimiter

I would like to use exceljs to write a csv file with writeBuffer. How can I change the csv delimiter. On github there was an issue that you have to do it with fast csv options. But first thing is that writeBuffer has no options parameter, and second…
Franki1986
  • 1,320
  • 1
  • 15
  • 40
0
votes
1 answer

excel-js: Create a named range with a formula with relative reference (R1C1 notation)

When trying to create a named range for a formula that uses relative reference. In R1C1 notation, it would be R[1]C[1]. But any possibility I tried gave me an absolute path. Even if I did "=Sample!B1", I would see a "=Sample!$B$1" created. Is there…
Rafael
  • 31
  • 4
0
votes
0 answers

Send exceljs workbook to Backend

In my client side , i created an excel file , i worked with exceljsworkbook. I would like to send that excel file to my backend side (symfony ). my code : sendExcel(fileObj : File) { let headers = new HttpHeaders({'Content-Type' :…
patron
  • 59
  • 3
  • 10
0
votes
0 answers

Exceljs locking cell creates empty rows

I need help in locking cells using excel js modules. I am using node js. I have created some dummy rows and added a formula. All I need is the user can only edit numerator and denominator columns. When I pass in getCell(C1).protection. All it does…
Meet
  • 243
  • 2
  • 13
0
votes
0 answers

NodeJS Array Filter does not get Includes property after pushing object to array

I am trying to create REST API services reading data from Excel. But I can not use the include or indexOf property of Array Filter that is holding data from excel. It shows TypeError: Cannot read property 'includes' of null. I have tried using…
Mamunur Rahman
  • 11
  • 3
0
votes
1 answer

Using exceljs and trying to make local vars in readfile function global

Hi I am using exceljs with JavaScript for my project but all of the variable that I modify within the readFile function are not changing outside scope. //array for pdm paths var arrFundPartyRole = []; //mapping UI_id -> UI_Label var labelUIMap =…
nedesai
  • 1
0
votes
1 answer

can not download file when set optimization=true in angular.json file

I am using exceljs and file-saver.js in my project, and it worked fine in my dev environment, but when i build in prod env, i could not download file anymore, does anyone help me? When i set optimization=false in prod configuration, it worked…
Shown
  • 31
  • 4
0
votes
2 answers

"Http failure during parsing" when trying to download excel file created in nodejs (exceljs)

I'm Trying to download to the client an xls file created in the nodejs (using exceljs). The creation is based on http://www.ihamvic.com/2018/07/25/create-and-download-excel-file-in-node-js/ For some reason - I can't save the file in the client - I'm…
Guy E
  • 1,775
  • 2
  • 27
  • 55
0
votes
1 answer

ExcelJS - How to set active the first sheet

i am trying to write an excel file with multiple sheets. but somehow i struggle to find the syntax to set the excel file active on the first sheet when we open the file. Currently it is always active on the last sheet. here is snippet of my code let…
Nikolius Lau
  • 653
  • 2
  • 11
  • 21
1 2 3
…
33 34