C#打开Excel电子表格冻结UI (使用任务打开)

using System;
using System.Threading.Tasks;
using OfficeOpenXml; // EPPlus库

public class ExcelHandler
{
    public async Task OpenExcelAsync(string filePath)
    {
        await Task.Run(() =>
        {
            using (var package = new ExcelPackage(new System.IO.FileInfo(filePath)))
            {
                // 处理Excel文件
                var worksheet = package.Workbook.Worksheets[0];
                // 冻结窗格
                worksheet.View.FreezePanes(2, 1); // 冻结前两行和第一列
                // 其他操作...
            }
        });
    }
}

// 使用示例
public class Program
{
    public static async Task Main(string[] args)
    {
        var excelHandler = new ExcelHandler();
        await excelHandler.OpenExcelAsync("path_to_your_excel_file.xlsx");
        Console.WriteLine("Excel file opened and processed.");
    }
}