Magicodes.IE icon indicating copy to clipboard operation
Magicodes.IE copied to clipboard

导出设置ExporterHeader的宽度没有效果

Open hangyejiadao opened this issue 1 year ago • 1 comments

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 avatar Jan 25 '24 01:01 hangyejiadao

@hangyejiadao 得把自适应去掉把。 AutoFitAllColumn = true 改为false

Farb avatar Jan 25 '24 03:01 Farb