3

I have Excel file with table ~100x100 and need to get access to this values from iOS app. enter image description here

At first, I've try to make json in Mr.DataConverter and then it's not a problem to read to array. But! Some float values didn't recognized properly, and I'd got numbers without quotes: enter image description here

At the time other parsed correctly! So, from this moment I can't parse my Json string to NSArray.

The question is: How to convert xls to json, OR How to put and retrieve the values in iOS device?

Thanks.

HotJard
  • 4,598
  • 2
  • 36
  • 36
  • 3
    Export to CSV then [parse the CSV](http://stackoverflow.com/questions/3344628/where-can-i-find-a-csv-to-nsarray-parser-for-objective-c). – Joe Apr 10 '13 at 17:56

3 Answers3

1

You can use the DHlibxls iOS Framework and simply pull the .xls file into your app, then read and process with that framework. The framework is based on the open source libxls library on SourceForge, and has a non-attributed BSD license.

David H
  • 40,852
  • 12
  • 92
  • 138
0

Alternative: If possible use excel file in formate: tab delimited-text-file. That solve all your problem. Easy to open text file in iOS with file manager/c++.

convert-an-excel-spreadsheet-to-a-tab-delimited-text-file

Guru
  • 21,652
  • 10
  • 63
  • 102
0

I recommend exporting the Excel spreadsheet to CSV and then using a proper CSV parser to parse the data. If you run into any issues then there is likely an issue in the spreadsheet that you would need to fix.

Community
  • 1
  • 1
Joe
  • 56,979
  • 9
  • 128
  • 135