How to use array2table without having headers?

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

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
Austin Welch am 7 Sep. 2018
This worked perfectly! Thanks!

Melden Sie sich an, um zu kommentieren.

Antworten (1)

Navdha Agarwal
Navdha Agarwal am 21 Jun. 2019

0 Stimmen

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.

Produkte

Version

R2018a

Gefragt:

am 7 Sep. 2018

Beantwortet:

am 21 Jun. 2019

Community Treasure Hunt

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

Start Hunting!

Translated by