Excel XLS file into plist

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

  1. Avicenna macrumors member

    Jul 16, 2009
    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)

    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
  2. Hansr macrumors 6502a

    Apr 1, 2007
    Do you need to do this periodically or as an input? Or just one off?
  3. Avicenna thread starter macrumors member

    Jul 16, 2009
    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.
  4. robbieduncan Moderator emeritus


    Jul 24, 2002
    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 This Page