How to read excel file using Objective C?

By sanjeev at Tue, Jan 12 2010 5:43am |

Is there any library available for reading excel files using objective c?

‹ Analytical formulas for kite design? Presentations off of an iPad ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Wed, 2010-01-13 02:52 — Pascal

Workaround: CSV

Not exactly an answer to your question, but I have people send me CSV exports from their Excel files. Drew has posted an approach to parsing CSV in Obj-C here on MacResearch, just in case your search for an Excel Library stays unfruitful.

Wed, 2010-01-13 03:56 — sanjeev

Thanks for your

Thanks for your suggestion.
But in that case i have to convert Excel to CSV. I want my iphone application to do that. Is there any way to do that? I mean is there any tool or component available to do that which i can incorporate into my application and it can give me CSV export from a particular excel file?

Wed, 2010-01-20 06:28 — 11011001

Mac Only Solution

This will not help you on the iPhone, but for others out there who need to do this on the Mac, I had success with http://poi.apache.org/

I had to use JNI to control the Java from Objective-C. From there I converted it to a CSV like format, and used NSString to do the rest of the work. The JNI calls were cumbersome, hence why I used CSV.

Fri, 2010-02-05 22:56 — theundergod

JNI Resources

I cannot seem to find anything on how to properly us JNI. Would you happen to know of any decent resources? I am just trying to integrate a java class I have that reads and excel file and just gathers the appropriate information. There is no file manipulation.

Any help you can provide would be fantastic. Thank you!

Wed, 2010-02-10 20:36 — theundergod

Micrsoft Excel for Mac

You can buy MS Office for Mac in which case you would feel right at home. I have Office for Mac and it works wonderfully. It's a MS product and works and feels the same on either PC or Mac.