필터 지우기
필터 지우기

Help using xlswrite function

조회 수: 2 (최근 30일)
Julian
Julian 2018년 9월 11일
편집: Julian 2018년 9월 11일
Hi everyone,
so i want so save a cell in an excel sheet.
My cell is a 2 x 9 cell and it looks something like this:
Row 1: {'Network No'} {'xx'} {'xx'}
Row 2: {[20]} {[10]} {[30]}
But when i use xlswrite i get the following error:
Error using xlswrite (line 194) An error occurred on data export in CSV format.
Caused by: Error using dlmwrite (line 104) The input cell array cannot be converted to a matrix.
Do you have any idea what i have to change in my cell so that it becomes convertable?
Thank you!
  댓글 수: 2
Guillaume
Guillaume 2018년 9월 11일
An error occurred on data export in CSV format
i want so save a cell in an excel sheet
Clearly, from the error you're attempting to save a csv file, not an excel file. What you probably need to change is your xlswrite line. Without seeing the code it's difficult to say.
Also, it looks like your data would be better stored in a table rather than a cell array. It's also easier to save tables to CSV or excel files.
Julian
Julian 2018년 9월 11일
편집: Julian 2018년 9월 11일
Hi,
i don't know why it wants to save a csv, maybe because i'm using Linux and there is no Excel installed?
I made a table as you advised and it worked exactly as I wanted, thank you very much!

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

답변 (0개)

카테고리

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