This is a .net6 developed openxml-based excel import, export component;
How to achieve import and export, you can download the code to open the solution, refer to the test code in the test project CommonLibraryCoreTests;
Support custom complex styles (such as: font, background color, font color, column width, row height, cell borders, merge cells, different styles within one cell, etc.), support multiple sheets, fast
这是一个.net standard 2.1开发的一些公共方法,如一些基本类型的转换,还有一个主要的功能是基于Openxml的excel导入,导出的组件;
怎么实现导入、导出,可以下载代码打开解决方案,参考测试项目CommonLibraryStandardTests里的测试代码;
支持自定义复杂的样式(如:字体,背景色,字体颜色,列宽,行高,单元格边框,合并单元格,一个单元格内不同的样式等等),支持多个sheet,速度快
- Refer to the test code in the test project CommonLibraryCoreTests
参考测试项目CommonLibraryStandardTests里的测试代码