Excel XLS file into plist

Discussion in 'iOS Programming' started by Avicenna, May 3, 2011.

Most Liked Posts
  1. Avicenna, May 3, 2011

    Avicenna macrumors member

    Joined:
    Jul 16, 2009
    #1
    Wirelessly posted (Mozilla/5.0 (iPod; U; CPU iPhone OS 4_2_1 like Mac OS X; en-us) AppleWebKit/533.17.9 (KHTML, like Gecko) Version/5.0.2 Mobile/8C148 Safari/6533.18.5)

    Hi,
    I have an excel file with 100s of rows and I need to use it for uitableview so I need to put it a plist so I can initialize an nsarray with it. So how can I convert this XLS file in
    Plist? Thanks
     
    share
    + Quote Reply
  2. Hansr, May 3, 2011

    Hansr macrumors 6502a

    Joined:
    Apr 1, 2007
    #2
    Do you need to do this periodically or as an input? Or just one off?
     
    share
    + Quote Reply
  3. Avicenna, May 3, 2011

    Avicenna thread starter macrumors member

    Joined:
    Jul 16, 2009
    #3
    Thanks for the input. I am sorry I don't understand what you mean. It's just static data that I would like to display in UITableView but I need it in plist format (much easier just to initialize NSArray with it). I can manually copy paste cells into plist but it would take too much time.
     
    share
    + Quote Reply
  4. robbieduncan, May 3, 2011

    robbieduncan Moderator emeritus

    robbieduncan

    Joined:
    Jul 24, 2002
    Location:
    London
    #4
    Export as some sort of convenient text format (if none of the data has a "," in it the csv). Use perl, sed, awk or another text manipulation program of your choice to turn it into a plist.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page