YGMSExcelBeater 1.0.1

README

What is this repository for?

This class libary uses NPOI to read and write to excel file with c# .net 6 and above. It has internal mapper to map the contents of Excel sheet to a generic collection List<T>. As long as the property names match the field names in the excel file

How do I get set up?

The Excel file must have a header to hold the field names. The field names must not have spaces or special characters All field names must be reproducable in the DTO where the records are mapped to

Sample setup: (Excel containing a key field in column 0 "L-2" being one of the unique values )

string excelFileName = "C:\Temp\TestData.xlsx";

// Constructor takes filename, sheet number, and column number for the key, or, column name using (IMSExcelBeater beater = new MSExcelBeater(excelFileName, 0, 0)) // first parm: filename, second parm: sheet number. Third parm: key column number or name { string title = beater.Get("L-2", "title"); // This is to get a value from column "title" row key number "L-2" string result1 = beater.Update("L-2", "title", "bloon"); // This is to update the value in column "title" row key number "L-2" string result2 = beater.Save(); // This is to save all the updates

List<TestDTO> allData = beater.GetAllData<TestDTO>(); // This is to retrieve the entire sheet into a generic collection

string[] fieldNames = beater.GetAllFieldNames(); // This is to retreve all field names in the excel file

}

Contribution guidelines

• Writing tests
• Code review
• Other guidelines

Who do I talk to?

• Repo owner or admin