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

Wijmo ExcelImportExport in Angular 2 project 'window.require is not a function' error

I'm using the current build of Wijmo (5.20172.359) in an Angular 2 project (Angular 4.4.4, TypeScript 2.5.3). Everything I've been using (FlexGrid, FlexPie, FlexCharts) works fine, however... I'm trying to integrate the Excel Import functionality,…
Stephen R. Smith
  • 3,310
  • 1
  • 25
  • 41
0
votes
1 answer

How to Upload an Excel File in SAPUI5?

so I have this app where I upload a csv file using FileUploader. However now my requirement is to also allow excel files. The problem is that FileUploader doesn't support excel as it reads garbage. This is my attempt at parsing an excel file based…
polaris
  • 339
  • 2
  • 14
  • 33
0
votes
0 answers

Unable to access XLSX object when using js-xlsx library

So I'm trying to read an Excel file (.xlsx specifically) using the js-xlsx library shown here. I must have messed up somewhere with the installation, though, because I can't get access to the "XLSX" object that is necessary to do anything with the…
anon
  • 35
  • 5
0
votes
1 answer

Error with iterator in for loop in java script(With onload function in filereader)

The code : var workbook = XLSX.read(data, {type: 'binary'}); var first_sheet_name = workbook.SheetNames[0]; var worksheet = workbook.Sheets[first_sheet_name]; var k=1 var desired_cell = worksheet['A'+k].w; The above code runs…
user7850444
0
votes
0 answers

How to use npm XLSX in meteor to read a .xlsx file on client side?

I have to extract and read contents of an .xlsx file on browser using javascript framework meteor but I am unable to do it with npm XLSX modules.Can you please provide me a snippet to do it? Also I don't need to read text or csv file reading…
0
votes
1 answer

How to load XLS file into javascript using js-xls

I have a input type=file and I'm trying to have js-xls load it. Here are three different ways I've tried to load the file in my controller: var workbook =…
Greg
  • 45,306
  • 89
  • 231
  • 297
0
votes
1 answer

Workbook is not defined in js-xlsx

I use Js-xlsx API to export data into .xlsx file.I have tried to write a sample code using AngularJs and i couldn't achieve it.It throws Workbook is not defined.I refer the wiki but i couldn't find it.Please help me anyone knows how to write to a…
gihan-maduranga
  • 4,381
  • 5
  • 41
  • 74
0
votes
1 answer

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 AngularJS 1.x app is cannot findable no documents…
0
votes
1 answer

Write XLSX file with comments using js-xlsx

Is it possible to insert some cell comments when we write a XLSX file with js-xlsx ? When I read a file containing some cell comments, they appear when I read the file: > var wb = XLSX.readFile("Book1comments.xlsx") …
Stéphane Laurent
  • 75,186
  • 15
  • 119
  • 225
0
votes
2 answers

Gulp/NodeJS: Require('fs') fails on Ubuntu, but works on Windows

I've inherited a project that does its build using NodeJS. Everything's been working fine for us for months. We've built a number of production releases with no problem. Enter xlsx.js. Since adding this package as a dependency, we've found that our…
Jeffrey Getzin
  • 531
  • 1
  • 6
  • 11
0
votes
1 answer

Need to Export tabular data into Excel (xlsx) format by javascript

I want to export my data (which reside on the Page) into excel (xlsx) format. I have gone through couple of available libraries but none of them actually worked or helped me to achieve my requirement. Below are the required things which I want to do…
user2809299
  • 149
  • 2
  • 13
0
votes
0 answers

how to convert the excel below to json

I want to convert excel to json like below.I want to use js-xlsx,but i don't know how to implement it {"OrderNo":"120555", "Order Date":"20160218", "Courier Bill NO":"120555", "orderShipperName":"INLAY SHOES…
xiami0980
  • 1
  • 1
0
votes
1 answer

When using XLSX to parse excelsheet - it is throwing _fs is undefined

I am trying to use the XLSX library to read data from excelsheet but I am getting this:- ERROR: _fs is undefined at xlsx.js (line 11388, col 59) Here is my code :- Read Excel
0
votes
3 answers

XMLHttpRequest: Access object created in oReq.onload

I am using an XMLHttpRequest and sheetjs (https://github.com/SheetJS/js-xlsx) to create a json object from an excel spreadsheet. All is working well except I am struggling to access the created object outside of oReq.onload. After creating the json…
linesd
  • 31
  • 9
0
votes
1 answer

UI-Grid more than one field per column

I need to import an Excel sheet to UI-Grid using JS-XLS in the same column where I retrieve data from database. For example, one of the columns is defined as: { field: 'employee_id', displayName: 'ID', width: "*"} From the sheet, the column I…
Radec
  • 65
  • 9
1 2 3
9
10