Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Write2Excel error message
Date: Thu, 24 Sep 2009 20:37:06 +0000 (UTC)
Organization: AIR Worldwide Corp
Lines: 33
Message-ID: <h9gl9i$m6m$1@fred.mathworks.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: webapp-05-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1253824626 22742 172.30.248.35 (24 Sep 2009 20:37:06 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Thu, 24 Sep 2009 20:37:06 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 1076536
Xref: news.mathworks.com comp.soft-sys.matlab:572745


Somehow I got the error message:

Write2Excel( fileName, 0, 'sheetname', sheet, ...
                'A1',  {hurrName}, ...
                'A15', tbl_1, ...
                'A30', tbl_2, ...
                'A46', tbl_3, ...
                'A62', tbl_4, ...
                'A78', tbl_5, ...
                'A95', tbl_6, ...
                'A111',tbl_7, ...
                'D9',  tbl_8 );

??? Error using ==> Write2Excel at 157
Sorry...unable to open file ./output/loss_summary.xlsx

File does exist, so I don't know what the error was for. 

exist( './output/loss_summary.xlsx')
ans =
     2

I would appreciate if someone can help me with this issue. Currently I am using XLSWRITE, but it doesn't allow multiple cell writing.  Thanks,

xlswrite(fileName, {hurrName}, sheet, 'A1')
xlswrite(fileName, tbl_1, sheet, 'A15');
xlswrite(fileName, tbl_2, sheet, 'A30');
xlswrite(fileName, tbl_3, sheet, 'A46');
xlswrite(fileName, tbl_4, sheet, 'A62');
xlswrite(fileName, tbl_5, sheet, 'A78');
xlswrite(fileName, tbl_6, sheet, 'A95');
xlswrite(fileName, tbl_7, sheet, 'A111');
xlswrite(fileName, tbl_8, sheet, 'D9');