bugGNU Octave - Bugs: bug #44109, xlswrite does not support xls...


bug #44109: xlswrite does not support xls (documentation)

Submitter:  Avinoam Kalma <avinoam>
Submitted:  Wed 28 Jan 2015 05:11:46 PM UTC
Category:  Octave Forge Package Severity:  3 - Normal
Priority:  5 - Normal Item Group:  Documentation
Status:  Fixed Assigned to:  philipnienhuis
Originator Name:  Avinoam Open/Closed:  * Closed
Release:  * dev Operating System:  * Any
Fixed Release:  None Planned Release:  None
* Mandatory Fields

Add a New Comment (Rich Markup)

Comment Type & Canned Response:


( Jump to the original submission )

Sun 08 Mar 2015 09:05:14 PM UTC, comment #8: 

Dear Avinoam (is that your first name?), I really should invite you to the (tiny) team of testers for the io package :-)

As to:
Examples: I dreamt of having a few more, but never bothered. I'll either come up with another, or remove the 's' in io-2.2.8

.xlsx : no, xlswrite can write .xls as well (provided support SW is present). It can even write .wk1, .uof, etc. (see the NEWS for older io versions), depending of support SW

As to the changeset, better put it up on the patch tracker.


Philip Nienhuis <philipnienhuis>
Project Member
Sun 08 Mar 2015 08:06:05 PM UTC, comment #7: 

changeset attached

(file #33295)

Avinoam Kalma <avinoam>
Project Member
Sun 08 Mar 2015 07:33:41 PM UTC, comment #6: 


just a comment:

           status = xlswrite ...
                     ('test4.xls', 'arr', 'Third_sheet', 'C3:AB40');

Shouldn't it be "example", and "test4.xlsx"?
What about changeing of-io.mk? should I prepare a changeset?

Avinoam Kalma <avinoam>
Project Member
Sun 08 Mar 2015 11:40:57 AM UTC, comment #5: 

Yesterday I've uploaded io-2.2.7 to the package release tracker.
Closing report

Philip Nienhuis <philipnienhuis>
Project Member
Sun 15 Feb 2015 05:02:48 PM UTC, comment #4: 

I think I've fixed the docs now (in mercurial); but I'll leave this report open as I'm busy with streamlining io package messages anyway (some of them are confusing)

Who knows what improvements are possible :-)

Philip Nienhuis <philipnienhuis>
Project Member
Wed 28 Jan 2015 08:27:09 PM UTC, comment #3: 

I don't think we can reliably write .xlsm or .xlsb. They add additional complexity. Same for reading.

Philip Nienhuis <philipnienhuis>
Project Member
Wed 28 Jan 2015 06:47:32 PM UTC, comment #2: 


BTW, in xlsopen.m

  [sfxpos, ~, ~, ext] = regexpi (filename, '(\.xlsx?|\.gnumeric|\.ods|\.csv)');

Shouldn't in be \.xls?, because you want to find
 case {".xlsx", ".xlsm", ".xlsb"} 

Avinoam Kalma <avinoam>
Project Member
Wed 28 Jan 2015 06:07:05 PM UTC, comment #1: 


W/o Excel or Java-based support libs there's only .xlsx, .ods and .gnumeric.

Agreed, one can argue about the documentation and the error messages, but there's simply no .xls I/O support without external dependencies. Unless someone finds a Java/COM/whatever-less substitute that can be implemented in Octave.

I'll fix the docs & messages but that's about all I can do.

Re-titling bug report, Item group => Incorrect documentation

Philip Nienhuis <philipnienhuis>
Project Member
Wed 28 Jan 2015 05:11:46 PM UTC, original submission:  

Using io package:

>> a=1;
>> xlswrite ('a.xls',a);
Creating file a.xls
Detected XLS interfaces: None.
warning: xlsopen.m: no support for spreadsheet I/O

warning: called from
    xlsopen at line 365 column 9
    xlswrite at line 198 column 9
>> xlswrite ('a.xlsx',a);
Creating file a.xlsx
Detected XLS interfaces: >>

xlswrite supports xlsx but not xls.
Note that there a missing newline at the end (any maybe the word
None, if the are no XLS interfaces detected).

Avinoam Kalma <avinoam>
Project Member


(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:

Attached Files
file #33295:  of-io.diff added by avinoam (750B - application/octet-stream)


Depends on the following items: None found

Items that depend on this one: None found


Carbon-Copy List
  • -email is unavailable- added by avinoam (Submitted the item)

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only project members can vote.





    Follow 8 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2015-03-08 avinoam Attached File- Added of-io.diff, #33295
    2015-03-08 philipnienhuis StatusIn Progress Fixed
        Open/ClosedOpen Closed
    2015-02-06 philipnienhuis StatusConfirmed In Progress
    2015-01-28 philipnienhuis Item GroupIncorrect Result Documentation
        StatusNone Confirmed
        Assigned toNone philipnienhuis
        Summaryxlswrite does not support xls xlswrite does not support xls (documentation)

    Back to the top

    Powered by Savane 3.9