/**
	 * 获取单元格的值, 所见即所得(日期未完善)
	 * @param cell
	 * @return
	 */
	public static String getCellValue(Cell cell) {
		if(cell == null)
			return "";
		DataFormatter dataFormatter = new DataFormatter();

		String res = null;

		if(cell.getCellType() == CellType.FORMULA) {
			FormulaEvaluator evaluator = cell.getSheet().getWorkbook().getCreationHelper().createFormulaEvaluator();
			res = dataFormatter.formatCellValue(cell, evaluator);
		} else {
			res = dataFormatter.formatCellValue(cell);
		}
		String dataFormatString = cell.getCellStyle().getDataFormatString();
		if (!StringUtil.isNull(dataFormatString)) {
			if(dataFormatString.matches("@\".+\"")) {
				Pattern p =  Pattern.compile("@\"(.+)\"");
				Matcher m = p.matcher(dataFormatString);
				m.find();
				res = res + m.group(1);
			}
		}

		return res;
	}

 
C# WPF DataGrid获取单元格的值
 
 
 XAML代码为
 DataGrid控件命名 绑定
 GotFocus事件

 
<DataGrid x:Name="dataGrid" GotFocus="dataGrid_GotFocus"/>
 
后端C#事件处理代码
 
        private void dataGrid_GotFocus(object sender, RoutedEventArgs e)
        {
            //获取第一列任意一行的单元格的值
            string result = (dataGrid.Columns[0].GetCellContent(dataGrid.CurrentCell.Item) as TextBlock).Text;
            //show一个MessageBox以及时获得反馈
            MessageBox.Show(result, "提示", MessageBoxButton.OK);
        }
 
结果演示
 获取第一列第一行单元格的值
 
 获取第一列第三行单元格的值
 

 
 
string str = (dataGrid.Columns[0].GetCellContent(dataGrid.Items[0]) as TextBlock).Text;
 
 
转载于:https://www.cnblogs.com/yelanggu/p/10444616.html

WPF与WinForm获取单元格方式不同，需要as强制转换 单元格类型
 (1)WinForm
 
string str = (string)dataGrid.Rows[0].Cells[0].Value;
 
(2)WPF
 
string str = (dataGrid.Columns[0].GetCellContent(dataGrid.Items[0]) as TextBlock).Text;