How to convert .stp to .xlsx on a Mac

5 次查看（过去 30 天）

NH 2013-3-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/68520-how-to-convert-stp-to-xlsx-on-a-mac

Hello,

I am running the following code in order to convert many .stp files to .xlsx:

files=dir('*.stp')
for i=1:length(files)
    filename=files(i).name;
    [pathstr, name, ext] = fileparts(filename);
    copyfile(filename, fullfile(pathstr, [name '.xlsx']))
end

The resulting .xlsx files do not open in Excel. The error reads: "This 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." When converting to .xls, it works perfectly, but I need .xlsx.

I have tried the following with no success:

-Converting to a different format (i.e. .xls, .csv, .txt), and then to .xlsx

-Reading the .stp data into Matlab variables, and using xlswrite. This does not work because I am using a Mac and thus have limited capabilities with xlswrite.

Any help is greatly appreciated.