d-band / better-xlsx Goto Github PK
View Code? Open in Web Editor NEWA better xlsx library.
Home Page: https://d-band.github.io/better-xlsx/
A better xlsx library.
Home Page: https://d-band.github.io/better-xlsx/
"@craco/craco": "^7.0.0",
"better-xlsx": "^0.7.6",
jszip的版本过低会导致saveAs api 失效且Promise丢失,没有异常报错信息
我将jszip版本更新到3.9.0解决
建议升级jszip依赖版本
I tried this module and exported xlsx. But I tried to open file multiple different MS Office. Mac Office 2008 and few different Windows MS office. Only google docs sheet successfully opened.
I encountered some weird situation.
When I first write the buffer into file it show up the file size like 100MB.
But then it reduced to 15MB after I've open it at Excel and Save it without any modification.
And at the file preview (Mac OS) image, it show up some extra cell was created and store at the first few columns for every rows. It disappeared after the Save action.
Any idea of this?
关掉 minimize 功能后正常,开启 minimize 后 excel 就提示损坏了,但代码能正常运行。
下面是两个 excel 的对比
报表2018年11月28日(3).xlsx
报表2018年11月28日(4).xlsx
devDependency
@babel/cli was updated from 7.4.4
to 7.5.0
.devDependency
@babel/core was updated from 7.4.5
to 7.5.0
.devDependency
@babel/plugin-proposal-class-properties was updated from 7.4.4
to 7.5.0
.devDependency
@babel/plugin-transform-runtime was updated from 7.4.4
to 7.5.0
.devDependency
@babel/preset-env was updated from 7.4.5
to 7.5.0
.dependency
@babel/runtime was updated from 7.4.5
to 7.5.0
.This version is covered by your current version range and after updating it in your project the build failed.
This monorepo update includes releases of one or more dependencies which all belong to the babel7 group definition.
babel7 is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
Branch | Build failing 🚨 |
---|---|
Dependency | kind-of |
Current Version | 3.2.0 |
Type | dependency |
This version is covered by your current version range and after updating it in your project the build failed.
kind-of is a direct dependency of this project this is very likely breaking your project right now. If other packages depend on you it’s very likely also breaking them.
I recommend you give this issue a very high priority. I’m sure you can resolve this 💪
There is a collection of frequently asked questions and of course you may always ask my humans.
Your Greenkeeper Bot 🌴
I had a couple of issues with this library while using create-react-app, which invokes uglify for minification as a plugin for webpack (browser-only use). First, it refuses to compile with uglify's minification turned on, referring to the following URL:
this can be remedied by importing the precompiled version in dist/ into my react app instead of importing the library's root dir as i do with the other npm libs i use.
However, even after resolving this minor issue, create-react-app's uglify settings break the code that generates XML nodes, causing them to generate empty node names in the rendered xml files and the excel file to register as corrupted. This happens whether I import the precompiled version or copy the library's source files into my react app and import them from there. I'm unsure what is different between the use of uglify that builds the distribution files and the use of uglify in create-react-app but it would be lovely if this lib would work out of the box with create-react-app.
在npm run build 的过程中会报 Failed to minify the code from this file: node.js:32 的错误
☝️ Important announcement: Greenkeeper will be saying goodbye 👋 and passing the torch to Snyk on June 3rd, 2020! Find out how to migrate to Snyk and more at greenkeeper.io
devDependency
@babel/core was updated from 7.9.0
to 7.9.6
.devDependency
@babel/plugin-transform-runtime was updated from 7.9.0
to 7.9.6
.devDependency
@babel/preset-env was updated from 7.9.5
to 7.9.6
.devDependency
@babel/register was updated from 7.8.6
to 7.9.0
.dependency
@babel/runtime was updated from 7.9.2
to 7.9.6
.This version is covered by your current version range and after updating it in your project the build failed.
This monorepo update includes releases of one or more dependencies which all belong to the babel7 group definition.
babel7 is a direct dependency of this project, and it is very likely causing it to break. If other packages depend on yours, this update is probably also breaking those in turn.
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
i want to set execel page margin, how to do this ?
3.6.3
to 3.6.4
.This version is covered by your current version range and after updating it in your project the build failed.
uglify-js is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
The new version differs by 11 commits.
370c8e0
v3.6.4
4240fba
fix corner cases in unused
(#3519)
267bc70
fix corner case in unused
(#3517)
a53ab99
fix corner case in side_effects
(#3514)
02308a7
fix corner case in reduce_vars
(#3510)
0b3705e
fix corner cases in inline
(#3507)
da5a21b
fix GitHub Actions script for fuzzing (#3504)
5bd0cf8
enable GitHub Actions (#3503)
9199ab5
minor tweaks (#3502)
ca6dce4
fix corner case in collapse_vars
(#3501)
543dd7d
fix corner case in comments
(#3500)
See the full diff
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
1.31.0
to 1.31.1
.This version is covered by your current version range and after updating it in your project the build failed.
rollup is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
2020-02-14
The new version differs by 6 commits.
6f28151
1.31.1
4ed7091
Update changelog
305363a
Run transform hooks again in watch mode on files that errored (#3388)
f3d3cd8
Update changelog
bc52fbb
Adjust bug template to mention REPL.it (#3371)
7c0417f
docs: correct spelling minifaction to minification (#3366)
See the full diff
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
🚨 Reminder! Less than one month left to migrate your repositories over to Snyk before Greenkeeper says goodbye on June 3rd! 💜 🚚💨 💚
Find out how to migrate to Snyk at greenkeeper.io
15.0.1
to 15.1.0
.This version is covered by your current version range and after updating it in your project the build failed.
nyc is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
The new version differs by 5 commits.
de7baa4
chore(release): 15.1.0
992359a
feat(experimental): Support using --all
with node.js ESM (#1320)
086fd20
chore: Regenerate package-lock, update source-map-support test (#1314)
b20f751
chore: add bugs
(used, e.g., by npmjs) (#1313)
6898e88
chore: Fix CHANGELOG.md version header
See the full diff
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
ie can not download
hi
how can i convert a html string into a xlsx and use other method from the library together?
can you put an example how to use html-to-xlsx with this library together ?
this tool is good , but I want use it in a typescript project, so Can you add a typescript definition for me and others who use typescipt?
☝️ Important announcement: Greenkeeper will be saying goodbye 👋 and passing the torch to Snyk on June 3rd, 2020! Find out how to migrate to Snyk and more at greenkeeper.io
3.0.11
to 3.0.12
.This version is covered by your current version range and after updating it in your project the build failed.
coveralls is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
how to get image from excel
1.0.0
to 1.0.1
.This version is covered by your current version range and after updating it in your project the build failed.
babel-plugin-add-module-exports is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
The new version differs by 5 commits.
38e2e68
v1.0.1
df47a0a
[patch] Add module.exports to files using es3 member literals
e8e5be0
docs: tweaks [ci skip]
d0001d5
docs(README): add webpack notes(refs #68) & tweaks [ci skip]
753d945
chore: tweak postversion
script [ci skip]
See the full diff
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
3.0.1
to 3.0.2
.This version is covered by your current version range and after updating it in your project the build failed.
rimraf is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
设置hMerge,vMergeh后 边框样式丢失了,应该如何处理?
0.67.1
to 0.67.2
.This version is covered by your current version range and after updating it in your project the build failed.
rollup is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
The new version differs by 3 commits.
fe92d1f
0.67.2
ed22964
Update changelog
dbd2e47
Fix crash when returning undefined sourcemaps from renderChunk hook (#2558)
See the full diff
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
目录的权限也试过设置为777
16.04虚拟机的浏览器打开后下载的文件拷贝出来也无法打开,同样的错误
环境:
chrome
webpack、vue
better-xlsx:0.3.3
ubuntu 14.04/16.04
apach2 /var/www/html目录与子目录均测试过
Hi, I have some questions to ask, sorry to disturb. I have used your file to export excel successfully , but when I read the excel , the first sheet can't be read , and there is no data, and the workbook's length is one less. If you have time , please write back to me. Thank you.
想合并单元格,但并不知道如何去操作
2.17.1
to 2.17.2
.This version is covered by your current version range and after updating it in your project the build failed.
eslint-plugin-import is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
The new version differs by 5 commits.
eddcfa9
Bump to v2.17.2
b151d04
[fix] no-unused-modules
: avoid crash when using ignoreExports
-option
3512563
[fix] no-unused-modules
: make sure that rule with no options will not fail
8e0c021
[Test] no-unused-modules
add failing test case
9b7a970
[meta] add npm run mocha
for easier unit testing
See the full diff
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
devDependency
@babel/cli was updated from 7.1.2
to 7.1.5
.devDependency
@babel/core was updated from 7.1.5
to 7.1.6
.devDependency
@babel/plugin-proposal-class-properties was updated from 7.0.0
to 7.1.0
.devDependency
@babel/plugin-proposal-decorators was updated from 7.1.2
to 7.1.6
.devDependency
@babel/plugin-transform-runtime was updated from 7.0.0
to 7.1.0
.devDependency
@babel/preset-env was updated from 7.1.5
to 7.1.6
.This version is covered by your current version range and after updating it in your project the build failed.
This monorepo update includes releases of one or more dependencies which all belong to the babel7 group definition.
babel7 is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
How can I enable word wrap for particular cells/rows/colums?
☝️ Important announcement: Greenkeeper will be saying goodbye 👋 and passing the torch to Snyk on June 3rd, 2020! Find out how to migrate to Snyk and more at greenkeeper.io
3.9.1
to 3.9.2
.This version is covered by your current version range and after updating it in your project the build failed.
uglify-js is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
The new version differs by 40 commits.
20f9a1d
v3.9.2
dcb74f5
fix diagnostic text (#3838)
0794aaa
fix corner case in inline
(#3837)
74801de
fix corner cases in inline
(#3834)
f80d5b8
enhance inline
(#3832)
d900006
fix corner case in dead_code
(#3831)
39f8495
update dependencies (#3828)
818738b
fix corner case in ie8
(#3826)
bc2a4a3
fix corner case in ie8
(#3824)
a4a8cce
fix corner case in inline
(#3822)
36dcfa3
improve suspicious option detection (#3820)
94f3357
fix corner case in --reduce-test
(#3819)
44d6912
improve --reduce-test
on Error.message
(#3816)
3a4497a
fix corner case in typeofs
(#3818)
3ee13ca
improve compress
(#3814)
There are 40 commits in total.
See the full diff
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
Branch | Build failing 🚨 |
---|---|
Dependency | eslint-plugin-import |
Current Version | 2.3.0 |
Type | devDependency |
This version is covered by your current version range and after updating it in your project the build failed.
As eslint-plugin-import is “only” a devDependency of this project it might not break production or downstream projects, but “only” your build or test tools – preventing new deploys or publishes.
I recommend you give this issue a high priority. I’m sure you can resolve this 💪
The new version differs by 10 commits.
44ca158
update utils changelog
a3728d7
bump eslint-module-utils to v2.1.0
3e29169
bump v2.4.0
ea9c92c
Merge pull request #737 from kevin940726/master
8f9b403
fix typos, enforce type of array of strings in allow option
95315e0
update CHANGELOG.md
28e1623
eslint-module-utils: filePath in parserOptions (#840)
2f690b4
update CI to build on Node 6+7 (#846)
7d41745
write doc, add two more tests
dedfb11
add allow glob for rule no-unassigned-import, fix #671
See the full diff
There is a collection of frequently asked questions and of course you may always ask my humans.
Your Greenkeeper Bot 🌴
TODO:
To see what happens to your code in Node.js 10, Greenkeeper has created a branch with the following changes:
.travis.yml
package.json
files, so that was left aloneIf you’re interested in upgrading this repo to Node.js 10, you can open a PR with these changes. Please note that this issue is just intended as a friendly reminder and the PR as a possible starting point for getting your code running on Node.js 10.
Greenkeeper has checked the engines
key in any package.json
file, the .nvmrc
file, and the .travis.yml
file, if present.
engines
was only updated if it defined a single version, not a range..nvmrc
was updated to Node.js 10.travis.yml
was only changed if there was a root-level node_js
that didn’t already include Node.js 10, such as node
or lts/*
. In this case, the new version was appended to the list. We didn’t touch job or matrix configurations because these tend to be quite specific and complex, and it’s difficult to infer what the intentions were.For many simpler .travis.yml
configurations, this PR should suffice as-is, but depending on what you’re doing it may require additional work or may not be applicable at all. We’re also aware that you may have good reasons to not update to Node.js 10, which is why this was sent as an issue and not a pull request. Feel free to delete it without comment, I’m a humble robot and won’t feel rejected 🤖
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
line 1439 in dist/xlsx.js this._xmlName = xmlName || this.constructor.name.substring(1);
for IE ,function.name is undefined....
npm run build会报如下错误,目前没发现影响xlsx文件的生成:
ERROR in static/js/4.d1e69b299f63ca1b9e52.js from UglifyJs
Unexpected character '`' [./~/better-xlsx/lib/lib.js:35,0][static/js/4.7a08c5e72fb9161e2056.js:1232,6]
我查看了lib.js文件,第35开始的代码如下
41: `_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)`,
42: `_("$"* #,##0_);_("$* (#,##0);_("$"* "-"_);_(@_)`,
43: `_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)`,
44: `_("$"* #,##0.00_);_("$"* (#,##0.00);_("$"* "-"??_);_(@_)`,
环境如下:
win7
better-xlsx 版本0.3.2
使用了vue 2.3.4, webpack
工程使用的是vue的webpack模版(vue init webpack demo)
1.9.2
to 1.9.3
.This version is covered by your current version range and after updating it in your project the build failed.
rollup is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
2019-04-10
The new version differs by 3 commits.
516a06d
1.9.3
a5526ea
Update changelog
c3d73ff
Handle out-of-order binding of identifiers to improve tree-shaking (#2803)
See the full diff
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
我发现现版本一个单元行只允许存在一个合并单元格,如果有两个合并单元格同时存在,则第二个会消失不见,我希望在未来的版本中能添加多合并单元格支持的功能,或者能提供一下类似状况的解决方法。
After testing by the project,I found that better-xlsx only support one merge cell in one row,the second merge cell will disappear.I hope multiple merge cell will be support in future.
生成的excel中的文件夹没有zip压缩,导致不能poi不能正常解析。
unexpected token punc 《}》,expected punc 《:》[./~/better-xlsx/lib/lib.js 176,30
Branch | Build failing 🚨 |
---|---|
Dependency | rollup-plugin-commonjs |
Current Version | 8.2.3 |
Type | devDependency |
This version is covered by your current version range and after updating it in your project the build failed.
rollup-plugin-commonjs is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
The new version differs by 8 commits.
903a8db
-> v8.2.4
4152aa9
Merge pull request #243 from otolab/feature/1408
e810757
update CHANGELOG
06e9122
code clean
b9191ae
fix for function/bare-import case
14bdcf2
add test for export 'default' warning
c6a0d0e
refactoring
f8db8ef
add esModulesWithoutDefaultExport check
See the full diff
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
☝️ Important announcement: Greenkeeper will be saying goodbye 👋 and passing the torch to Snyk on June 3rd, 2020! Find out how to migrate to Snyk and more at greenkeeper.io
7.1.1
to 7.1.2
.This version is covered by your current version range and after updating it in your project the build failed.
mocha is a devDependency of this project. It might not break your production code or affect downstream projects, but probably breaks your build or test tools, which may prevent deploying or publishing.
The new version differs by 7 commits.
27aeb80
Release v7.1.2
e3df026
update CHANGELOG for v7.1.2 [ci skip]
7f75489
add test case: type check before calling retriedTest()
e659027
type check before calling retriedTest()
eba6ec7
Remove Runnable#inspect() and utils.ngettext() (#4230)
a4a4d50
add wallaby logo to bottom of site
c600547
update mkdirp to v0.5.5 (#4222)
See the full diff
There is a collection of frequently asked questions. If those don’t help, you can always ask the humans behind Greenkeeper.
Your Greenkeeper Bot 🌴
是否可支持sheet页面的写保护
Given a cell of type datetime, how can I specify the format? Having looked at the source for cell.js, I tried hacking it by changing the format string in the lib.js numFmt[] object, but it doesn't produce the desired output.
It's not even clear if this is working as intended. The format string in numFmt[22] that's being applied (by html2xlsx) is "'m/d/yy h:mm'" but my output is of the form "dd/mm/yyyy hh:mm".
Implement Freeze Row at top while scrolling
Branch | Build failing 🚨 |
---|---|
Dependency | uglifyjs |
Current Version | 2.4.10 |
Type | devDependency |
This version is covered by your current version range and after updating it in your project the build failed.
As uglifyjs is “only” a devDependency of this project it might not break production or downstream projects, but “only” your build or test tools – preventing new deploys or publishes.
I recommend you give this issue a high priority. I’m sure you can resolve this 💪
There is a collection of frequently asked questions and of course you may always ask my humans.
Your Greenkeeper Bot 🌴
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.