Comments (7)
@NikiSunshine , I wrote a demo, it is ok. Could you supply more details.
const xlsx = require('node-xlsx').default;
// Parse a file
const data = xlsx.parse('./examples/complex.xlsx');
console.log(JSON.stringify(data, null, ' '));
/*
[
{
"name": "Sheet1",
"data": [
[
"Category",
"Budget",
"Actual",
"Difference"
],
[
"Auto",
"$200.00",
"$90.00",
"$110.00"
],
[
"Entertainment",
"$200.00",
"$32.00",
"$168.00"
],
[
"Food",
"$350.00",
"$205.75",
"$144.25"
],
[
"Home",
"$300.00",
"$250.00",
"$50.00"
],
[
"Medical",
"$100.00",
"$35.00",
"$65.00"
],
[
"Personal Items",
"$300.00",
"$80.00",
"$220.00"
],
[
"Travel",
"$500.00",
"$350.00",
"$150.00"
],
[
"Utilities",
"$200.00",
"$100.00",
"$100.00"
],
[
"Other",
"$50.00",
"$60.00",
"($10.00)"
],
[
"Total",
"$2,200.00",
"$1,202.75",
"$997.25"
]
]
}
]
*/
from better-xlsx.
I used the same method as you did. But the file be exported to be read again still has a sheet less.
from better-xlsx.
I tested three excel which was exported by better-xlsx. Same issue
from better-xlsx.
The workbook has more than one sheet. And when I delete other sheets to leave the first one. The first one can be read.Or, it can't be read, I can only get the data from the second one on.
from better-xlsx.
@NikiSunshine , it is bug of js-xlsx
see: SheetJS/sheetjs#445
from better-xlsx.
But whatever js-xlsx, node-xlsx, and so on . It has the same question.
from better-xlsx.
@NikiSunshine , node-xlsx
dependent on js-xlsx
.
from better-xlsx.
Related Issues (20)
- An in-range update of rimraf is breaking the build 🚨 HOT 1
- An in-range update of rollup is breaking the build 🚨 HOT 42
- An in-range update of coveralls is breaking the build 🚨 HOT 4
- An in-range update of mocha is breaking the build 🚨 HOT 2
- An in-range update of babel7 is breaking the build 🚨 HOT 3
- An in-range update of uglify-js is breaking the build 🚨 HOT 3
- An in-range update of nyc is breaking the build 🚨 HOT 1
- 合并单元格后边框样式丢失 HOT 2
- 单元格合并问题
- saveAs craco构建后失效
- Freeze and UnFreeze Row Feature HOT 1
- An in-range update of babel7 is breaking the build 🚨
- An in-range update of rollup is breaking the build 🚨 HOT 2
- 使用 webpack minimize 后,导出的 excel 损坏 HOT 3
- An in-range update of rollup is breaking the build 🚨 HOT 82
- An in-range update of babel-plugin-add-module-exports is breaking the build 🚨 HOT 2
- An in-range update of eslint-plugin-import is breaking the build 🚨 HOT 8
- get image
- An in-range update of babel7 is breaking the build 🚨 HOT 42
- An in-range update of uglify-js is breaking the build 🚨 HOT 13
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from better-xlsx.