How to use array2table without having headers?

조회 수: 8 (최근 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.
Austin Welch
Austin Welch 2018년 9월 7일
This worked perfectly! Thanks!

댓글을 달려면 로그인하십시오.

답변 (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 CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품


릴리스

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by