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

 
 

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

Submitted by:  Avinoam Kalma <avinoam>
Submitted on:  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:  Philip Nienhuis <philipnienhuis>
Originator Name:  Avinoam Open/Closed:  Closed
Release:  dev Operating System:  Any

Add a New Comment (Rich Markup)
   

You are not logged in

Please log in, so followups can be emailed to you.

 

( 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.

Thanks!

Philip Nienhuis <philipnienhuis>
Project MemberIn charge of this item.
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: 

Thanks,

just a comment:

Examples:
           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 MemberIn charge of this item.
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 MemberIn charge of this item.
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 MemberIn charge of this item.
Wed 28 Jan 2015 06:47:32 PM UTC, comment #2: 

Thanks.

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: 

Confirmed.

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 MemberIn charge of this item.
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:
   
   
Comment:
   

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)
  •  

    Do you think this task is very important?
    If so, you can add your encouragement to it.
    This task has 0 encouragements so far.

    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.5