c# – EPPlus – 未填充命名范围

发布时间：2020-12-16 00:23:45 所属栏目：百科来源：网络整理

导读：我正在使用EPPLus打开Excel Spreadsheets并尝试从命名范围读取.命名范围为空. 我使用这个错误,还是EPPlus的问题码 var package = new ExcelPackage(); using (var stream = File.OpenRead(tmpExcel)) { package.Load(stream); } var worksheet = package.Wo

我正在使用EPPLus打开Excel Spreadsheets并尝试从命名范围读取.命名范围为空.

我使用这个错误,还是EPPlus的问题

码

var package = new ExcelPackage();

        using (var stream = File.OpenRead(tmpExcel))
        {
            package.Load(stream);
        }

        var worksheet = package.Workbook.Worksheets["Common-Lookup"];

        using (ExcelNamedRange namedRange = worksheet.Names["LupVerticalSettings"])
        {
            for (var row = namedRange.Start.Row; row <= namedRange.End.Row; row++)
            {
                for (var col = namedRange.Start.Column; col <= namedRange.End.Column; col++)
                {
                    _.Nv(worksheet.Cells[row,col].Address,worksheet.Cells[row,col].Text);
                    //worksheet.Cells[rowIndex,columnIndex].Value = "no more hair pulling";
                }
            }
        }

Excel看起来像这样

空命名范围

解决方法

我解决了我的问题,我会在这里为那些可能需要它的人提出答案

var package = new ExcelPackage();

    using (var stream = File.OpenRead(tmpExcel))
    {
        package.Load(stream);
    }

    var worksheet = package.Workbook.Worksheets["Common-Lookup"];

    // Access Named Ranges from the ExcelWorkbook instead of ExcelWorksheet
    //using (ExcelNamedRange namedRange = worksheet.Names["LupVerticalSettings"])

    // use package.Workbook.Names instead of worksheet.Names
    using (ExcelNamedRange namedRange = package.Workbook.Names["LupVerticalSettings"])
    {
        for (var row = namedRange.Start.Row; row <= namedRange.End.Row; row++)
        {
            for (var col = namedRange.Start.Column; col <= namedRange.End.Column; col++)
            {
                _.Nv(worksheet.Cells[row,col].Text);
                //worksheet.Cells[rowIndex,columnIndex].Value = "no more hair pulling";
            }
        }
    }

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!