writing table to excel file
10 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
I am trying to write a table to an excel file that is in the same path but am getting the error below. I tried most of what is suggested online but its still not working.
T=table(Sr,Plosskw,Qlosskw,angle,voltage);
T(:,1:5);
excel_file='33_bus_test_network_data.xlsx';
writetable(T,'NO_DG_IEEE33.xlsx','Sheet',6,'Range','A1');
this is the error
Unable to write to file 'NO_DG_IEEE33.xlsx'. Ensure the
file is a valid spreadsheet file and is not password
protected.
Error in loadflowofdistributionsystem (line 280)
writetable(T,'NO_DG_IEEE33.xlsx','Sheet',6,'Range','A1');
5 comentarios
Walter Roberson
el 17 de Sept. de 2019
Please show the output of
fileattrib 33_bus_test_network_data.xlsx
fileattrib .
Respuestas (2)
sibabalo noludwwe
el 17 de Sept. de 2019
1 comentario
Walter Roberson
el 17 de Sept. de 2019
Okay so the file exists and is writable, and you do have permission to write to the directory.
What this would tend to suggest is that the existing xlsx file is password protected.
A much less common but not impossible situation would be if the file system involved is completely full . Some filesystems support a limited number of files and cannot create new files if they have run out. But this is not likely for an NTFS file system (more likely for a FAT16 system.)
sibabalo noludwwe
el 17 de Sept. de 2019
1 comentario
Walter Roberson
el 17 de Sept. de 2019
Rename the existing 33_bus_test_network_data.xlsx to something else, and try the writematrix() again. If it works then you know that there was something about the content already in 33_bus_test_network_data.xlsx that was leading to the issue. Open the existing 33_bus_test_network_data.xlsx in Excel and see if it prompts for a password
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!