如何在DataGridView中检索EPPlus单元格格式？

using OfficeOpenXml;
using OfficeOpenXml.Style;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Windows.Forms;

namespace EPPlusDemo
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void btnSearch_Click(object sender, EventArgs e)
        {
            // 获取DataGridView中的数据
            DataTable dt = new DataTable();
            foreach (DataGridViewColumn column in dataGridView1.Columns)
            {
                dt.Columns.Add(column.HeaderText);
            }

            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                DataRow dataRow = dt.NewRow();
                foreach (DataGridViewCell cell in row.Cells)
                {
                    dataRow[cell.ColumnIndex] = cell.Value;
                }
                dt.Rows.Add(dataRow);
            }

            // 使用EPPlus库来检索单元格格式
            using (ExcelPackage excelPackage = new ExcelPackage())
            {
                ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet1");

                // 将DataGridView中的数据导入到Excel工作表中
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    worksheet.Cells[1, i + 1].Value = dt.Columns[i].ColumnName;
                }

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        worksheet.Cells[i + 2, j + 1].Value = dt.Rows[i][j];
                    }
                }

                // 遍历DataGridView中的每个单元格，获取EPPlus单元格格式
                foreach (DataGridViewRow row in dataGridView1.Rows)
                {
                    foreach (DataGridViewCell cell in row.Cells)
                    {
                        int rowIndex = cell.RowIndex + 2;
                        int columnIndex = cell.ColumnIndex + 1;

                        ExcelRange range = worksheet.Cells[rowIndex, columnIndex];
                        ExcelStyle style = range.Style;

                        // 获取EPPlus单元格的格式信息
                        // 例如，可以获取字体、背景颜色、边框等信息
                        Font font = style.Font;
                        Color backgroundColor = style.Fill.BackgroundColor;
                        Border border = style.Border;

                        // 在这里可以根据需要处理获取到的格式信息
                        // 例如，可以根据格式信息来设置DataGridView中对应单元格的样式

                        // 示例：将EPPlus单元格的背景颜色设置为DataGridView中对应单元格的背景颜色
                        cell.Style.BackColor = System.Drawing.ColorTranslator.FromHtml(backgroundColor.Rgb);

                        // 示例：将EPPlus单元格的字体设置为DataGridView中对应单元格的字体
                        cell.Style.Font = new System.Drawing.Font(font.Name, font.Size);

                        // 示例：将EPPlus单元格的边框设置为DataGridView中对应单元格的边框
                        cell.Style.Border = new DataGridViewAdvancedBorderStyle()
                        {
                            Left = border.Left.Style == ExcelBorderStyle.None ? DataGridViewAdvancedCellBorderStyle.None : DataGridViewAdvancedCellBorderStyle.Single,
                            Right = border.Right.Style == ExcelBorderStyle.None ? DataGridViewAdvancedCellBorderStyle.None : DataGridViewAdvancedCellBorderStyle.Single,
                            Top = border.Top.Style == ExcelBorderStyle.None ? DataGridViewAdvancedCellBorderStyle.None : DataGridViewAdvancedCellBorderStyle.Single,
                            Bottom = border.Bottom.Style == ExcelBorderStyle.None ? DataGridViewAdvancedCellBorderStyle.None : DataGridViewAdvancedCellBorderStyle.Single
                        };
                    }
                }

                // 保存Excel文件
                excelPackage.SaveAs(new System.IO.FileInfo("output.xlsx"));
            }
        }
    }
}