Stack Overflow
Stack Overflow

Questions tagged [sheetjs]

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

184 questions
2
votes
0 answers

add headers in columns in react native table using SheetJS js-xlsx

I have convertd and write the xlsx file of my table data. I have used react-native-table component library to create table and use SheetJS js-xlsx library for convert and write the file in xlsx format. I have write the file but i am unable to…
vjtechno
  • 55
  • 3
2
votes
0 answers

Decoding named ranges as Tables from excel files in JavaScript, React

I was working on a project which is dealing with excel manipulation and creating JSON(s) based on the data getting from excel. There is a number of named ranges in excel (Including named ranges as tables as well as by specifying the range). We are…
Abin Thaha
  • 1,566
  • 8
  • 22
2
votes
1 answer

Sheetjs - Sheet add Json ignores date format

I have a JSON that contains some data and I want to export it to Excel. Problem is that I can not achieve the correct date format when saved to Excel. The date format that I want to achieve is something like that 2020-07-30 07:31:45 I followed the…
Stamatis Tiniakos
  • 324
  • 4
  • 19
2
votes
1 answer

How can I save the result in a variable correctly? XLSX Angular

I'm tring to read an excel file from an input with Angular and transform that file's data in an array of objects. My components are like this: import * as XLSX from 'xlsx'; import { Injectable } from '@angular/core'; @Injectable({ providedIn:'root'…
DavidDeveloperRandom
  • 21
  • 1
2
votes
2 answers

Achieving nested header structure while writing excel using SheetJS/ExcelJS

I want to achieve the below shown nested structure while writing the excel file in nodeJS application. I am not able to comprehend how to proceed. Is there a way to define multilevel headers or any JSON is possible using which I can achieve this…
Akshansh Pandey
  • 53
  • 9
2
votes
1 answer

Get row count of excel sheet in nodejs

I have an excel which has multiple sheet. Now I want to get row count for each sheet var XLSX = require('xlsx'); var workbook = XLSX.readFile('test.xlsx'); var sheet_name_list = workbook.SheetNames; let count = []; for (var…
Akhilesh
  • 35
  • 5
2
votes
1 answer

electron sheetjs download generated file from JSON

I have an Electron app with VueJS and I try to download a generated XLS with sheetjs but the provided workaround does not work in my case. Here is what I have been trying: exportData(id, type) { // eslint-disable-next-line no-console …
fefe
  • 7,517
  • 20
  • 83
  • 158
2
votes
2 answers

sheetJs - no output for empty cell

I am using sheetjs. The empty cell is not getting populated in the json object including the header. I need that information also if a column is not entered. Here is my code: workbook.SheetNames.forEach((sheetName) => { let XL_row_object =…
Padma
  • 21
  • 1
2
votes
0 answers

I need to put my excel headers in bold using javascript (SheetJS)

I need to put in bold my excel headers using SheetJS The problem is easy but I couldnt find the solution. With the next code I do an export from an HTML table to Excel. This export is perfect (no problems with this), but I need to have the headers…
AnselVP
  • 27
  • 2
2
votes
1 answer

Angular to Excel

I'm trying to export some JSON data from my Angular to Excel. I already did it successfully. My problem is how would i include the headings to the excel also? I can only export the table but not the headings? Please see the link and codes…
Joseph
  • 4,309
  • 11
  • 37
  • 87
2
votes
1 answer

While exporting data to excel, date is changing according to timezone. How to avoid it?

When I try to export data to excel in angular, the date in database is in 'x' timezone and I'm exporting data from 'y' timezone. While data is getting exported to excel, date is in 'y' timezone. But i want to keep it same as date in database i.e,…
Vidya KS
  • 31
  • 3
2
votes
1 answer

How to set the width of the entire column based on the content when export .xlsx files with js-xlsx?

I want to set column width equal to maximum length of the content of that column when exporting .xlsx files with js-xlsx How to set cell width when export .xlsx files with js-xlsx I tried with above. let sheet = workBook.Sheets.Sheet1; let wscols =…
Kikit
  • 81
  • 2
  • 11
2
votes
0 answers

Convert .xlsx file with merged cells to JSON with SheetJS

I'm trying to read a .xlsx file with SheetJS and convert it into JSON. I'm able to read and convert a simple (without merged cells) .xlsx file to JSON, but I'm not getting it right with merged cells. The problem is that I have a .xlsx file with…
Doodle
  • 61
  • 1
  • 7
2
votes
0 answers

"Uncaught TypeError: XLSX.read is not a function" when using SheetJS

I have used SheetJS js-xlsx library to load data from xlsx file into Fiori grid view. App is working when I run it using the SAP Hana Web IDE. Then I have deployed app to the Hana Cockpit and Register the app in Fiori LaunchPad as follows: The…
user3652388
  • 29
  • 2
2
votes
1 answer

How to parse with column from excel to convert it to JSON

I have tried to display the json value from the table. But it creates the JSON from Excel (Which parse as an row) I would like to parse the excel data as an column wise. Please help on this. I am using angular to parse. Upload() { …
Idris
  • 281
  • 2
  • 6
  • 16
1 2
3
…
12 13