Comments (4)
@shaofing 谢谢👍
已更正说法
from miniexcel.
1 ,上面的demo写法不对 , flags 前面还有可选参数,如果不按照顺序写 ,参数得是 new CommandDefinition(sql, flags: CommandFlags.NoCache)
2,不能ToList() 。
3,使用CommandFlags.NoCache时,不能使用异步QueryAsync的方法,会报连接已经关闭的异常
var details = conn.Query<receipt_detail>(new CommandDefinition(sql, flags: CommandFlags.NoCache)); MiniExcel.SaveAs(fileName, details);
from miniexcel.
@shaofing 请问能帮忙PR吗?
from miniexcel.
from miniexcel.
Related Issues (20)
- OpenXml.SharedStringsDiskCache 析构函数导致的崩溃
- 希望 SaveAsByTemplate 可以指定模板里某一个 Sheet 进行数据填充 HOT 1
- Hope add support for update single cell in sheet
- 对于ExcelColumnAttribute的Index 属性,能否添加先排序 再填充?
- Query得到的结果会忽略掉空行,那么怎么知道真实的行号呢 HOT 1
- DynamicExcelColumn Configuration doesnt work for DataTable Objects
- Generating excel with datareader ignores DynamicExcelColumn "Ignore" property
- Query faild on specific xlsx file, throws ExcelColumnNotFoundException
- 怎么删除某一行呢? HOT 2
- C# 有现成的System.DateTime.FromOADate方法问什么不用,是有什么特殊处理吗? HOT 2
- DataTable和IDataReader 导出Excel的时候,ExcelColumnInfo没传递导致Format等属性无效(已有解决方案)
- dependency bug with `Portable.System.DateTimeOnly` HOT 1
- Merge async and not-async implementation HOT 6
- New benchmark
- Export image to custom template
- Increase support to Async Xlsx write
- SaveAsByTemplate uses too much memory
- Generate Excel Worksheet from HTML
- 增加Excel 文件加密,解密的功能
- 加密功能
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.