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

277 questions
4
votes
1 answer

SheetJS json_to_sheet is writing dates in ISO 8601 as strings

I'm using the SheetJS library to export data in my angular material datatable to excel. Everything is working fine except for the dates, which are not being formatted or detected as dates by excel. I have JSON data like this: { "id": 21658, …
Ernesto G
  • 525
  • 6
  • 20
4
votes
3 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
  • 41
  • 1
  • 2
4
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
  • 47
  • 1
  • 3
4
votes
1 answer

SheetJs converting date automatically angular 7

I'm using sheetjs in angular 7. And I'm exporting excel from my json. But excel converting my date to 02/29/2019 format. But, I'm sending "29.02.2019". I'm sending as string, excel still converting. I also send "29.02.2019." by adding "." character…
realist
  • 2,155
  • 12
  • 38
  • 77
4
votes
2 answers

SheetJS library treats text as date incorrectly

There is a CSV file, which I try to read and it contains field with value "Aprobil P 0.1%" the short example of CSV: "Country";"Product Family" "Germany";"Aprobil P 0.1%" conversion to workbook is the following: var workbook = XLSX.read(csvData,…
Paul Z.
  • 153
  • 1
  • 7
4
votes
3 answers

SheetJS, Repaired Records: Worksheet properties from /xl/workbook.xml part (Workbook)

I use SheetJS to export data to excel and looks like excel itself repair data. Data download good, but is it ok to receive this warning? I've got and file.xlsx from UI, and when I open it via excel I received some warning was produced by Excel…
Palaniichuk Dmytro
  • 2,943
  • 12
  • 36
  • 66
3
votes
0 answers

Sheetjs (xlsx) is not reading all styles from an xlsx file

I have an issue where inside of my xlsx file I have applied styles like this: But inside of my object where I read the content from an xlsx file I only see this inside of my styles object: [ { "patternType": "solid", …
ahmedskulj10
  • 381
  • 1
  • 15
3
votes
1 answer

Start writing data to excel in some position SheetJS

I don't know how to properly pose my question but I have code that takes HTML table data and puts it to excel but it starts it at position A1 and let's say I want to start at C3. And being here can I import some xlsx with styling make a copy of it…
stud1234
  • 65
  • 7
3
votes
0 answers

How export all records from gird using xlsx. Now I can see the only top 100 row in xlsx file

I have implemented like This. The grid has multiple pages, and after exporting the file in xlsx format, the file contained only the first page data. so how can I download all rows? can you please help me here? const InvestigationTable1 =…
Ketan
  • 31
  • 1
3
votes
0 answers

View Direction dont change to rtl in XLSX-Style

I want to export a rtl direction xlsx file using XLSX-Style According to official documents I use below code to change view direction to rtl if (!wb.Workbook) wb.Workbook = {}; if (!wb.Workbook.Views) wb.Workbook.Views = []; if…
Mohammad didehvar
  • 90
  • 6
3
votes
1 answer

SheetJS: transpose row values from array to object

I am trying to create an array, where each "Working Day" is an object with an index and start/end date but I have no clue how to manipulate the JSON to have a specific structure. I am using the following package:…
mrks
  • 5,439
  • 11
  • 52
  • 74
3
votes
0 answers

SheetJS sum adjacent columns by range

I'm trying to add the values of two adjacent columns using SheetJS. The resulting sheet needs to contain the formula. From an Excel perspective A1 = B1 + C1 A2 = B2 + C2 A3 = B3 + C3 ... and so on I get the desired result using the approach…
Fisk
  • 227
  • 1
  • 12
3
votes
1 answer

SheetJs Convert workbook back to arraybuffer

I am new to SheetJs. We have this remote excel file within our internal platform which can be accessed only using API. I have to read this Excel file and update the excel contents and upload the excel file changes back using the API. The internal…
AnonymousCoder
  • 582
  • 2
  • 5
  • 18
3
votes
1 answer

How to set calculation mode of an xlsx file via Javascript?

I have a small code that imports an Excel workbook (xlsx) file, edits a cell value and finally saves the workbook in a different file. The problem with my code is that: in the new xlsx, auto-calculation is not set. I have to manually open the file…
Agricolo
  • 65
  • 1
  • 12
3
votes
3 answers

Cannot find module 'xlsx'

Am getting this while making build using jenkins on build server but i am trying this on local machine then it working fine with error 15:07:39 "", 15:07:39 "", 15:07:39 "ERROR in src/services/excel.service.ts:2:23 - error TS2307: Cannot find module…
harkesh kumar
  • 833
  • 2
  • 13
  • 35
1 2
3
…
18 19