C# (CSharp) OpenXmlConnection Examples

Example #1

 private DataTable GetExcelDatableBySheetName(string sheetName)
 {
     return(OpenXmlConnection.ReadExcelSheet(Directory.GetCurrentDirectory() + _xlsPath, sheetName));
 }

Example #2

 private ICollection <Answers> GetAnswersListFromXls()
 {
     return(OpenXmlConnection.ExcelMappingToAnserws(GetExcelDatableBySheetName("Answers")));
 }