Auto attach file that I created with xlswrite?

1 次查看（过去 30 天）
Bryant
Bryant 2014-7-8
评论： Geoff Hayes 2014-7-9
Hi all,
I was wondering if there was a way for MATLAB to just attach a file automatically for sendmail that I made just by xlswrite instead of prompting the user with uigetfile for the attachment?
name_xls = input('What do you want to name the Excel file as?' , 's');
xlswrite(name_xls, exceloutput, '90CtT 45W','A1');
%Emails Excel sheet.
h = warndlg('Make sure your computer is connected to a secure Wifi connection! e.g: UCLA_WIFI, home network, etc.');
waitfor(h);
filepath = uigetfile('.xls','Select which Excel sheet you wish to email to Gmail.',pwd);
mail = input('Email Username (Gmail)?' , 's');
password = input('Email Password?', 's');
setpref('Internet','SMTP_Server','smtp.gmail.com');
setpref('Internet','E_mail',mail);
setpref('Internet','SMTP_Username',mail);
setpref('Internet','SMTP_Password',password);
props = java.lang.System.getProperties;
props.setProperty('mail.smtp.auth','true');
props.setProperty('mail.smtp.socketFactory.class', 'javax.net.ssl.SSLSocketFactory');
props.setProperty('mail.smtp.socketFactory.port','465');
sendmail(mail,'LFA Analysis','Here are the results for your analysis!', filepath)

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

采纳的回答

Geoff Hayes
Geoff Hayes 2014-7-8
Since the data has been saved to a file with the name of name_xls (presumably within the current directory), then rather than prompting the user for the file to send, just replace filepath with
filepath = fullfile(pwd, name_xls)
which will create a string that has the full path and name of the file to attach.
  4 个评论
显示 2更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Environment and Settings 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by