MVC C# 如何修改EXCEL 内容

1.  添加Spire.XLS.dll引用，nutget那边有免费的下载

下面的例子，是如何把Template_INCH.xlsx里的“Tag”名字修改成“abc”:

    public ActionResult ChangeText()
        {
            string path = @"D:\AM2\Template_INCH.xlsx";
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(path);

            Worksheet sheet = workbook.Worksheets[1];

            CellRange range = sheet.Range["A1:L1"];

            CellRange[] cells = range.FindAllString("Tag", false, false);

            foreach (CellRange cell in cells)
            {
                cell.Text = "abc";
            }
            workbook.SaveToFile(@"D:\Output1.xlsx", ExcelVersion.Version2013);

            return View();
        }