Altair SLC can read Excel spreadsheets, but can it read OpenDocument spreadsheets (*.ods)?

Philip_Holland
Philip_Holland Altair Community Member
in Community Q&A

Altair SLC can read Excel spreadsheets, but can it read OpenDocument spreadsheets (*.ods)?

Since installing OpenOffice.org/LibreOffice for office documents I have only had to use Excel files on client sites. OpenDocument spreadsheets (*.ods) are compressed XML file collections similar to *.xlsx files, so reading them should not be a major problem. In fact I wrote a paper in 2004 on how a SAS program could read a StarOffice Calc file "Help, I’ve Received a Spreadsheet File from StarOffice Calc…..!", and have since tweaked that code a little to read *.ods files (see my book "SAS Programming Experiences: A How-To Guide from a Power SAS User" for details).

All referenced items are available on my blog site.

Tagged:

Best Answers

  • Nico Chart_21517
    Nico Chart_21517
    Altair Employee
    Answer ✓

    Hi Phil,

    I have submitted it as an Enhancement Suggestion for you. Unfortunately it is currently marked as not being on our roadmap for development, sadly.

    Nico

  • Philip_Holland
    Philip_Holland Altair Community Member
    Answer ✓

    Hi @Nico Chart_21517

    I have found that ODBC is not the way to approach this problem, so I will concentrate on publishing my "Advanced Altair SLC" book, which will include a SAS program that can extract data sets from OpenDocument spreadsheets.

    Thanks…………Phil

Answers

  • Nico Chart_21517
    Nico Chart_21517
    Altair Employee

    Hi Philip,

    Unfortunately current versions of SLC are not able to read OpenDocument spreadsheets.

    We'll have to take this as an Enhancement Suggestion!

    Nico

  • Philip_Holland
    Philip_Holland Altair Community Member

    Hi @Nico Chart_21517 ,

    I will investigate whether ODBC will allow me to read OpenDocument spreadsheets instead.

    However, I would welcome this feature being put forward as an Enhancement Suggestion, particularly as there are an increasing number of LibreOffice users in Europe, and the SAS Institute have been less than enthusiastic to support them!

    Thanks……….Phil

  • Philip_Holland
    Philip_Holland Altair Community Member

    Hi @Nico Chart_21517,

    Do I have to submit this request as an Enhancement Suggestion, or do you?

    ……….Phil

  • Nico Chart_21517
    Nico Chart_21517
    Altair Employee
    Answer ✓

    Hi Phil,

    I have submitted it as an Enhancement Suggestion for you. Unfortunately it is currently marked as not being on our roadmap for development, sadly.

    Nico

  • Philip_Holland
    Philip_Holland Altair Community Member
    Answer ✓

    Hi @Nico Chart_21517

    I have found that ODBC is not the way to approach this problem, so I will concentrate on publishing my "Advanced Altair SLC" book, which will include a SAS program that can extract data sets from OpenDocument spreadsheets.

    Thanks…………Phil

Categories