Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. [SOLVED] converting a .ods (openoffice spreadsheet) to a flat text file (space delimited)
Forum Updated to NodeBB v4.3 + New Features

[SOLVED] converting a .ods (openoffice spreadsheet) to a flat text file (space delimited)

Scheduled Pinned Locked Moved General and Desktop
2 Posts 1 Posters 4.5k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • V Offline
    V Offline
    vezprog
    wrote on last edited by
    #1

    Hello all,

    As of right now, I am trying to accomplish reading in a .ods spreadsheet, and throwing it into a text file that is space delimited (with respect to the spreadsheet layout).

    First of all, is this possible? I have searched the net a little bit and some have said to "try" using the QXML libraries since a .ods is a zipped xml file. Would this be the best way to approach this? Is there an easier way to access openoffice spreadsheets in Qt4? I just figured id ask so I can use the best/most efficient way possible to do this.

    I have done this with microsoft excel in visual basic on windows and converted to a csv but never with Qt. (I am using Qt4 Creator on Linux)

    Thanks in advance!

    1 Reply Last reply
    0
    • V Offline
      V Offline
      vezprog
      wrote on last edited by
      #2

      I actually figured out a way... i run jodconverter to convert the .ods to a .csv then convert the csv to a text file.

      It may be insufficient...yet it gets the job done with a minimal amount of processing time.

      1 Reply Last reply
      0

      • Login

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Users
      • Groups
      • Search
      • Get Qt Extensions
      • Unsolved