donnytian / Npoi.Mapper

Use this tool to import or export data with Excel file. The tool is a convention based mapper between strong typed object and Excel data via NPOI.
MIT License
599 stars 115 forks source link

Put method with overwrite 'True' clears cell styling. #116

Closed markand911 closed 1 year ago

markand911 commented 1 year ago

I have an excel file, using it to populate data for users. The excel file has some cell styling like borders, cell alignments etc. I am using this lib to populate data, however, I see that once data is populated, the styling is cleared. I call the Put method with 'overwrite' param set to 'true' to populate the excel sheet. Is there any workaround or solution to keep styling?