Hi, While finishing more complete xlsread and xlswrite functions for Octave using the COM interface in the Windows package, I found that I get COM errors when the requested data range in Excel worksheets contain numeric values formatted as date or time strings. I get:
warning: cannot convert COM variant of type `7' to octave object for each encountered date formatted non-empty cell, followed by error: octave_base_value::resize (): wrong type argument `<unknown type>' As these are COM errors I suspect the Windows package contains a bug in the sense that Octave gets confused by the date formatting. Formatting the relevant cells beforehand as numeric data avoids these COM errors, so this is no real show stopper. But it IS a bit inconvenient when processing lots of spreadsheets from third parties. BTW Comparing this with Matlab r2007a at my employer's office, I saw that Matlab converts date formatted cells to text strings(?), consistent with http://www.mathworks.com/access/helpdesk/help/techdoc/index.html?/access/helpdesk/help/techdoc/ref/xlsread.html&http://www.google.com/search?q=Matlab+Excel+date+formatted+cell&sourceid=mozilla-search&start=0&start=0&ie=utf-8&oe=utf-8&client=mozilla&rls=org.mozilla:en-US:unofficial I've played around with English & Dutch Excel versions, to no avail - Excel language version makes no difference. FYI: Excerpt of "pkg list": windows *| 1.0.8 ..\Octave\3.2.0_gcc-4.3.0\share\octave\packages\windows-1.0.8 Octave 3.2.0 compiled for MingW (also tried 3.2.2 with same results) Windows XP SP2 & WinXP SP3 US-English Thanks, Philip ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Octave-dev mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/octave-dev
