根据excel表格中的值获取单元格范围/位置，并在c#中为单元格数据网格视图着色

using Excel = Microsoft.Office.Interop.Excel;

// 打开Excel文件
Excel.Application excelApp = new Excel.Application();
Excel.Workbook workbook = excelApp.Workbooks.Open("YourExcelFile.xlsx");
Excel.Worksheet worksheet = workbook.Worksheets[1];

// 获取单元格范围/位置
Excel.Range range = worksheet.Cells.Find("YourValue");
if (range != null)
{
    string cellAddress = range.Address;
    Console.WriteLine("单元格范围/位置: " + cellAddress);
}
else
{
    Console.WriteLine("未找到指定的值");
}

// 关闭Excel文件
workbook.Close();
excelApp.Quit();

using System.Data;
using System.Drawing;
using System.Windows.Forms;

// 创建一个DataGridView控件
DataGridView dataGridView = new DataGridView();

// 读取Excel数据到DataTable
DataTable dataTable = new DataTable();
// 假设Excel数据已经读取到dataTable中

// 将DataTable绑定到DataGridView
dataGridView.DataSource = dataTable;

// 遍历每个单元格，根据值设置背景色
foreach (DataGridViewRow row in dataGridView.Rows)
{
    foreach (DataGridViewCell cell in row.Cells)
    {
        string cellValue = cell.Value.ToString();
        if (cellValue == "YourValue")
        {
            cell.Style.BackColor = Color.Yellow;
        }
    }
}