sheetjs

sheetjs copied to clipboard

Some filenames causes EXCEL to report error

3

Hi, attached is the file that has thrown an error by EXCEL. The fileName is: `RiskThemes_ Bubble Chart.xlsx`. I tried exporting with a fileName of `test.xlsx` and it is fine,...

lemonbob

Column Formulas Cause Empty Rows When Importing

1

I am experiencing an issue when trying to read an xlsx file from user upload that contains column formulas that have an expression that inserts an empty string into a...

crazyjat

XLSX.write() taking too long

40

Hi, I have tried to write 3 columns and N number of rows, below we can see the time taken (on my i3 machine): N --------------- TIME (s) 10000 ---------------...

irfanyounas

How to read huge Excel file without load entire file in memory and append new rows?

6

I need to append new rows to a huge excel file. How to do it without to read the entiry file in the memory, which can potencially slowing down the...

aislanmaia

I am trying to set a border and background around a range of cells. .. something like this: var range = XLSX.utils.decode_range("A0:C1"); range.s = { fill: { patternType: "solid", fgColor:...

rchancey

I'm trying to get the rows based on my checkbox value.

VPMoreira

vue 项目中 解析带有拆分的xlsx文件 数据行数缺失问题

1

环境： node -v : v14.19.0 vue @2.6.14 如果xlsx文件中存在拆分，通过 antd vue 中的文件上传组件上传改文件，通过XLSX.utils.sheet_to_json 获取数据是缺少数据 观察WorkBook对象sheet对象的!ref值不对 请问怎么解决？

2621697236

SSF - format not supported

4

I have been using SSF in my project, and have run into this problem - when the format is "#,0" it seems to throw an error. That is a valid...

alonkh2

Read specific set of rows

5

I have used 'sheetRows' properties to read 'n' rows of a sheet but is it possible to read 'n' rows from 'k'the row. Eg. I want to read 100 rows...

ashwinpoosarla

Autocorrecting formats

3

See SheetJS/sheetjs#2551 for an example where `#,##.??` is corrected to `#,###.??` in Excel h/t @wilg for drawing attention to a format which triggered this behavior

SheetJSDev