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);
}
