MATLAB Central Newsreader - Writing variable name and value from matlab workspace

Writing variable name and value from matlab workspace

SURESH — Tue, 30 Sep 2008 06:30:04 -0400

Hello Frineds,

In brief, is it possible to write the variable name and its value from the matlab workspace to an excel file. I know that using “xlswrite” command, we can write the values from the workspace to an excel file. But I would like to know whether I can write the variable name as well.

Thanks,
Suresh.

Re: Writing variable name and value from matlab workspace

Walter Roberson — Tue, 30 Sep 2008 14:13:38 -0400

SURESH wrote:

> In brief, is it possible to write the variable name and its value from the
> matlab workspace to an excel file. I know that using “xlswrite”
> command, we can write the values from the workspace to an excel file. But I
> would like to know whether I can write the variable name as well.

Only by converting the name into a value and writing it along with the other
values.

If you are using xlswrite() under MS Windows you can (I gather)
write fairly sophisticated files, but under any of the other operating systems
-effectively- in order to write a string as part of the data, you have to
convert *everything* to text before-hand, including putting in all
of the cell delimeters as part of the created text, and write out the text using
dlmwrite() with the cell delimeter set to the empty string.

Re: Writing variable name and value from matlab workspace

SURESH — Wed, 01 Oct 2008 05:28:01 -0400

Walter Roberson <roberson@hushmail.com> wrote in message <%tqEk.2561$i84.1493@newsfe10.iad>...
> SURESH wrote:
>
> > In brief, is it possible to write the variable name and its value from the
> > matlab workspace to an excel file. I know that using “xlswrite”
> > command, we can write the values from the workspace to an excel file. But I
> > would like to know whether I can write the variable name as well.
>
> Only by converting the name into a value and writing it along with the other
> values.
>
> If you are using xlswrite() under MS Windows you can (I gather)
> write fairly sophisticated files, but under any of the other operating systems
> -effectively- in order to write a string as part of the data, you have to
> convert *everything* to text before-hand, including putting in all
> of the cell delimeters as part of the created text, and write out the text using
> dlmwrite() with the cell delimeter set to the empty string.

Hello Roberson,
Thanks for the reply.
Actually I'm working on MS Windows operating system. Could you please let me know how to convert the variable name as a value so that I can write both the name and value of the variable to an excel file.
Currently I'm usinf active server to invoke an excel server then using the DDE command I'm pring the results to the excel file.

Any help in this is highly appreciated...

Thanks,
Suresh.

Re: Writing variable name and value from matlab workspace

Shanmugam Kannappan — Wed, 01 Oct 2008 05:46:01 -0400

Hello,
try this,

I think this will work for u.

var1=20;
xlswrite('X1.xlsx',[{'var1'};var1])

Shan...

"SURESH " <sureshkumarg@infotechsw.com> wrote in message <gbsh1c$luc$1@fred.mathworks.com>...
> Hello Frineds,
>
> In brief, is it possible to write the variable name and its value from the matlab workspace to an excel file. I know that using “xlswrite” command, we can write the values from the workspace to an excel file. But I would like to know whether I can write the variable name as well.
>
> Thanks,
> Suresh.