how can i avoid xlwrite error ?

4 次查看（过去 30 天）
VBBV
VBBV 2018-7-1
重新打开： Walter Roberson 2018-7-21
I have a GUI which displays the data in uitable. When I save the file using pushbutton, by command uiputfile ... It saves the file, when I try to open file, it shows file locked for editing ... and at command prompt the status shows busy ... for long time... and MATLAB crashes ... by displaying the "An operation is in progress ..." message, sometimes this error does not appear... my code in pushbutton is below
data = [{get(handles.edit2,'String')} get(handles.uitable1,'ColumnName')';get(handles.uitable1,'RowName') num2cell(get(handles.uitable1,'Data'))]
[file,path] = uiputfile('*.xlsx','*.txt')
xlswrite(file,data);
disp('Save successful!!');

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

采纳的回答

Jan
Jan 2018-7-1
编辑：Jan 2018-7-1
What does "a long time" means exactly? Seconds, minutes, hours? What happens if the message does not appear?
Maybe your disk is full or damaged. Have you installed Excel on your machine? If so, which version? Does any detail about the problem in the system's logfiles?
  5 个评论
显示 3更早的评论
VBBV
VBBV 2018-7-1
I tried to use writetable to output delimited text file, instead of xlswrite or excel file, A new problem arose .. it writes everything, columnnames, rownames but not numeric data.
Walter Roberson
Walter Roberson 2018-7-20
You can use 'writevariablename', false to avoid writing the column names. You can use 'writerowname', false to avoid writing the row names.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by