新文章 网摘 文章 随笔 日记

使用EPPLUS查找和替换所有字符串(Find and Replace all string using EPPLUS)

var valueToSearch = "Foo";
    var valueToReplace = "Bar";
    var sheetName = "Sheet1";
    var filePath = @"d:\foo-bar.xlsx";

    using (var excel = new ExcelPackage(new System.IO.FileInfo(filePath)))
    {
        var ws = excel.Workbook.Worksheets[sheetName];

        // search in all cells
        // https://github.com/JanKallman/EPPlus/wiki/Addressing-a-worksheet
        var query = from cell in ws.Cells["A:XFD"] 
                    where cell.Value?.ToString().Contains(valueToSearch) == true
                    select cell;

        foreach(var cell in query)
        {
            cell.Value = cell.Value.ToString().Replace(valueToSearch, valueToReplace);
        }

        excel.Save();
    }

https://stackoverflow.com/questions/56312166/find-and-replace-all-string-using-epplus

 
posted @ 2020-05-18 11:45  岭南春  阅读(552)  评论(0)    收藏  举报