A pure JavaScript library to read, parse, edit, and write spreadsheets, or to convert them to different formats like JSON.
You can find more information at
Questions tagged [sheetjs]
277 questions
0
votes
1 answer
How do I export an HTML table to excel
I am trying to export an HTML table into an excel file.
Because I am already using sheetjs for importing excel files, I have been trying to use it as well for exporting.
Searching the internet, it seems to be only possible together with…
dummy
- 21
- 3
-1
votes
1 answer
How to mock xlsx / sheeetjs with jest?
Here is some code using xlsx library (=sheetjs):
import { read } from 'xlsx';
export default function foo(file){
return read(file);
};
and here is a unit test for it:
import foo from '../../../src/components/upload/demo';
it('foo', () => {
…
Stefan
- 10,010
- 7
- 61
- 117
-1
votes
1 answer
Security vulnerabilities for Sheetjs
We are using Sheetjs in Salesforce, and are planning to get the pro version. Before using this library in production I just wanted to know if there are any security vulnerabilities for this library in the past. And is there any potential data threat…
Bharat Ummadi
- 1
- 2
-1
votes
1 answer
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
Artem
- 1
-1
votes
1 answer
javascript library SheetJS. Pass string into excel parce function
I am using SheetJS library to parse xlsx file with javascript.
The way i got the file force me to pass received data as string into the javascript function.
Now I confused how do i pass the string into XLSX.utils.sheet_to_txt. What type of…
user2698308
- 145
- 2
- 12
-1
votes
2 answers
Wrong data format in exported Excel
I ask help here about a trouble with SheetJS js-xlsx that recently seems not to be supported actively. I already put an issue.
The point is that I want to use non-English data format (dates and numbers). When I export to XLSX file, the library does…
Miquel Al. Vicens
- 376
- 2
- 15
-1
votes
1 answer
Saving the edited ag-Grid
Pretty new to ag-Grid. I have loaded an xlsx file into ag-Grid. I have set the editable property to true to allow editing. Now I want to save/export this edited grid. How can I approach this?
Nauman Zafar
- 1,083
- 15
- 40