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

User: "Philip_Holland"
Philip_Holland
Altair Community Member

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.

Find more posts tagged with

SLC
XML
Excel
open data
Sort by:
1 - 2 of 21
    User: "Nico Chart_21517"
    Nico Chart_21517
    Altair Employee
    Accepted 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

    View in context
    User: "Philip_Holland"
    Philip_Holland
    Altair Community Member
    OP
    Accepted 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

    View in context
Quick Links