OpenXML SDK 将 VBA 注入 Excel 工作簿

使用OpenXML SDK将VBA注入Excel工作簿是一种常见的操作，它可以使我们以编程的方式向Excel添加自定义功能。OpenXML SDK是一个用于处理Office文档的开源库，它允许我们通过代码对文档进行操作和生成。

csharp
using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
using DocumentFormat.OpenXml.Vba;
public void InjectVbaCodeToWorkbook(string filePath, string vbaCode)
{
    using (SpreadsheetDocument document = SpreadsheetDocument.Open(filePath, true))
    {
        WorkbookPart workbookPart = document.WorkbookPart;
        VbaProjectPart vbaProjectPart = workbookPart.VbaProjectPart;
        if (vbaProjectPart == null)
        {
            vbaProjectPart = workbookPart.AddNewPart();
            vbaProjectPart.VbaProject = new VbaProject();
            workbookPart.Workbook.Save();
        }
        vbaProjectPart.VbaProject.Append(new Module() { SourceCode = vbaCode });
        vbaProjectPart.VbaProject.Save();
    }
}

csharp
string filePath = "path/to/your/workbook.xlsx";
string vbaCode = @"
Function HelloWorld()
    HelloWorld = ""Hello, World!""
End Function
";
InjectVbaCodeToWorkbook(filePath, vbaCode);