Search All of the Math Forum:

Views expressed in these public forums are not endorsed by NCTM or The Math Forum.

Notice: We are no longer accepting new posts, but the forums will continue to be readable.

Topic: Writing to excel cells
Replies: 3   Last Post: Jan 31, 2013 12:47 PM

 Messages: [ Previous | Next ]
 Leyo Joseph Posts: 67 Registered: 3/19/09
Re: Writing to excel cells
Posted: Jan 31, 2013 11:11 AM

dpb <none@non.net> wrote in message <kee1ed\$q0j\$1@speranza.aioe.org>...
> On 1/31/2013 6:15 AM, Leyo Joseph wrote:
> > I am looking for a method to write data to various cells of Excel sheet
> > using a for loop.
> > for example ==>
> > data =[1 2 3 4 5];
> > above writes contents of "data" to cell a2.
> > Is there a way to wirite contents of data to various cells using a for
> > loop.
> > Like data(1) to cell(1,1) of excel.
> > data(2) to cells(1,3)
> > data(3) to cells(1,5)....

>
> Use num2str() or sprintf() etc. create a dynamic cell address...
>
> fn=fullfile('F:','Test Data', 'example.xlsx');
> for i=1:length(data)
> c=['a' num2str(2*i-1)];
> xlswrite(fn,'data',c);
> end
>
> Obviously you can create more generic cell addresses by using character
> variables for columns as well...
>
> --Hello,

Thanks. It is working fine. See my code below==>
data =[1 2 3 4 5];
%xlswrite('F:\Test Data\example.xlsx',data,'meas','a2');
for i=1:length(data)
c=['a' num2str(2*i-1)];
xlswrite('F:\Test Data\example.xlsx',data(i),'meas',c);
end

Now I want to try this to write to various column.
Like data(1) to A5,
data(2) to B5
data(3) to C5
As you mentioned above, it is possible to do this. If you don't mind, please give me a simple example.
>

Date Subject Author
1/31/13 Leyo Joseph
1/31/13 dpb
1/31/13 Leyo Joseph
1/31/13 dpb