但是打开output.xlsx发现同样的worksheet与原来的颜色显示不一致,
test1中使用的是叫Office2007-2010的调色板,而新建的output.xlsx中是名为Office的调色板颜色。
- Code: Select all
Workbook workbook_standard = new Workbook();
Workbook workbook_check = new Workbook();
workbook_standard.LoadFromFile(inputStandardExcelPath);
workbook_check.LoadFromFile(inputCheckExcelPath);
Worksheet ws_standard = workbook_standard.Worksheets[formSheetName];
Worksheet ws_check = workbook_check.Worksheets[checkFileSheetName];
Workbook newbook = new Workbook();
newbook.Version = ExcelVersion.Version2013;
newbook.Worksheets.Clear();
newbook.Worksheets.AddCopy(ws_standard);
newbook.Worksheets.AddCopy(ws_check);
newbook.Worksheets[0].Name = "formsheet";
newbook.Worksheets[1].Name = "checkfile";
newbook.Worksheets[0].Activate();
newbook.SaveToFile(saveExcelPath, ExcelVersion.Version2013);
我发现workbook类有一个方法叫ChangePaletteColor(Color color, int index);
这个方法能否实现我的目的,如何设置参数?