I have an Excel workbook with 4 worksheets. The third worksheet is called 'csvTemplate'. I would like to copy 'csvTemplate' to make a fifth worksheet called 'gsData_01'.
Please advise on the correct MATLAB syntax to do this.
Current Code:
Excel = actxserver('Excel.Application');Workbook = Excel.Workbooks.Open('Example1.xlsx');set(Excel, 'Visible', 1);% need the code that implements the spreadsheet copy
Workbook.Save;Excel.Workbook.Close;invoke(Excel, 'Quit');delete(Excel)
Best Answer