Thread Subject: xlswrite

I am trying to incorporate xlswrite into a for-loop, but I don't know how (or even if there is a way) to write to either different sheets, or better yet to append onto itself with each loop.

On Nov 25, 6:29=A0am, "Travis" <sinuso...@hotmail.com> wrote:
> I am trying to incorporate xlswrite into a for-loop, but I don't know how=
 (or even if there is a way) to write to either different sheets, or better=
 yet to append onto itself with each loop.

xlswrite can write data to only one sheet, so you cannot chose
different sheet at all.

damayi <damayi@gmail.com> wrote in message <b8bad72d-5eda-45a0-a355-519663d11aef@q30g2000prq.googlegroups.com>...
> On Nov 25, 6:29=A0am, "Travis" <sinuso...@hotmail.com> wrote:
> > I am trying to incorporate xlswrite into a for-loop, but I don't know how=
> (or even if there is a way) to write to either different sheets, or better=
> yet to append onto itself with each loop.
>
> xlswrite can write data to only one sheet, so you cannot chose
> different sheet at all.

You can write to a number of worksheets within a single spreadsheet - see help on xlswrite. You can also append info to an existing sheet if you index the cells appropriately.