Problem with Excel Open method

Question

Jose Caballero 2015-4-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/196730-problem-with-excel-open-method

回答： Image Analyst 2015-4-8

Hi,

I am trying to use MATLAB to export some data. I implemented the following code snippet and plan to use the xlswrite1 function after (there is a lot of data to transfer):

function [] = write_out_dl21(fullfilename_in,dl21_param,data_in_display,data_in_summary_itvl,data_in_summary_total)
% Open file and call Excel methods
[pathstr, filename_in, file_ext] = fileparts(fullfilename_in)
% Excel methods DO not like spaces in the file names!
filename_in=strrep(filename_in,' ','_')
fullname_out = strcat(pathstr,'\',filename_in,'_OUT',file_ext);

The code above gives the error:

??? Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: Excel cannot open the file 'inner_oslofjord_1_udp_ALL_EN_OUT.xlsx' because the file format or file
extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of
the file.
Help File: xlmain11.chm
Help Context ID: 0
Error in ==> write_out_dl21 at 38
ExcelWorkbook = Excel.workbooks.Open(fullname_out);