Excel file into NSArray
I have an Excel file whose data I need to us开发者_如何学Pythone as a source for my table view. How can I convert the .xls into a plist file so I can parse it into NSArray? Does the Numbers app in iWork suite have this option?
Thanks.
The solution I’ve used in the past is to export the .xls as a tab-delimited file and then use e.g. a python script to convert from that to a plist. It’s pretty easy, though providing sample code to do it is difficult because it’s pretty problem-specific.
If you can export it as a CSV or TSV file, you can use my CHCSVParser to do all of the parsing work for you.
精彩评论