xlsread problems with macro

1 次查看（过去 30 天）

显示更早的评论

Dries 2017-7-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/349199-xlsread-problems-with-macro

在 MATLAB Online 中打开

Hello,

I am trying to read in a bunch of excel files from a server. They all have a macro.

When I read in the file, excel shows a pop up screen saying the following:

'Unable to read myFileName sheet. PLease make sure, myFileName.xls is in the -xlstart- subdirectory of the -office- program.'

If I then select the ok button, Matlab reads in the file anyway so that is not an issue. But because I have several 100 of files I don't want to be doing this all the time.

I tried the following fixes: - setup a com link using the actxserver and then disable the warning messages

if true
%              Excel = actxserver('Excel.Application');
%              Excel.DisplayAlerts = false; % Suppress Excel warning popups, like for overwriting a file
end

- Use the basic function in xlsread but then it gives the following error: 'Error using xlsread (line 247) File contains unexpected record length. Try saving as Excel 98.'

Both didn't work. I think the reason is that the files contains a macro because when I save the file locally without the macro it works.

Does anybody have an idea how to fix this?

Thanks!!!

Kind regards,

Dries