clc;关闭所有;清晰的所有;
excel = actxserver (“excel.application”);
excel。可见= 1;
集(excel,“DisplayAlerts”,0);
ExcelFile = fullfile (pwd,“helloWorld.xlsx”);
wkbk = excel.Workbooks.Open (ExcelFile);
wksheet = wkbk.Worksheets.Item (1);
为n = 6
wksheet.Copy (wksheet);
单张报纸= wkbk.Worksheets.Item (n - 1);
调用(单张报纸,“激活”)
ActivesheetRange_Title =得到(单张报纸,“范围”,“B2”);
ActivesheetRange_Title。值= (“董事会”“num2str (n - 1)];
ActivesheetRange_Date =得到(单张报纸,“范围”,“C3”);
ActivesheetRange_Date。值= datestr(现在,“名称”);
ActivesheetRange_Date.Interior。ThemeColor = 5;
ActivesheetRange_Date.cells.EntireColumn.AutoFit ();
ActivesheetRange_sessionName =得到(单张报纸,“范围”,“C4”);
ActivesheetRange_sessionName。值= datestr(现在,“HH00”);
ActivesheetRange_ImageName =得到(单张报纸,“范围”,“C5”);
ActivesheetRange_ImageName。值= (“董事会”“num2str (n - 1)];
业务通讯。Name = (“董事会”“num2str (n - 1)];
结束
sheetToDelete = excel.ActiveWorkbook.Worksheets.Item (n);
调用(sheetToDelete“删除”);
summarySheet = excel.ActiveWorkbook.Worksheets.Item (n);
summarySheet_dateRange =得到(summarySheet,“范围”,C2的);
summarySheet_dateRange。值= datestr(现在,“名称”);
summarySheet_timeRange =得到(summarySheet,“范围”,“C3”);
summarySheet_timeRange。值= datestr(现在,“HH00”);
newWorkBookName = fullfile (pwd (datestr(现在,“yyyymmdd_HH00”)“.xlsx”]);
workbookSheetCount = wkbk.worksheet.count;
summarySheetAddress = excel.ActiveWorkbook.Worksheets.Item (workbookSheetCount);
为m = 1:(workbookSheetCount-1)
worksheetToExtract = excel.ActiveWorkbook.Worksheets.Item (m);
worksheetToExtract_value =得到(worksheetToExtract,“范围”,“C7”);
sheetRangeToChange_contrastVal =得到(summarySheetAddress,“范围”,(“C”num2str (m + 5)]);
sheetRangeToChange_contrastVal。FormulaR1C1 =worksheetToExtract_value;
结束