How to save a certain excel file to a specific folder?

Question

Bryant 2014-7-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/139923-how-to-save-a-certain-excel-file-to-a-specific-folder

评论： Bryant 2014-7-2

Does anyone know how to save an excel file that was already written to a certain folder? I want the excel file I save using xlswrite to save in my Dropbox folder for reference.

name_xls = input('What do you want to name the Excel file as?' , 's');
xlswrite(name_xls, exceloutput, '90CtT 45W','A1');

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Uladzimir 2014-7-2

4
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/139923-how-to-save-a-certain-excel-file-to-a-specific-folder#answer_143380

编辑：Uladzimir 2014-7-2

在 MATLAB Online 中打开

you can do it with the standard uiputfile dialog, for example

[FileNameBodeWrite, PathNameBodeWrite] = uiputfile({'*.xls';'*.csv'},'Save As...',['defname' '.xls']);
    if FileNameBodeWrite ~=0
        if exist([PathNameBodeWrite FileNameBodeWrite],'file')
            delete([PathNameLachWrite FileNameBodeWrite ]);
        end
        xlswrite([PathNameBodeWrite FileNameBodeWrite ],{'W,rad/s','K,dB','Phase,grad'})  %header           
        xlswrite([PathNameBodeWrite FileNameBodeWrite ],[w adb p],1,'A2') %data
    end
Or point the path manually like this
xlswrite(['D:\DropBox\' name_xls '.xls'], exceloutput, '90CtT 45W','A1');

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Bryant 2014-7-2

Thank you. Very informative (:

请先登录，再进行评论。

Answer 2

Image Analyst 2014-7-2

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/139923-how-to-save-a-certain-excel-file-to-a-specific-folder#answer_143379

在 MATLAB Online 中打开

Try this more robust code:

% Get the name of the file that the user wants to save.
% Note, if you're saving an image you can use imsave() instead of uiputfile().
startingFolder = userpath % Or whatever folder you want.
defaultFileName = fullfile(startingFolder, '*.*');
[baseFileName, folder] = uiputfile(defaultFileName, 'Specify a file');
if baseFileName == 0
  % User clicked the Cancel button.
  return;
end
fullFileName = fullfile(folder, baseFileName)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Bryant 2014-7-2

Image Analyst,

Thank you for the quick reply, I'm sorry but can you explain this more in-depth? I'm fairly new to MATLAB. If I were to incorporate this into my script, would i put it before xlswrite or...?

请先登录，再进行评论。