how can i avoid xlwrite error ?
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
VBBV
el 1 de Jul. de 2018
Abierta de nuevo: Walter Roberson
el 21 de Jul. de 2018
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!!');
1 comentario
Respuesta aceptada
Jan
el 1 de Jul. de 2018
Editada: Jan
el 1 de Jul. de 2018
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 comentarios
Walter Roberson
el 20 de Jul. de 2018
You can use 'writevariablename', false to avoid writing the column names. You can use 'writerowname', false to avoid writing the row names.
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!