How to use array2table without having headers?
Ältere Kommentare anzeigen
I am converting an array to a table so I can write it to an excel file, but I dont want the headers that appear when I convert it to a table because when I write it to an excel file the first row in the excel file has the headers. I don't want headers in the excel file, I just want my data. Thanks for any help.
2 Kommentare
Paolo
am 7 Sep. 2018
I am assuming you are using Writetable to write to the Excel file. You can specify the name-value pair :
'WriteVariableNames',false
When calling the function. That will prevent the headers in the file.
Austin Welch
am 7 Sep. 2018
Antworten (1)
Navdha Agarwal
am 21 Jun. 2019
If you have to write an array or a matrix to an excel file, you can do so without even converting it to a table.
Following is the snippet for the same.
A=[1 2 3;4 5 6] % Suppose this is the matrix you want to write to an excel file
csvwrite('file.csv',A)
This does not take any headers into consideration.
Kategorien
Mehr zu Spreadsheets finden Sie in Hilfe-Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!