Borrar filtros
Borrar filtros

writing table to excel file

19 visualizaciones (últimos 30 días)
sibabalo noludwwe
sibabalo noludwwe el 16 de Sept. de 2019
Comentada: Walter Roberson el 17 de Sept. de 2019
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
sibabalo noludwwe
sibabalo noludwwe el 17 de Sept. de 2019
Error using writetable (line 124)
Unable to write to file '33_bus_test_network_data.xlsx'. Ensure the file is a valid spreadsheet file and is not password protected.
Error in loadflowofdistributionsystem (line 239)
writetable(T,'33_bus_test_network_data.xlsx','Sheet',6,'Range','A1');
>> cd
C:\Users\Queen Siba\OneDrive - University of Cape Town\matlab\Graph Theory
this is the current directory which is also where the excel file is saved
Walter Roberson
Walter Roberson el 17 de Sept. de 2019
Please show the output of
fileattrib 33_bus_test_network_data.xlsx
fileattrib .

Iniciar sesión para comentar.

Respuestas (2)

sibabalo noludwwe
sibabalo noludwwe el 17 de Sept. de 2019
fileattrib 33_bus_test_network_data.xlsx
Name: 'C:\Users\Queen Siba\OneDrive - University of Cape Town\matlab\Graph Theory\September\33_bus_test_network_data.xlsx'
archive: 1
system: 0
hidden: 0
directory: 0
UserRead: 1
UserWrite: 1
UserExecute: 1
GroupRead: NaN
GroupWrite: NaN
GroupExecute: NaN
OtherRead: NaN
OtherWrite: NaN
OtherExecute: NaN
>> fileattrib
Name: 'C:\Users\Queen Siba\OneDrive - University of Cape Town\matlab\Graph Theory\September'
archive: 0
system: 0
hidden: 0
directory: 1
UserRead: 1
UserWrite: 1
UserExecute: 1
GroupRead: NaN
GroupWrite: NaN
GroupExecute: NaN
OtherRead: NaN
OtherWrite: NaN
OtherExecute: NaN
  1 comentario
Walter Roberson
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.)

Iniciar sesión para comentar.


sibabalo noludwwe
sibabalo noludwwe el 17 de Sept. de 2019
so what are you suggesting am still confused
  1 comentario
Walter Roberson
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

Iniciar sesión para comentar.

Categorías

Más información sobre File Operations en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by