Comments (4)
@bleehome 这个视频的意思就是这样设置就会100多万的单元格也设置了数据有效性验证?
from excelize.
Found this due to the data validation in the excel file has Q13:Q1048576 H13:H1048576 these so large range of validation, resulting in exceljs to read too much range, and then generate too many dataValidation objects, there are millions, stuck. Then the program just keeps stopping there.
Now is thinking how can I reproduce the problem and what to do when I encounter this problem?
from excelize.
Screen.Recording.2023-07-04.at.17.39.05.mov
from excelize.
@bleehome 我在V4.4.6版本加入了读取excel的时候加入忽略节点参数(ignoreNodes)可以暂时解决这个问题,通过忽略数据有效性节点来处理,具体使用可以看这里 https://github.com/zurmokeeper/excelize/releases/tag/4.4.6,不过这个只是治标的方法,治本的还得再想想。
from excelize.
Related Issues (20)
- [BUG] Dropdown Excel js there is limitation of accepting 255 characters and beyond that throws error HOT 1
- 三级表头 Cannot merge already merged cells [BUG] XYZ HOT 2
- 我想读取单元格背景颜色值 HOT 5
- [Q] column each cell issue HOT 1
- [F] Add removeNote method HOT 1
- [F] Add file encryption function
- [F] Basic shape support added
- [F] New xlsx option for ignoring certain nodes for improved performance HOT 1
- [Q] xlsx.load(buffer) 时卡住,cpu 100% HOT 7
- [BUG] fix xlsx parser can not compatible with rich text tags that are not closed HOT 1
- Respecting Original Contributions: An Appeal to Retain Git History HOT 1
- Does it support "xls" file parsing?
- Does it support "xls" file parsing? HOT 1
- Cannot Open Encrypted Files HOT 5
- Does it support using in React to parse encrypted Excel (office, wps) HOT 13
- [BUG] Internal hyperlink does not work on wps office HOT 3
- [F] Add pivot table func
- [F] Add expression support for x14:cfRule
- [F] Release large values early for GC to be able to do its job
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 excelize.