Thread Subject: Exporting a matrix from MATLAB to an excel 2007 spreadsheet

Subject: Exporting a matrix from MATLAB to an excel 2007 spreadsheet

From: Subrat Swain

Date: 26 Nov, 2008 18:52:01

Message: 1 of 3

Hi all,
I am creating a matrix file (.mat) after executing a program in MATLAB. The matrix file
is having a dimension of 7550*1510 (7550 rows and 1510 columns). Now I am not able to open it in MATLAB to view its contents. Is it possible by anyway I can export this
large matrix to an excel 2007 spreadsheet or to a notepad also. Actually I tried to
export the matrix using 'xlswrite' function but this command failed as I was exporting a
very big matrix and Excel 2003 doesn't have the required number of columns to hold this data.
Can anyone please provide me any ways to solve this problem.
Appreciate for the help.

Thanks and Regards,
Subrat Kumar Swain.

Subject: Exporting a matrix from MATLAB to an excel 2007 spreadsheet

From: someone

Date: 26 Nov, 2008 19:31:02

Message: 2 of 3

"Subrat Swain" <swain.subrat01@gmail.com> wrote in message <ggk5sh$b8v$1@fred.mathworks.com>...
> Hi all,
> I am creating a matrix file (.mat) after executing a program in MATLAB. The matrix file
> is having a dimension of 7550*1510 (7550 rows and 1510 columns). Now I am not able to open it in MATLAB to view its contents. Is it possible by anyway I can export this
> large matrix to an excel 2007 spreadsheet or to a notepad also. Actually I tried to
> export the matrix using 'xlswrite' function but this command failed as I was exporting a
> very big matrix and Excel 2003 doesn't have the required number of columns to hold this data.
> Can anyone please provide me any ways to solve this problem.
> Appreciate for the help.
>
> Thanks and Regards,
> Subrat Kumar Swain.

% Perhaps
doc dlmwrite
% will help.
% It can create a csv file that EXCEL can read (maybe).

Subject: Exporting a matrix from MATLAB to an excel 2007 spreadsheet

From: Subrat Swain

Date: 26 Nov, 2008 21:39:02

Message: 3 of 3

"someone" <someone@somewhere.net> wrote in message <ggk85m$f83$1@fred.mathworks.com>...
> "Subrat Swain" <swain.subrat01@gmail.com> wrote in message <ggk5sh$b8v$1@fred.mathworks.com>...
> > Hi all,
> > I am creating a matrix file (.mat) after executing a program in MATLAB. The matrix file
> > is having a dimension of 7550*1510 (7550 rows and 1510 columns). Now I am not able to open it in MATLAB to view its contents. Is it possible by anyway I can export this
> > large matrix to an excel 2007 spreadsheet or to a notepad also. Actually I tried to
> > export the matrix using 'xlswrite' function but this command failed as I was exporting a
> > very big matrix and Excel 2003 doesn't have the required number of columns to hold this data.
> > Can anyone please provide me any ways to solve this problem.
> > Appreciate for the help.
> >
> > Thanks and Regards,
> > Subrat Kumar Swain.
>
> % Perhaps
> doc dlmwrite
> % will help.
> % It can create a csv file that EXCEL can read (maybe).

Thanks a lot for the help. It is really a nice solution. It solved the problem.

Thanks and Regards,
Subrat Kumar Swain.

Tags for this Thread

Everyone's Tags:

Add a New Tag:

Separated by commas
Ex.: root locus, bode

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Tag Activity for This Thread
Tag Applied By Date/Time
dlmwrite someone 26 Nov, 2008 14:35:04
rssFeed for this Thread

Contact us at files@mathworks.com