Re: xlswrite : create xls with several worksheet

[Nicholas Jankowski]

On Fri, Apr 22, 2016 at 11:01 AM, PhilipNienhuis <address@hidden> wrote:
> Littleboy wrote
>> Thank you, I saw my first mistake.
>>
>> Here is a correction, do that work for you? In my case the file.xlsx is
>> not create in the specify directory but in the current directory.
>> And when I open the file.xls, all my data from sheet1 is overwriten.
>>
>> Directory = [pwd '\Report\'];
>> FileName = [Directory 'file.xlsx'];
>>
>> arr1 = [1:5];
>> arr2 = [1:10];
>>
>> Status1 = xlswrite(FileName, arr1,'sheet1');
>> Status2 = xlswrite(FileName, arr2,'sheet2');
>
> Yeah the issue here (AFAICS) is that zip cannot create directories.
> FYI, .xlsx files are plain zipped archives; the executable zip (or zip.exe)
> is used to create the .xlsx file but it fails. I just tried with zip.m but
> that fails as well.
>
> But in a more general sense, it doesn't work with the COM interface either
> (where Excel itself is invoked behind the scenes, just like in Matlab).
> Which makes me wonder if what the OP wants would work at all in Matlab - I'm
> unsure.
>
> I have no access to Matlab right now - could someone that does give it a try
> ?
>
> Philip

I use Matlab via remote access to the university, so not sure if it's
setup to invoke excel or not. will report back.

in the meantime, shouldn't xlswrite return a 0? is xlswrite unaware of
the zip.m file creation error? if so that may be worth it's own bug
report.