iOS Excel XLS file into plist

[Avicenna]

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

 

[Hansr]

Do you need to do this periodically or as an input? Or just one off?

 

[Avicenna]

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.

 

[robbieduncan]

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.