PDA

View Full Version : Excel XLS file into plist




Avicenna
May 3, 2011, 09:42 AM
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
May 3, 2011, 10:29 AM
Do you need to do this periodically or as an input? Or just one off?

Avicenna
May 3, 2011, 11:34 AM
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
May 3, 2011, 11:52 AM
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.