Magicodes.IE
Magicodes.IE copied to clipboard
导出设置ExporterHeader的宽度没有效果
using Magicodes.ExporterAndImporter.Core;
using Magicodes.ExporterAndImporter.Excel;
namespace ConsoleApp1
{
internal class Program
{
static async Task Main(string[] args)
{
var _data = new List<Demo>()
{
new Demo(){ Id=1,Name="asddfasdfasdfasdfasdfasdfasdff"},
new Demo(){ Id=2,Name="asdfasdfasdfasdfasdfasdfasdfasdfasfasdfasdfasdfasdfasdfas"},
};
var _export = new ExcelExporter();
var _path = AppDomain.CurrentDomain.BaseDirectory + "/data1.xlsx";
var result = await _export.Export(_path, _data);
Console.WriteLine("Hello, World!");
}
}
[ExcelExporter(Name = "测试2", TableStyle = OfficeOpenXml.Table.TableStyles.None, AutoFitAllColumn = true, MaxRowNumberOnASheet = 100)]
public class Demo
{
[ExporterHeader(DisplayName = "Id", IsBold = true, Width = 3000)]
public int Id { get; set; }
[ExporterHeader(DisplayName = "加粗文本", WrapText=true, IsBold = true, Width = 2000)]
public string Name { get; set; }
}
}
@hangyejiadao 得把自适应去掉把。 AutoFitAllColumn = true 改为false