Results 1 to 10 of 10
  1. #1
    excel data import on Mac OS X

    Member Since
    Nov 06, 2007
    Posts
    4
    excel data import on Mac OS X
    I am looking for a way to import data from excel on Mac OS X.
    Development platform - c++ (xcode).
    Can anybody point me to the way how it may by done on Mac OS?
    Any help is appreciated.

    Best regards,
    Denis

  2. #2
    excel data import on Mac OS X

    Member Since
    Dec 24, 2006
    Location
    N. Ireland
    Posts
    901
    Specs:
    Mac Pro 2xQuad core 2.8GHZ
    Is the excel data saved as CSV format?

    I dont code in C++ myself but if it is, just read the data in line by line and use a string tokeniser (or C++ equivalent) to get at each individual value

  3. #3
    excel data import on Mac OS X

    Member Since
    Nov 06, 2007
    Posts
    4
    No, files are in native excel format, not CSV.

  4. #4
    excel data import on Mac OS X

    Member Since
    Dec 24, 2006
    Location
    N. Ireland
    Posts
    901
    Specs:
    Mac Pro 2xQuad core 2.8GHZ
    Quote Originally Posted by dtkachov View Post
    No, files are in native excel format, not CSV.
    Again not sure about C++ but in Java you can make a JDBC connection to an excel spreadsheet and treat it as if it was a database and therefore read the rows of data and manipulate them as you please.

    I could be wrong but i think i read that xcode can be used for java development, and given that its syntax is very similar to C++ maybe you should consider adding Java to your list of skills?

  5. #5
    excel data import on Mac OS X

    Member Since
    Nov 06, 2007
    Posts
    4
    Thank you for reply.
    I don't mind about learning Java or anything else but this must be a module in huge project. And it is necessary to write module that will import dfata from excel files. It will not be very good (from a lot of points) if one of modules in the projects will be build using other platform.
    So, it is expected to be c++.

  6. #6
    excel data import on Mac OS X

    Member Since
    Dec 24, 2006
    Location
    N. Ireland
    Posts
    901
    Specs:
    Mac Pro 2xQuad core 2.8GHZ
    Well fire up google, im sure there is an equivalent way of reading data from an excel file using C++, its not an uncommon thing to want to do now is it.

  7. #7

  8. #8
    excel data import on Mac OS X

    Member Since
    Nov 06, 2007
    Posts
    4
    Thank you, but this is actually samples for windows. That is not a problem to do it under windows (I did it actually).
    A question was about Mac OS.
    Obviously, before posting these questions I have googgled around. Founding nothing I have posted message here.

    Any ideas about how excel file might be read programatically under Mac OS ?

  9. #9
    danielb
    Guest
    Here is a link to some c code that converts excel to html. You may be able to modify it to complete the task.

    http://chicago.sourceforge.net/xlhtml/

  10. #10
    excel data import on Mac OS X

    Member Since
    Dec 11, 2007
    Posts
    6
    Save Excel data to CSV Fomate?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Export Outlook for Mac Data and Import in Mac Mail
    By L12-George in forum OS X - Operating System
    Replies: 4
    Last Post: 07-16-2014, 05:42 AM
  2. Excel Mac Data Connection Disabled
    By MikeV99 in forum OS X - Apps and Games
    Replies: 0
    Last Post: 03-15-2012, 07:56 AM
  3. data analysis in microsoft excel 2008 for mac
    By bonvoyage in forum OS X - Apps and Games
    Replies: 3
    Last Post: 01-07-2010, 10:07 AM
  4. attempting to import an excel file into my iCal
    By mac-newb in forum OS X - Apps and Games
    Replies: 0
    Last Post: 04-15-2009, 11:23 AM
  5. Excel Data Validaton
    By dekalaked in forum OS X - Apps and Games
    Replies: 0
    Last Post: 04-18-2008, 02:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •