I use this file to copy the sheet and save it to a new file, but the shape outline color is lost.
code:
foreach (Worksheet worksheet in workbook1.Worksheets)
{
Workbook workbook2 = new Workbook();
worksheet.Cells.RemoveFormulas();
workbook2.Worksheets[0].Copy(worksheet);
workbook2.Worksheets[0].Name = worksheet.Name;
string newPath = Path.Combine(tempDir, worksheet.Name + ".xlsx");
workbook2.Save(newPath,SaveFormat.Xlsx);
vs.Add(newPath);
}
test.zip (51.9 KB)