Convert excel document (xls) to a plist

Posted by John on Stack Overflow See other posts from Stack Overflow or by John
Published on 2009-10-09T20:55:54Z Indexed on 2010/04/28 23:57 UTC
Read the original article Hit count: 1142

Filed under:

iphone

|

plist

|

xls

I have a pretty straightforward excel document in which I need to use the data in an iPhone app. The xls document has 6 columns, 200 plus rows.

I would like to create a plist from the xls document and other than manual copy/paste, is there a means to convert one to the other?

Anyone written a macro on the excel side or a utility (perl, etc) to make such a conversion?

Thanks

John iPhoneDevTips

© Stack Overflow or respective owner

Related posts about iphone

iphone - direct link to iPhone review form from inside iphone

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to link directly to the review link of one of my Apps. I know that it is possible because Appirater did it in the past, but some change in iTunes turned the API down. Appirater uses this URL NSString *templateReviewURL = @"itms-apps://itunes.apple.com/WebObjects/MZStore.woa/wa/viewContentsUserReviews… >>> More
Buy iPhone 4 Without Contract: $599 (AT&T) and $699 (Verizon)

as seen on Tech Dreams - Search for 'Tech Dreams'
Purchasing iPhone without a contract is a good option when you are planning to gift it to someone or going to use it outside US. Both AT&T and Verizon lets you iPhone 4 without a contract but this information is buried deep under blurred text in FAQs and agreements. Here is the pricing… >>> More
Is it possible to download and run IPhone apps on an IPhone emulator

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am tasked to provide an IPhone client app for our SaaS website. I have never written an IPhone application, nor do I have an IPhone at the moment. Before I can decide whether or not I want to do this myself or outsource this, I'd like to try a few apps myself to get a feeling for the UI. Is… >>> More
iPhone web app from dashcode rss feed template works deployed on simulator but not on iphone

as seen on Stack Overflow - Search for 'Stack Overflow'
iPhone web app from dashcode rss feed template works deployed on simulator but not on iphone. The web app is deployed at; http://www.alila.se/wordpress/index.html If i run the simulator and enter that adress, it fetches the rss feed and displays it. Everything fine. When i enter the adress into… >>> More
Problem running iPhone application on iPhone from Xcode (and in Instruments)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I have a problem running one application on the iPhone from Xcode (or Instruments). When I try to run the app I get the error message Failed to upload XXX.app in the bottom left corner of Xcode. The strange thing is it actually uploaded the app to the iPhone but it doesn't start it (after this… >>> More

Related posts about plist

Update a tableView with a plist took from another table

as seen on Stack Overflow - Search for 'Stack Overflow'
Background: I have a tab bar application, which has a tableView as the "heart" of the app. It loads data from a plist and, through a button that checks if there are any updates on the remote plist file, updates the local plist with the remote contents. Then, i have another tableView, that should… >>> More
Java Plist XML Parsing

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone, I'm parsing a (not well formed) Apple Plist File with java. My Code looks like this: InputStream in = new FileInputStream( "foo" ); XMLInputFactory factory = XMLInputFactory.newInstance(); XMLEventReader parser = factory.createXMLEventReader( in ); while (parser.hasNext()){… >>> More
Can I create a custom plist structure definition?

as seen on Stack Overflow - Search for 'Stack Overflow'
When editing plist files in XCode, it can detect the type of plist and show human-readable strings to make it more easy to edit the file. The Info.plist, for example. Thanks to This question, I found the (or a) place where it stores that structure definition, as InfoPlistStructDefs.xcodeplugin.… >>> More
How to create xml plist for Xcode from Excel spreadsheet

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a spreadsheet, the contents of which I would like to include as an xml plist in my Xcode project. However, I can't figure out how to actually perform the export from Excel and the import into Xcode. Any help would be greatly appreciated please. >>> More
Saving a single NSMutableDictionary in a plist

as seen on Stack Overflow - Search for 'Stack Overflow'
I have one dictionary I need to save into a plist. The paletteDictionary always returns nil: - (void)saveUserPalette:(id) sender { [paletteDictionary setObject:matchedPaletteColor1Array forKey:@"1"]; NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask… >>> More