[Octave-bug-tracker] [bug #45996] io package: add named ranges/definedNames

[Andreas Weber]

URL:
  <http://savannah.gnu.org/bugs/?45996>

                 Summary: io package: add named ranges/definedNames
                 Project: GNU Octave
            Submitted by: andy1978
            Submitted on: Fr 18 Sep 2015 12:57:31 GMT
                Category: Octave Forge Package
                Severity: 1 - Wish
                Priority: 5 - Normal
              Item Group: Feature Request
                  Status: None
             Assigned to: None
         Originator Name: 
        Originator Email: 
             Open/Closed: Open
         Discussion Lock: Any
                 Release: other
        Operating System: GNU/Linux

    _______________________________________________________

Details:

xlsx let you define names for cells so that you can use "foo" instead of "B12"
for example.

Since this isn't currently supported in io, I wrote a function to retrieve the
definedNames and insert values. Attached 3 files, run insert_into_xlsx.m to
add some values to wx.xlsx.

This isn't polished yet and I think xlswrite could be extended that it also
accepts names instead of just ranges.

@Philip: What do you think?



    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: Fr 18 Sep 2015 12:57:31 GMT  Name: get_definedNames.m  Size: 748B   By:
andy1978

<http://savannah.gnu.org/bugs/download.php?file_id=34920>
-------------------------------------------------------
Date: Fr 18 Sep 2015 12:57:31 GMT  Name: insert_into_xlsx.m  Size: 435B   By:
andy1978

<http://savannah.gnu.org/bugs/download.php?file_id=34921>
-------------------------------------------------------
Date: Fr 18 Sep 2015 12:57:31 GMT  Name: wb.xlsx  Size: 5kB   By: andy1978

<http://savannah.gnu.org/bugs/download.php?file_id=34922>

    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?45996>

_______________________________________________
  Nachricht gesendet von/durch Savannah
  http://savannah.gnu.org/