public void VbaError()
{
DirectoryInfo workingDir = new DirectoryInfo(@"C:\epplusExample\folder");
if (!workingDir.Exists)
{
workingDir.Create();
}
FileInfo f = new FileInfo(workingDir.FullName + "//" + "temp.xlsx");
if (f.Exists)
{
f.Delete();
}
ExcelPackage myPackage = new ExcelPackage(f);
myPackage.Workbook.CreateVBAProject();
ExcelWorksheet excelWorksheet = myPackage.Workbook.Worksheets.Add("Sheet1");
ExcelWorksheet excelWorksheet2 = myPackage.Workbook.Worksheets.Add("Sheet2");
ExcelWorksheet excelWorksheet3 = myPackage.Workbook.Worksheets.Add("Sheet3");
FileInfo f2 = new FileInfo(workingDir.FullName + "//" + "newfile.xlsm");
ExcelVBAModule excelVbaModule = myPackage.Workbook.VbaProject.Modules.AddModule("Module1");
StringBuilder mybuilder = new StringBuilder(); mybuilder.AppendLine("Sub Jiminy()");
mybuilder.AppendLine("Range(\"D6\").Select");
mybuilder.AppendLine("ActiveCell.FormulaR1C1 = \"Jiminy\"");
mybuilder.AppendLine("End Sub");
excelVbaModule.Code = mybuilder.ToString();
myPackage.SaveAs(f2);
myPackage.Dispose();
}
/// <summary>
/// Construct a worksheet that can get macros loaded from embedded resources
/// </summary>
/// <param name="worksheetName">Name of the worksheet</param>
/// <param name="excelWorkbook">Excel workbook to add worksheets to</param>
protected WorkSheet(string worksheetName, ExcelWorkbook excelWorkbook)
{
_worksheet = excelWorkbook.Worksheets.Add(worksheetName);
if (_worksheet.Workbook.VbaProject == null)
{
_worksheet.Workbook.CreateVBAProject();
}
_macroModule = excelWorkbook.VbaProject.Modules.AddModule($"{worksheetName}Commands");
}
public static void Init(TestContext context)
{
_pck = OpenPackage("FormControl.xlsm", true);
_pck.Workbook.CreateVBAProject();
_codeModule = _pck.Workbook.VbaProject.Modules.AddModule("ControlEvents");
}
