/// <summary> /// 查找原点 /// </summary> /// <param name="book"></param> private void FindOrigin(ISheet sheet) { var Finder = new OriginCellFinder(sheet, this.OriginNames); Finder.Find(); Origin = Finder.ResultCell; if (null != Finder) { return; } #region old code...... Origin = new OriginCell(); for (int i = 0; i <= sheet.LastRowNum; i++) { IRow row = sheet.GetRow(i); if (null == row) { continue; } if (0 == row.Cells.Count) { continue; } if (row.Cells.Count == row.LastCellNum) { Console.WriteLine("equre !"); } for (int j = 0; j < row.LastCellNum; j++) { //ICell cell = row.Cells[j]; ICell cell = row.GetCell(j); string CellString = GetCellString(cell); x.Say(String.Format("准备处理数据【{0}】行【{1}】列", i, j)); if (null == CellString) { x.Say("没有数据。"); } else { x.Say("找到数据:" + CellString); } if ("品名" == CellString) { Origin = new OriginCell(j, i); return; } } } #endregion }
public OriginCell FindInSheet(ISheet sheet) { var ResultOrigin = new OriginCell(); for (int i = 0; i <= sheet.LastRowNum; i++) { IRow row = sheet.GetRow(i); if (null == row) { continue; } if (0 == row.Cells.Count) { continue; } //row.Cells.Count 实际使用的数量 //row.LastCellNum 最后一个cell的数字 //if (row.Cells.Count == row.LastCellNum) //{ // //Console.WriteLine("equre !"); //} for (int j = 0; j < row.LastCellNum; j++) { x.Say(String.Format("准备处理数据【{0}】行【{1}】列", i, j)); ICell cell = row.GetCell(j); if (IsOriginCell(cell)) { ResultOrigin = new OriginCell(j, i); return(ResultOrigin); } //if ("品名" == cellString) //{ // ResultOrigin = new OriginCell(j, i); // return; //} } } return(ResultOrigin); }
public OriginCellFinder() { ResultCell = new OriginCell(); OriginNames = new List <string>(); ResultList = new List <OriginCell>(); }