Comments (3)
我感觉库中要做到这个是很复杂的,要适应各种情况,你急着用的话,建议你 参考这个代码 自己解开zip往文件中插数据,其实还比较简单的。
sheet文件的路径在这里
像我的一个sheet文件的结尾部分长这样
<x:row r="18">
<x:c r="A18" t="str" s="2">
<x:v>uiLabelUserGroup.Text</x:v>
</x:c>
<x:c r="B18" s="2"></x:c>
<x:c r="C18" t="str" s="2">
<x:v>普通用户</x:v>
</x:c>
</x:row>
<x:row r="19">
<x:c r="A19" t="str" s="2">
<x:v>uiLabelUsername.Text</x:v>
</x:c>
<x:c r="B19" s="2"></x:c>
<x:c r="C19" t="str" s="2">
<x:v>name</x:v>
</x:c>
</x:row>
</x:sheetData>
<x:drawing r:id="drawing1" />
</x:worksheet>
你只要记录一下<x:row>
段的格式,然后自己生成每一行就好
from miniexcel.
这种xml标签可以在哪查阅相关文档吗?
xlsx其实是不是也是向文本文件输出XML内容?
如果是应该跟csv输出差不多吧,可能追加的时候要定位下标签对的position,再追加输出
from miniexcel.
我也是才开始用这个库,看源码才知道一丁点,你把xlsx文件后缀名改成zip,解压出来一看就能明白个大概了。
相比csv会复杂很多,但本质上也就是一堆xml文件
from miniexcel.
Related Issues (20)
- 通过SaveAsByTemplate生成文件时,提示参数计数不匹配
- Mapping to IEnumerable
- 请问如何将图片通过模板的方式导出excel文件 HOT 1
- DataTable数据不支持设定列宽 Column width
- 导出支持设置水印
- 使用Dictionary类型导出xlsx时,如果第一行数据缺少列,那么整个sheet都会缺少这一列 HOT 2
- xlsx create and read bug, xlsx文件的创建与读取bug HOT 3
- FillMergedCells开启,日期填充不正确 HOT 1
- Insert a new sheet into an existing workbook HOT 1
- Dapper Query 支持延迟加载,README.zh-CN.md 文件中的说法错误 HOT 4
- rowInfo.IEnumerableMercell.Height null exception HOT 1
- When reading a CSV file I want to map an empty string to null value
- MiniExcel所创建的xlsx文件无法与POI兼容
- Support asp.net 8.0 AOT properties
- Contributer Announcement/News HOT 1
- 固定格式和动态集合并存的excel模板格式
- Exception while reading nullable values in excel file HOT 3
- miniexcel is missing NuGet package README file
- 模板填充 Excel 的时候希望增加几个特殊标签 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 miniexcel.