public override int GetHashCode() { unchecked { return(((DefineName != null ? DefineName.GetHashCode() : 0) * 397) ^ (DefineValue != null ? DefineValue.GetHashCode() : 0)); } }
public Dictionary <string, object> ReadCellData(Stream stream, SheetInfo sheetInfo) { Dictionary <string, object> m_DataOutput = new Dictionary <string, object>(); using (ExcelPackage m_ExcelPackage = new ExcelPackage()) { // Open the Excel file and load it to the ExcelPackage m_ExcelPackage.Load(stream); ExcelWorksheet m_ExcelWorksheet = null; if (sheetInfo != null) { m_ExcelWorksheet = sheetInfo.SheetIndex > 0 ? m_ExcelPackage.Workbook.Worksheets[sheetInfo.SheetIndex] : m_ExcelPackage.Workbook.Worksheets[sheetInfo.SheetName]; } else { m_ExcelWorksheet = m_ExcelPackage.Workbook.Worksheets.FirstOrDefault(); } if (m_ExcelWorksheet != null) { //Get Define Name foreach (var DefineName in m_ExcelPackage.Workbook.Names) { m_DataOutput.Add(DefineName.Name, m_ExcelWorksheet.Cells[DefineName.Start.Row, DefineName.Start.Column].Text); DefineName.Dispose(); } //Get Cells foreach (var cell in m_ExcelWorksheet.Cells) { m_DataOutput.Add(cell.Address, cell.Value); } } else { throw new ArgumentException("Không tìm thấy Sheet tương ứng"); } } return(m_DataOutput); }