excel to plist

Joined
Apr 22, 2016
Messages
1
Reaction score
0
Hello, I'm very new to the game here, any help would be greatly appreciated. I am generating a quiz using a platform on Xcode. With roughly 7,000 questions that I have pre-generated in excel format I am trying to find a script which can convert my simple excel spreadsheet into appropriate plist. My spreadsheet is as simple as column A for the question, then column B,C,D,E for each question. Each row would then be a new question. Here's what I'm looking to have the plist turn out as: https://imgur.com/CMUFJ8Y
If anyone could point me in the general direction of how to figure this out I'd be so grateful!
 

Cory Cooper

Moderator
Joined
May 19, 2004
Messages
11,106
Reaction score
497
Hello and welcome.

This is far above my experience and knowledge level.

-Are you looking for some form of AppleScript/Automator workflow to extract the answers from the Excel document?
-Are you actually writing code for an application in Xcode to perform this?
-Does the final output need to be a plist, which is usually a Mac application preference file?

C
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top