How to use array2table without having headers?

9 次查看（过去 30 天）
Austin Welch
Austin Welch 2018-9-7
回答： Navdha Agarwal 2019-6-21
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 个评论
Paolo
Paolo 2018-9-7
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.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Navdha Agarwal
Navdha Agarwal 2019-6-21
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by