Comments (8)
把你的代码贴上来看看
from magicodes.ie.
[ExcelExporter]
class LongToStr
{
[ExporterHeader("Long",format:"@")]
public long Long { get; set; }
[ExporterHeader("String")]
public String Str => Long.ToString();
}
List<LongToStr> list = new List<LongToStr>();
for (long i = 9223372036854775797L; i > 9223372036854775787L; i--)
{
list.Add(new LongToStr(){Long = i});
}
ExcelExporter exporter = new ExcelExporter();
exporter.Export("test.xlsx", list);
我希望能让数字显示成字符串 = =。有什么方法吗?
from magicodes.ie.
#,##0
from magicodes.ie.
[ExporterHeader(DisplayName = "长数值", Format = "#,##0")]
from magicodes.ie.
[ExporterHeader(DisplayName = "长数值", Format = "#,##0")]
###0
#0
#
0
Long | String |
---|---|
9223372036854780000 | 9223372036854775797 |
9223372036854780000 | 9223372036854775796 |
9223372036854780000 | 9223372036854775795 |
from magicodes.ie.
如果暂不支持的话 将来能不能在 Attr 里面加个 type 什么的 让字段当字符串 处理
from magicodes.ie.
等我有空测试一下。
可以考虑。
from magicodes.ie.
设置为“#”是OK的,但是如果数值过长的话,在写入的时候已经存在数据丢失,因此无论你如何设置格式,都是不对的。哪怕再将其转为文本类型。
基于以上情形,建议如下:
- 将DTO长数值列设置为string类型
- 然后使用Select将你的原始List做一个转换再进行导出
后续可以考虑通过特性处理,或者提供数据筛选器。
from magicodes.ie.
Related Issues (20)
- 【建议功能】图片导出可以直接嵌入到单元格,否则数据做筛选排序时候图片不能正确排序
- imagesharp 可以升级到3.0版本吗 HOT 1
- 动态多Sheet导入 HOT 1
- excel固定模版导出使用SixLabors.ImageSharp 3.0版本报错 HOT 1
- 存在有excel文件读取workbook的时候获取不同步的问题 HOT 1
- 我想验证导入的数据,某列验证数据类型decimal,需要怎么搞
- wps 编辑后execl导入报错 The given key 'rId1' was not present in the dictionary HOT 3
- 调用 ExportByTemplate<T>(path, output, tplPath)的时候出错 HOT 4
- 如何对ExporterAttribute特性做全局设置? HOT 1
- 目前不支持交叉表导出吗?
- magicodes.ie.excel.aspnetcore 2.7.4.5在WindowServier 2012R2下运行The type initializer for 'SkiaSharp.SKFontStyle' threw an exception. HOT 6
- 空指针异常
- 导出设置ExporterHeader的宽度没有效果 HOT 1
- Magicodes.IE.Pdf无法读取本地文件(图片) HOT 1
- Linux Dcoker构建 .NET8 按HTML模版导出PDF 报错找不到libjpeg62,同样的环境.NET7打包运行后导出PDF就正常 HOT 2
- 一个项目用Magicodes.IE跟NPOI HOT 3
- windows service部署导出word异常
- 同一个数据源,Linux 下面速度慢30s没有导出,windows下5s就导出来了。
- Magicodes.IE 和npoi冲突
- Pls remove throw new ArgumentException("Tablename has spaces") at ExcelTableCollection.ValidateTableName,xlsx is allowed worksheet name Contains empty
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 magicodes.ie.