MATLAB Answers

0

creat a excel file from matlab

Cordelle 님이 질문을 제출함. 1 Jul 2013
I have data that I want to put in a excel file from matlab. the data is coming from a text file that I read in using textscan, here is my sample code:
fileID = fopen('passReport.EO1_2013_107_193146');
c = textscan(fileID, '%s')
fclose(fileID);
data = celldisp(c);
I want to take the data in the variable "data" and create a excel file with it

  댓글 수: 0

로그인 to comment.

답변 수: 2

Answer by Evan
on 1 Jul 2013
Edited by Evan
on 1 Jul 2013
 Accepted Answer

The "xlswrite" command should do what you need:
help xlswrite
xlswrite allows you to control the file to which your data is written, the sheet within that file to which your data is written, and the specific cells to which your data is written. If a file with the name you provide does not already exist, a new one is created. Very handy function.

  댓글 수: 14

표시 이전 댓글 수: 11
nevermind, it works. thank you
Evan
on 2 Jul 2013
The row/column limit for recent versions of excel is much higher than 852 rows, so I don't think excel would be the cause of your problem. Also, I had no trouble writing a random cell array of size 1000x200 to an excel file using xlswrite, so I don't think xlswrite would be the culprit. It sounds like it has something to do with your text file or the way you're reading it in, but I really can't say for sure.
Evan
on 3 Jul 2013
Oops, it looks like I either missed your last comment or we both posted at around the same time. Glad you have it working!

로그인 to comment.


Answer by Image Analyst
on 2 Jul 2013

You can't send c into xlswrite or else it will put one character per Excel cell. You have to put the string into a cell first.
fileID = fopen('passReport.EO1_2013_107_193146');
c = textscan(fileID, '%s')
fclose(fileID);
caC = {c}; % Stick string into a single cell.
xlswrite(XLFileName, caC, 'A1');

  댓글 수: 1

Thanks for the help, but a error message still occurred:
Error using xlswrite (line 220)
Error: Object returned error code: 0x800A03EC
Error in Untitled (line 14)
xlswrite(filename, caC, 'A1');
the data in the file is numeric data, do you think its not transferring to the excel file because we are trying to read a string?

로그인 to comment.



Translated by