/// <param name="ExcelPath"></param>
/// <param name="Sheet"></param>
/// <param name="range">如果忽略视为已使用的单元格</param>
/// <param name="MaxCashCount"></param>
public ExcelDataReader(string ExcelPath = null, string Sheet = null, string range = "used", int MaxCashCount = 10000)
: base()
{
//准备Excel
eInfo = new Internal_ExcelInfo(ExcelPath, Sheet, range);
R = eInfo.App.Union(eInfo.R, eInfo.Ws.UsedRange);
this.MaxCashCount = MaxCashCount;
_FieldCount = R.Columns.Count;
_RowCont = R.Rows.Count - 1;
//获取标题
if (HasTitle)
{
FieldValues = ((Range)R.Rows[1]).Value[10];
}
}
/// <param name="ExcelPath"></param>
/// <param name="Sheet"></param>
/// <param name="range">如果忽略视为"A1"</param>
/// <param name="MaxCashCount"></param>
public ExcelDataExport(string ExcelPath = null, string Sheet = null, string range = "A1", bool withTitle = true, int MaxCashCount = 10000)
{
eInfo = new Internal_ExcelInfo(ExcelPath, Sheet, range, true, true, false);
this.withTitle = withTitle;
this.MaxCashCount = MaxCashCount;
}
