Re: xlswrite : create xls with several worksheet

[Nicholas Jankowski]

On Fri, Apr 22, 2016 at 1:46 PM, Nicholas Jankowski <address@hidden> wrote:
> On Fri, Apr 22, 2016 at 12:39 PM, PhilipNienhuis <address@hidden> wrote:
>> NJank wrote
>>> 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.
>>
>> You mean for the file creation error? No I don't think so, it really is
>> another issue:
>> The actual bug to fix is that xlswrite and xlsread happily accept an empty
>> file name (even if silently derived from a subdir name) and append it an
>> extension anyway, instead of insisting on a valid filename.
>> Funny is that Excel happily opens and correctly reads a file called ".xlsx"
>> and only then complains that the file name is invalid.  LibreOffice opens &
>> reads it w/o complaints whatsoever...
>>
>> I knew about this scenario for a long time, not only for xlswrite but for
>> zip.m and friends as well, but AFAICS this is the first time someone reports
>> to have hit it.  I am not even sure that it is a bug.
>> TTBOMK there are very few applications that you can feed a nonexistent path
>> and then happily create that path.
>>
>> In the mean time it would still be handy to know what Matlab does in this
>> case.
>>
>> Philip
>
>
> I believe I'm using it in an environment where excel isn't available.  I get:
>
> Warning: Could not start Excel server for export.
> XLSWRITE will attempt to write file in CSV format.
>> In xlswrite (line 174)

It is able to create a file.csv, and thus both write attempts return 1