Re: xlswrite : create xls with several worksheet

[Nicholas Jankowski]

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)