ExcelMapper always generate extra columns #298

Activity

1. LJN-hzleaper commented on Mar 25, 2024

   

   LJN-hzleaper

   on Mar 25, 2024

   Author

   More actions

   I can remove these columns one by one from output by Ignore, but is there a batch way?

           ExcelMapper mapper = new();
           mapper.Ignore(typeof(Dto), nameof(Dto.Id));
           mapper.Ignore(typeof(Dto), nameof(Dto.Name));
           mapper.AddMapping(typeof(Dto), "Identity", nameof(Dto.Id));
           mapper.AddMapping(typeof(Dto), "User Name", nameof(Dto.Name))
               .ToExcelOnly();
           mapper.Save("E:/Test.xlsx", GetData(), "Hi");
   
2. mganss commented on Mar 25, 2024

   

   mganss

   on Mar 25, 2024

   Owner

   More actions

   You can remove all mappings like so:

   var typeMapper = mapper.TypeMapperFactory.Create(typeof(Dto));
   typeMapper.ColumnsByName.Clear();

   👍React with 👍1Reacted by hongyan