Comments (5)
Please provide the xlsx file.
from npoi.
here are the file
合约台账 - 副本.xlsx
from npoi.
In styles.xml, there are two tableStyle with same name 'TableStylePreset3_Accent1'. There is nothing wrong with NPOI exception. Please double check your file.
<tableStyles count="3" defaultTableStyle="TableStylePreset3_Accent1" defaultPivotStyle="PivotStylePreset2_Accent1">
<tableStyle name="TableStylePreset3_Accent1" pivot="0" count="7" xr9:uid="{59DB682C-5494-4EDE-A608-00C9E5F0F923}">
<tableStyleElement type="wholeTable" dxfId="6"/>
<tableStyleElement type="headerRow" dxfId="5"/>
<tableStyleElement type="totalRow" dxfId="4"/>
<tableStyleElement type="firstColumn" dxfId="3"/>
<tableStyleElement type="lastColumn" dxfId="2"/>
<tableStyleElement type="firstRowStripe" dxfId="1"/>
<tableStyleElement type="firstColumnStripe" dxfId="0"/>
</tableStyle>
<tableStyle name="TableStylePreset3_Accent1" pivot="0" table="0" count="7" xr9:uid="{709FE4E6-EA37-494D-900A-CBBD63CA84A4}">
<tableStyleElement type="wholeTable" dxfId="6"/>
<tableStyleElement type="headerRow" dxfId="5"/>
<tableStyleElement type="totalRow" dxfId="4"/>
<tableStyleElement type="firstColumn" dxfId="3"/>
<tableStyleElement type="lastColumn" dxfId="2"/>
<tableStyleElement type="firstRowStripe" dxfId="1"/>
<tableStyleElement type="firstColumnStripe" dxfId="0"/>
</tableStyle>
<tableStyle name="PivotStylePreset2_Accent1" table="0" count="10" xr9:uid="{267968C8-6FFD-4C36-ACC1-9EA1FD1885CA}">
<tableStyleElement type="headerRow" dxfId="22"/>
<tableStyleElement type="totalRow" dxfId="21"/>
<tableStyleElement type="firstRowStripe" dxfId="20"/>
<tableStyleElement type="firstColumnStripe" dxfId="19"/>
<tableStyleElement type="firstSubtotalRow" dxfId="18"/>
<tableStyleElement type="secondSubtotalRow" dxfId="17"/>
<tableStyleElement type="firstRowSubheading" dxfId="16"/>
<tableStyleElement type="secondRowSubheading" dxfId="15"/>
<tableStyleElement type="pageFieldLabels" dxfId="14"/>
<tableStyleElement type="pageFieldValues" dxfId="13"/>
</tableStyle>
</tableStyles>
from npoi.
I modified the style.xml of the file, and the code runs normally. However, when I open the xlsx file, nothing is done. After clicking Save, this error will appear again when executing NPOI.
from npoi.
It's very strange, so I mentioned it at the beginning, to open a worksheet, do nothing, just click save, and then close. An error will be reported when executing npoi code
from npoi.
Related Issues (20)
- Formula openxml gets corrupted after opened and saved by NPOI 2.7.0 HOT 12
- Excel file is always modified even if only opened for reading HOT 1
- Can't copy sheet's chart when using sheet copy function HOT 1
- System.Runtime.CompilerServices.Unsafe 4.0.41 not found while calling AsSpan HOT 13
- TypeLoadException: “NPOI.XSSF.UserModel.XSSFSheet.RemoveDataValidation” hasn't been implemented in “NPOI.OOXML, Version=2.7.0.0," HOT 1
- Add API for SearchText for xlsx,xls HOT 4
- Reading large files HOT 3
- AVERAGEIF formula doesn't work in xls HOT 7
- Cells with Formulas Display as Blank HOT 3
- XWPF POI Bug Migration II
- How can set picture properties on "Move and size with cells" HOT 2
- XSSFSheet.CopySheet doesn't support cloning charts
- The npoi package conflicts with the Magicodes.IE package HOT 2
- 'Object reference not set to an instance of an object' in XSSFCell.ToString() HOT 4
- npoi will inexplicably digitize some cells with formulas HOT 5
- excel file damaged after adding images and saving
- Unable to rotate image manually in DOCX
- Looking for a new job in Asia
- "Do you want us to try to recover as much as we can?" error message when opnening file when using 2.7.0 version HOT 1
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 npoi.