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
1 answer

How to Format Export Excel Sheet using Angular

Need to export json data to the excel file(large data), I can able to download the file and need to do some styles to the excel file(font, color, headers). I tried file-saver, Could you please suggest how to format the excel file. loadData() { …
Rajasekhar
  • 2,215
  • 3
  • 23
  • 38
0
votes
0 answers

Exceljs return 'VERDADERO' instead 'TRUE'

I'm creating an app that uses import and export excel files, I need that excel returns in English TRUE and FALSE but instead returns VERDADERO and FALSO on the field acceptTerms, there is a way to export all in English, thanks async function…
D4ITON
  • 556
  • 6
  • 15
0
votes
0 answers

Half of the inputs aren't written to excel - exceljs and nodejs

I'm new to programming so I don't have a lot of experience and can be making some dumb mistakes. But I'm stuck with a problem that I don't understand why it doesn't work. I have a website with a form - that form after submitted should be stored in…
Ana Cláudia Faria
  • 35
  • 6
0
votes
2 answers

How to export to excel file from API

Have angular datatable and table contains more than 50k records, if we trying to export to excel taking lot of time and browser is not responding. If possible could you pls guide me how to export to excel with large det of data without displaying…
Rajasekhar
  • 2,215
  • 3
  • 23
  • 38
0
votes
1 answer

ExcelJS - Add Rows To Existing Worksheet

I have some xlsx files stored in an s3 bucket that I am trying to update. To do this, I am creating an array of rows from a series of json files (one at a time). I get the rows from each json file as follows. let worksheetRows = []; for (let i = 0;…
MountainBiker
  • 327
  • 5
  • 20
0
votes
2 answers

Write to excel on http post request in a non-blocking way

I have an endpoint on my web server that handles post requests having a body containing a query for a mongodb database. The result of the query is then written to an excel file using exceljs one document at a time. It works perfectly fine responding…
shin
  • 333
  • 3
  • 11
0
votes
0 answers

Get the address of the cell that invoked my custom function officejs excel add-in

Is it possible to get the address of the cell that invoked my custom function from excel JS API? When I use the invocation parameter in custom Function like this: /** * Return the address of the cell that invoked the custom function. *…
DeSanterra
  • 81
  • 1
  • 1
  • 8
0
votes
1 answer

Exceljs App "is working on your function" message

I modified an Excel ScriptLab function to remove duplicates and I run it as a button from the Ribbon. async function RemoveDuplicates() { await Excel.run(async (context) => { const sheet = context.workbook.worksheets.getActiveWorksheet(); …
Tomasz Decker
  • 114
  • 2
  • 14
0
votes
0 answers

How to parsing and get specific values from excel file?

In the excel document(*.xls), how to parsing and get specific values by javascript? Firstly, getting a specific number(per quantities in the product that red color) from a sentence in the "Name" or "Name2" field. Calculate "Price" and value from…
JsWizard
  • 1,663
  • 3
  • 21
  • 48
0
votes
1 answer

Iterate cell value exceljs

I want to know how can I iterate a json in a foreach and set the value to the cells F13 over the loop ends it can stop at F14 or F26 I have check the documentation but I don't understand very well about how can I make it I brought the data from the…
cesdav
  • 11
  • 5
0
votes
0 answers

Set picture to Excel with exceljs

I'm trying to set a picture that I have over my BackEnd I mean the image is in backend.com/images/picture.jpg my question is how can I set that image to the front and export in my excel file? I try to convert the image to Base64 sinse the URL image…
cesdav
  • 11
  • 5
0
votes
1 answer

How to set different font color for different cell in the same row?

I am using the `exceljs package to manipulate an xslx file. Here is my code. async function doExport(){ monthlyCalendar={ "calendarDateList": [ { "publicHoliday": false, "today": false, …
The KNVB
  • 3,588
  • 3
  • 29
  • 54
0
votes
1 answer

Post method does not trigger the "download excel workbook" function in exceljs

I am currently working on a React + Node application. The application stores data entries in a data base. Users should be able to download all stored data from the database to an excel workbook. To achieve this, I'm using exceljs npm module. The…
Ehizo
  • 15
  • 1
  • 4
0
votes
1 answer

How to check for blank cell using getcell in exceljs

I am writing a code where i am checking the contents of an excel file using exceljs. I have to check if a cell is empty but I am unable to do that. I have tried the following…
anita shrivastava
  • 319
  • 5
  • 18
0
votes
1 answer

Read a Excel file with exceljs syncrronuously

I'm trying to read a excel file into a csv-like looking array [ArrayLine1,ArrayLine2,..] with exceljs in nodejs. Exceljs has probably no solution to read a file synchronuously, so I have to build a solution around that. Because of my program in…
raah
  • 71
  • 2
  • 6
1 2 3
…
33 34