Unable to obtain Sheets object in ActiveX control.
Use the ActiveX control to write values to an Excel file.
objExcel = actxserver(‘excel.application’);
objExcel.Visible = 1;
objExcelFile = objExcel.Workbooks.Open( t_filePath );
objSheet = objExcelFile.Sheets.Item(1);
objSheet.Range(t_range).value = t_outputData;
Error message
Method, property or field ‘Sheets’ of class ‘Interface.000208DA_0000_0000_C000_000000000046’ is not recognized. Error: ActiveXExcel (line 4) objSheet = objExcelFile.Sheets.Item(1);
A script that previously worked fine in R2021a now gives an error every time in R2024a.
How can I do ?
Thanks in advance. Use the ActiveX control to write values to an Excel file.
objExcel = actxserver(‘excel.application’);
objExcel.Visible = 1;
objExcelFile = objExcel.Workbooks.Open( t_filePath );
objSheet = objExcelFile.Sheets.Item(1);
objSheet.Range(t_range).value = t_outputData;
Error message
Method, property or field ‘Sheets’ of class ‘Interface.000208DA_0000_0000_C000_000000000046’ is not recognized. Error: ActiveXExcel (line 4) objSheet = objExcelFile.Sheets.Item(1);
A script that previously worked fine in R2021a now gives an error every time in R2024a.
How can I do ?
Thanks in advance. Use the ActiveX control to write values to an Excel file.
objExcel = actxserver(‘excel.application’);
objExcel.Visible = 1;
objExcelFile = objExcel.Workbooks.Open( t_filePath );
objSheet = objExcelFile.Sheets.Item(1);
objSheet.Range(t_range).value = t_outputData;
Error message
Method, property or field ‘Sheets’ of class ‘Interface.000208DA_0000_0000_C000_000000000046’ is not recognized. Error: ActiveXExcel (line 4) objSheet = objExcelFile.Sheets.Item(1);
A script that previously worked fine in R2021a now gives an error every time in R2024a.
How can I do ?
Thanks in advance. activex, sheets MATLAB Answers — New Questions