Is it possible to import excel file Xcode bundle?

Question

I want to import the excel file in Xcode bundle.

When I click on button then all excel content store in the database then it visible in the table from the database.

What database are you referring to? And are you talking about a read-only Excel file you want to provide with your app? — rmaddy, Aug 20 '15 at 05:09
So then you don't need the Excel file in your app bundle. You need a way to get the data from the Excel file into the SQLite file and the SQLite file will be in your bundle. Correct? — rmaddy, Aug 20 '15 at 05:57
Thanks, But my point is that excel file download from server then it store in the app then all excel content store in the database then it will show in the table. — jaskiratjd, Aug 20 '15 at 06:06
@jaskiratjd i don't much aware about server connection, anyway this may help you http://stackoverflow.com/questions/14274492/ios-how-to-make-soap-request-receive-the-concern-response — Shebin Koshy, Aug 20 '15 at 13:44
You can get the mail attachments in your app easily.. and after getting the file you can read the xls file content using the library i mentioned in my answer — Shebin Koshy, Aug 20 '15 at 13:46
Your question asks about importing an Excel file into the "Xcode bundle". This sounds like something you want to do while building your app. But the comments indicate that you want to download an Excel file at runtime. Those are two vastly different requirements. Please update your question to make it clear what you want to do. — rmaddy, Aug 20 '15 at 14:25

score 0 · Answer 1 · answered Aug 20 '15 at 05:07

Umm, you can use this: https://github.com/davedelong/CHCSVParser BUT you have to store the file as CSV, not XLSX or XLS

Also, you can store this in the bundle, you just have to call to the bundle, something like this:

NSString *fileName = @"theFileName";
NSString *pathToFile =[[NSBundle mainBundle] pathForResource:fileName ofType: @"csv"];

the @"csv" may need to be @"txt", try it with both

score 0 · Answer 2 · edited May 23 '17 at 10:29

0

These stuffs may help u

for read (import) a XLS file https://github.com/dhoerl/DHlibxls its working well

if you need to write (export) a XLS file, u use pods https://cocoapods.org/pods/JXLS its also working

if you need to edit a XLSX file https://github.com/renebigot/XlsxReaderWriter (i'm not sure, because i don't work with it)

If you just need to show the files(XLS/XLSX) to the users, you can use a UIWebView

edited May 23 '17 at 10:29

Community

answered Aug 20 '15 at 05:58

Shebin Koshy

1

Thanks for the answer. but i am using **csv** file instead of xls for data importing in database. – jaskiratjd Aug 21 '15 at 07:19
@jaskiratjd ok. how much u done for that? are u getting file from server or from e-mail? – Shebin Koshy Aug 21 '15 at 07:31
1

csv file getting from server – jaskiratjd Aug 21 '15 at 07:53
@jaskiratjd did u successfully get it from server? – Shebin Koshy Aug 21 '15 at 07:55
1

I'm not tried yet. i did only from bundle but my approach is to fetch csv file from server. – jaskiratjd Aug 21 '15 at 07:58

2 Answers2