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

exceljs read Date Cell with format

I've a problem when I'm reading a Date value from columns in a excel file using exceljs package, I can't get the truth value in the correct format like a Date data type, instead I get a number. My project is build with Nest, and I use exceljs to…
Hector
  • 691
  • 2
  • 14
  • 28
0
votes
0 answers

Angular App Error when trying to use XLSX.writeBuffer()

I'm getting a mysterious error when trying to use the xlsx.writeBuffer() method in my Angular app to try and download an Excel file to the client browser. After finishing all the changes that needed to be made to the workbook, I try to download it…
A. Lewis
  • 67
  • 8
0
votes
0 answers

Error while exporting file using ExcelJS - ERROR Uncaught (in promise): TypeError: u.readFile is not a function

I am trying to export a file on the client side using ExcelJS in Angular 10. While clicking the export button i get the following error in browser console. core.js:4197 ERROR Error: Uncaught (in promise): TypeError: u.readFile is not a…
heretolearn
  • 6,387
  • 4
  • 30
  • 53
0
votes
0 answers

Exceljs not load static file

I have a need to generate the received data in excel, however I am facing the problem of accessing a static file on my server I use NuxtJS + VUE a static Excel file is located in my /static folder /static/Excel.xlsx /static/Word.docx If I try to…
Ярослав Прохоров
  • 531
  • 1
  • 6
  • 24
0
votes
1 answer

How to merge cells when data in the row is this same?

I have an excel file generated with using excelJS and i must to merge cells when the date field is this same, so for example: Date | Hours | Total hours 14.10 | 3 | 3 15.10 | 4 | [THIS CELL MUST BE MERGED WITH CELL BELOW] 15.10 | 1 …
testtesttest
  • 1
0
votes
0 answers

Error occurred on saving new excel file using exceljs writeBuffer

I am using exceljs library in my angular/electron project and I am trying to save a new updated excel file but an error occurred. my code: const workbook = new Excel.Workbook(); const data = await fs.promises.readFile('item.xlsx'); const wb =…
Mhmd Backer Shehadi
  • 559
  • 1
  • 12
  • 30
0
votes
2 answers

Remove Excel workbook onSelectionChange event

I am working on a Excel Web Add-In using Office.js. I added onSelectionChange event for a workbook and later trying to remove it, but this event still works. Here you can find an example that I created with ScriptLab, that shows that event can not…
Sergey
  • 45
  • 5
0
votes
0 answers

Node Module import error for exceljs-Namespace 'NodeJS' has no exported member 'TypedArray'

After implementing exceljs functionality I ran npm install and tried to run the app using ng serve and I am getting the below error. ERROR in node_modules/exceljs/index.d.ts: - error TS2694: Namespace 'NodeJS' has no exported member…
user9244477
  • 1
  • 1
0
votes
1 answer

How to read the background color with exceljs?

I'm reading an Excel Workbook in a node.js application (TestCafe) with exceljs. I know how to retrieve the value of an Excel cell: worksheet.getRow(rowNum).getCell( colName ).value But I don't know how to retrieve the background color of this cell.…
thomasreuter.vf
  • 41
  • 1
  • 7
0
votes
1 answer

How to Flatten / Recompile Excel Spreadsheet Using sheetjs or exceljs on Write

We use excel as a configuration file for clients. However, our processes only run on linux servers. We need to take a master file, update all the client workbooks with the new information, and commit to GitLab. The users then check it out, add their…
Eric Hansen
  • 185
  • 1
  • 10
0
votes
3 answers

Trying to create excel file from ExcelJs but its give me corrupted file

Below code give me the corrupted file please help. exports.testExcelCreation = async function () { // construct a streaming XLSX workbook writer with styles and shared strings const options = { filename:…
Gopal Dutt
  • 5
  • 6
0
votes
0 answers

I am trying to update existing excel worksheet data but it gives me error: TypeError: Cannot read property 'toString' of undefined

I need to download a excel template, fill the data and upload back. I am using exceljs. reading file data, updating and then trying to save workbook gives error: "TypeError: Cannot read property 'toString' of undefined". await…
HalleyP
  • 1
  • 1
0
votes
0 answers

Type '(pattern: any, flags: any) => RegExp' is missing the following properties from type 'RegExpConstructor': $1, $2, $3, $4, and 7 more

I am trying to use exceljs 4 in Angular 9 and I want to provide support on IE 11. I am trying to follow the instructions provided on the official page of exceljs. I tried to add the below code to polyfills.ts file: (window as any).global =…
Pritam Bohra
  • 3,912
  • 8
  • 41
  • 72
0
votes
1 answer

How can I get the range of a hyperlink in Excel?

I am trying to get the range for all of the hyperlinks in a given selected range. I do not see a given method to do this like how you can with a formula. I was wondering if this is possible in Office.js
Harsh Patel
  • 151
  • 6
0
votes
0 answers

Dynamically adding columns

Is it possible to dynamically add columns to an excel table using exceljs? I wrote this code: let workBook = new excel.Workbook(); let workSheet = workBook.addWorksheet('report'); workSheet.getRow(1).values = columns; which…
user14011238
1 2 3
…
33 34