导出到excel的c#数据为空文件

var data = GetData(); // 假设这是获取数据的函数
if (data == null || !data.Any())
{
    Console.WriteLine("数据源为空");
    return;
}

string filePath = @"C:\path\to\your\file.xlsx";
if (!File.Exists(filePath))
{
    File.Create(filePath).Dispose();
}

using OfficeOpenXml;
using System.IO;

public void ExportToExcel(IEnumerable<YourDataType> data, string filePath)
{
    FileInfo fileInfo = new FileInfo(filePath);
    using (ExcelPackage package = new ExcelPackage(fileInfo))
    {
        ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet1");
        worksheet.Cells["A1"].LoadFromCollection(data, true);
        package.Save();
    }
}

using ClosedXML.Excel;
using System.IO;

public void ExportToExcel(IEnumerable<YourDataType> data, string filePath)
{
    using (var workbook = new XLWorkbook())
    {
        var worksheet = workbook.Worksheets.Add("Sheet1");
        worksheet.Cell(1, 1).InsertTable(data);
        workbook.SaveAs(filePath);
    }
}

try
{
    // 导出逻辑
}
catch (Exception ex)
{
    Console.WriteLine($"导出失败: {ex.Message}");
}