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