Re: xlswrite : create xls with several worksheet

[Doug Stewart]

On Thu, Apr 21, 2016 at 11:34 AM, Littleboy <address@hidden> wrote:

Hi,

I am trying to create a report with my data from octave.
To do this I use xlswrite, but if someone can advice to try a other way me
he is welcome.

Here is what I do :

pkg load io
pkg load windows

Directory = [pwd '\Report\'];

Sheet1(1,1) = {'Tubes de longueur L ='};
Sheet1(2,1) = {'Nombre d''intervalles N ='};
Sheet1(3,1) = {'Rapport L/N ='};
Sheet1(1,2) = {L};
Sheet1(2,2) = {N};
Sheet1(3,2) = {pas};

Status = xlswrite(Directory, Sheet1, 'NameOfTheSheet');

Great! That works, my file is created.
But first it is never in the directory that I called in the xlswrite.

Second, I try to do the same for a sheet2 with :  but that overwrite
everything and i loose all my first data.
How to do if i want several worksheet in one file.xls?

If someone can help.
Thanks.

Littleboy

Better?





--
View this message in context: http://octave.1599824.n4.nabble.com/xlswrite-create-xls-with-several-worksheet-tp4676404p4676415.html

Sent from the Octave - General mailing list archive at Nabble.com.

_______________________________________________
Help-octave mailing list
address@hidden
https://lists.gnu.org/mailman/listinfo/help-octave

this works for me.

pkg load io

pkg load windows

L=4

N=7

pas=77

Directory = [pwd '\Report\doug.xlsx'];

Sheet1(1,1) = {'Tubes de longueur L ='};

Sheet1(2,1) = {'Nombre d''intervalles N ='};

Sheet1(3,1) = {'Rapport L/N ='};

Sheet1(1,2) = {L};

Sheet1(2,2) = {N};

Sheet1(3,2) = {pas};

arr=[1:10];

  status = xlswrite ('test4.xlsx', arr, 'Third_sheet', 'C3:AB40');

Status = xlswrite('test44.xlsx', Sheet1, 'NameOfTheSheet');

--

DAS