This is the code I'm using to export.
- Code: Select all
Workbook workbook = new Workbook();
workbook.LoadFromFile(Application.StartupPath + @"\formato.xlsx");
Worksheet worksheet = workbook.Worksheets[0];
worksheet.InsertRow(8);
worksheet.Copy(worksheet.Range["A7:I7"], worksheet.Range["A8:I8"], true);
workbook.SaveToFile(path +".xlsx", ExcelVersion.Version2010);
System.Diagnostics.Process.Start(workbook.FileName);
The file was created in Excel 2016