Stack Overflow
Stack Overflow

Questions tagged [js-xlsx]

JavaScript Spreadsheet Parser and Writer

Parser and writer for various spreadsheet formats. Pure-JS cleanroom implementation from official specifications, related documents, and test files. Emphasis on parsing and writing robustness, cross-format feature compatibility with a unified JS representation, and ES3/ES5 browser compatibility back to IE6.

Resources

137 questions
0
votes
1 answer

How to format date (in msdate format) from EXCEL in Angular

I'm currently working and learning Angular. The current project I'm working on requires me to display the content of an excel file. I found this code very useful and informative. It helped me a lot with my current…
user3604379
  • 43
  • 2
  • 6
0
votes
1 answer

Can't read cell values of XLSX generated using SheetJs

I wrote a JS code where I imported SheetJS and js-xlsx to perform actions on XLSX files (I can't use nodeJs nor npm, bower or any other solution that requires any installation on final user computer). Shortly, the code has to do the following: gets…
Agricolo
  • 65
  • 1
  • 12
0
votes
1 answer

Can we integrate XLSX and Syncfusion Library with LWC

We have some custom requirement to export our data into excel with custom and conditional cell styling. We have explored two libraries (xlsxjs and syncfusion) and would like to know whether it is compatible with salesforce Lightning Web…
anish samant
  • 183
  • 1
  • 4
  • 13
0
votes
1 answer

Value returned from service not being transferred to component

I have an Angular service to Parse Excel Files which looks something like this: import { Injectable } from '@angular/core'; import { ActivatedRoute } from '@angular/router'; import * as XLSX from 'xlsx'; type AOA = any[][] @Injectable({ …
Banani720
  • 159
  • 3
  • 17
0
votes
1 answer

SheetJS not exporting complete decimal values

I am trying to export json data to csv file using SheetJS. The json is like this: [ {col1: item1, col2: 1462.47907042}, {col1: item2, col2: 3327.28233473} ] And the function to export is the following: public exportToCSV(json: any[],…
iPhoneJavaDev
  • 821
  • 5
  • 33
  • 78
0
votes
2 answers

unable to read empty cells in excel file to 2d array

The code is working fine except where the cells are empty, the empty cells are ignored. I know there are solution 1 .Condition "if(h===undefined)continue;" in "xlsx.core.min.js" comment it out. Solution 2 . By passing Condition extra param while…
Peishi Long
  • 69
  • 1
  • 4
  • 9
0
votes
1 answer

js xlsx readFile offsets columns with no reason

I have a strange behavior when reading an excel file. When I open the file and save it with my version of Excel, the file is properly read with xlsx. However, when I do not touch it and read it with xlsx, some formulas are offseted. Here is an…
StaP
  • 107
  • 3
  • 13
0
votes
1 answer

onClick not invoked when clicking on sidebar

In my main container the layout has this code import React, { Component } from 'react'; import Header from '../../components/Navigation/Header/Header'; import SideBar from '../../components/Navigation/SideBar/SideBar'; class Layout extends…
Lamis Abouzina
  • 369
  • 1
  • 3
  • 16
0
votes
1 answer

Parse XLSX into JSON

I am trying to parse Excel content into JSON using the xlsx npm module, however it doesn't return any content. Why don't I find anything inside workbook.Sheets? Example: var workbook = XLSX.readFile(req.body.content+'.xlsx'); var sheet_name_list =…
Gokul Kathirvel
  • 23
  • 1
  • 8
0
votes
2 answers

Trying to use external node library with Dojo

I'm using dojo for client-side development. The project as a whole is built on Node, but for the front-end I am incorporating the use of Dojo. I'm relatively new to using dojo but I've managed so far to create my own custom widgets and display them…
nviens
  • 427
  • 2
  • 4
  • 18
0
votes
1 answer

SheetJS and FileSaver (vuejs project): running out of memory

I am working on the following problem: I want to download an .xlsx file (on click) using SheetJS to create the workbook and FileSaver to save the file. The problem I encounter is, that when exceeding about 100k rows, the file cannot be written. Code…
Shushiro
  • 577
  • 1
  • 9
  • 32
0
votes
0 answers

How to Access directive data from a controller from a seperate file

Access directive data from a controller from a separate file. Wanted to access the data from SheetJSImportDirective which is the $scope.$apply function that contains $scope.opts.data. The $scope.opts.data is the data I wanted to access the…
user11327631
0
votes
0 answers

Angular: Importing dates with different time zones from Excel

I am using https://github.com/SheetJS/js-xlsx/ with Angular 7 to import excel file and do some processing before I send it over to the server. My function for reading Excel data is: private readFile(file: any, dataType: string) { let fileReader:…
banana
  • 117
  • 3
  • 13
0
votes
1 answer

Get merged cell value in every JSON object

I have an excel file that looks like this: As you can see, there are some merged cells. I've been using js-xlsx to convert the data to JSON objects in my application. Here is the code: onFileLoad(loadedEvent: any) { let data = new…
Jesper
  • 2,644
  • 4
  • 30
  • 65
0
votes
1 answer

Getting error for xlsx-style after entering command 'yarn start'

i imported xlsx-style package to style my xlsx stylesheet,then i did 'yarn start'.after that i got error here am attaching error Error: Webpack: Finished after 84.273 seconds. ERROR Failed to compile with 3 errors …
StackUser
  • 418
  • 2
  • 7
  • 23
1 2 3
…
9 10