excel to plist

Discussion in 'Shell Programming' started by Ragnar117, Apr 22, 2016.

  1. Ragnar117

    Ragnar117 New Member

    Apr 22, 2016
    Likes Received:
    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!
    Ragnar117, Apr 22, 2016
    1. Advertisements

  2. Ragnar117

    Cory Cooper Moderator

    May 19, 2004
    Likes Received:
    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?

    Cory Cooper, Apr 24, 2016
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.