15 questions
0
votes
1
answer
61
views
How to export Web Page UI as excel sheet using ReactJS
In my ReactJS application, I have a billing screen where users can create and preview bills. On the preview screen, there's an option to export the bill as an Excel file. I want the exported Excel ...
3
votes
0
answers
90
views
"Cannot access file" in ES module, that I could with CommonJS module (Electron JS app)
I'm building a desktop app using ElectronJS, which reads content of pre-existing XLSX files. I first created the app as a CommonJS module. Here's the minimal reproducible example code:
const path = ...
0
votes
1
answer
638
views
Node xlsx Heap out of Memory
I currently have a large array of data that I need to write to a new Excel file, however every time that I close the stream to the file, the process fails with the error
FATAL ERROR: Reached heap ...
1
vote
0
answers
74
views
How to specify different dateNF for different columns while exporting xlsx from json
I have following data -
{billDate: "21-1-2021", createdDate: "20-2-2021", modifiedDate: "20-2-2022"}
...
]
I have converted date string to date js objects.
While ...
0
votes
3
answers
880
views
ReactJS xlsx-js-style read local xls file
I have an imported file: import ExportReportCardTemplate from "asset/files/excel/report_card_template.xls";
How can I use it with library import * as xlsx from "xlsx-js-style";
I'...
1
vote
0
answers
783
views
JS xlsx json_to_sheet creates unwanted empty cells
I'm using this xlsx-js library to generate an Excel file from a list of json objects in a Vue3 application.
I need to have values in multiple cells, but it seems that it skips rows which have been ...
-1
votes
1
answer
217
views
How to use the Office.JS API to link to a cell in another workbook using SheetJS
How to insert a link to a cell from another workbook in a cell?
What should be the format?
I tried: #'[WorkbookName]sheetName'!D4
-1
votes
1
answer
990
views
How to read .xls with ExcelJS?
I'm having trouble reading a .xls file using the ExcelJS library. No problems reading .xlsx files. I used to use only the xlsx js library and did not have any issues reading .xls files.
I was under ...
2
votes
1
answer
1k
views
Floating point error while reading excel file from js
I am reading an excel file that has decimal, string, and Unicode characters when the user uploads it. I am seeing a floating point error when reading some decimal values(not all). For example, if a ...
1
vote
2
answers
4k
views
XLSX JS get header of column based upon address of cell
I'm using xlsx-js with nodejs, and I'm trying to read through an xlsx sheet with a calendar format. Where a 1 denotes that an activity had occurred during that day. I can loop through each row to see ...
4
votes
1
answer
14k
views
Sort and filter columns with XLSX js after json_to_sheet
I'm using this xlsx js library to generate an Excel file from a list of TypeScript objects in an Angular5 application.
I don't need all attributes of the TypeScript objects and I want to sort the ...
2
votes
1
answer
1k
views
Package type definition cannot be found
I am working on a AngularJS project using typescript. I am trying to use the js-xlsx library to parse an xlsx file and I get the compile error:
error TS2304: Cannot find name 'XLSX'
We are using a ...
3
votes
1
answer
24k
views
SheetJS: Do Not Include Headers In json_to_sheet
The SheetJS documentation shows a way to take a JSON Object and convert it to an Excel sheet. From their example:
var ws = XLSX.utils.json_to_sheet([
{S:1,h:2,e:3,e_1:4,t:5,J:6,S_1:7},
{S:2,...
1
vote
1
answer
1k
views
set Cell Style during export to excel in ui-grid
According to this link :
http://plnkr.co/edit/w8w96ltypkxrZAWA54c1?p=preview
I would set style to cell by this code :
s: { fill:{bgColor: {rgb: "034221" }},font:{name:"Aharoni"}}
but after ...
0
votes
1
answer
920
views
How to find the way to use SheetJS in AngularJS 1 dependency injection is not acceptable and error occurs
I cannot find anyone install the SheetJS to their AngularJS app with dependency injection.
I just found the guy without dependency injection and as a plunker here. But how to import library into ...