private string GetOneCellText(FarPoint.Win.Spread.SheetView sheet, string tagStr) { FarPoint.Win.Spread.Cell cell = sheet.GetCellFromTag(null, tagStr); if (cell != null) { return(cell.Text); } return(string.Empty); }
/// <summary> /// 设置单个Cell的Text /// </summary> /// <param name="sheet">SheetView</param> /// <param name="tagStr">Cell的tag</param> /// <param name="strText">要显示的Text</param> private void SetOneCellText(FarPoint.Win.Spread.SheetView sheet, string tagStr, string strText) { FarPoint.Win.Spread.Cell cell = sheet.GetCellFromTag(null, tagStr); if (cell != null) { FarPoint.Win.Spread.CellType.TextCellType t = new FarPoint.Win.Spread.CellType.TextCellType(); t.Multiline = true; t.WordWrap = true; cell.CellType = t; cell.Text += strText; } }
/// <summary> /// 设置单个Cell的Text /// </summary> /// <param name="sheet">SheetView</param> /// <param name="tagStr">Cell的tag</param> /// <param name="strText">要显示的Text</param> private void SetOneCellText(FarPoint.Win.Spread.SheetView sheet, string tagStr, string strText) { FarPoint.Win.Spread.Cell cell = sheet.GetCellFromTag(null, tagStr); if (cell != null) { FarPoint.Win.Spread.CellType.TextCellType t = new FarPoint.Win.Spread.CellType.TextCellType(); t.Multiline = true; t.WordWrap = true; cell.CellType = t; //把字符串转换成数字进行相加,成功后转回字符串 try { if (cell.Text == string.Empty || cell.Text == null) { cell.Text = "0"; } if (strText == string.Empty || strText == null) { strText = "0"; } decimal intText = (Convert.ToDecimal(cell.Text) + Convert.ToDecimal(strText)); cell.Text = intText.ToString(); } //如果转换失败则把字符串相加 catch { if (cell.Text == "0") { cell.Text = ""; } if (strText == "0") { strText = ""; } cell.Text += strText; } //相加结果为零,变成空字符串 if (cell.Text == "0") { cell.Text = ""; } // cell.Text += strText; } }