Re: xlswrite : create xls with several worksheet

[Philip Nienhuis]

Nicholas Jankowski wrote:
> 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.
>
> personally, I think these are separate bugs.
>
> 1 - xlswrite gets a non-empty filename (his last example did provide a
> valid filename), but because the folder doesn't exist it fails to
> create the file, produces no error, and returns a 1, which is supposed
> to mean a successful write operation.
>
> 2 - xlswrite accepts an empty filename... and other strange things ensue.

I managed to try with Matlab (note: "testsubdir\" is nonexistent):

>>  xlswrite ('testsubdir\test.xlsx', rand (3), 'Sh_A', 'B3:D5')
Error using xlswrite (line 219)
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: SaveAs method of Workbook class failed
Help File: xlmain11.chm
Help Context ID: 0

I'll look into fixing the issues soon.

Thanks,

Philip