http://code.activestate.com/recipes/langs/python/tags/meta:requires=xlrd/2011-01-21T17:43:35-08:00ActiveState Code Recipes2011-01-21T17:43:35-08:00Chris Wolfhttp://code.activestate.com/recipes/users/4173108/http://code.activestate.com/recipes/577550-custom-import-script-for-salesforce/

<p style="color: grey"> Python recipe 577550 by <a href="/recipes/users/4173108/">Chris Wolf</a> (<a href="/recipes/tags/csv/">csv</a>, <a href="/recipes/tags/dataloader/">dataloader</a>, <a href="/recipes/tags/excel/">excel</a>, <a href="/recipes/tags/import/">import</a>, <a href="/recipes/tags/salesforce/">salesforce</a>). Revision 2. </p> <p>Normally you should try to use the Salesforce import Wizard or Apex Data Loader for importing. This script demonstrates that programmatic import can handle complex conditional logic that the Import Wizard or Data Loader cannot anticipate.</p>

2008-02-14T00:39:22-08:00Philip Kromerhttp://code.activestate.com/recipes/users/552075/http://code.activestate.com/recipes/546518-simple-conversion-of-excel-files-into-csv-and-yaml/

<p style="color: grey"> Python recipe 546518 by <a href="/recipes/users/552075/">Philip Kromer</a> (<a href="/recipes/tags/files/">files</a>). </p> <p>Takes an excel file, dumps out a series of CSV files (one for each sheet, named for the file and sheet) and a YAML file (an array of sheets, each sheet a dict containing the table_name and the table_data, a 2-d array of cell values).</p> <p>Inspired by Bryan Niederberger's "Easy Cross Platform Excel Parsing With Xlrd", <a href="http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/483742" rel="nofollow">http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/483742</a> As opposed to his code, this script makes no attempt to understand the structure of the sheet (look for header cells, etc) -- it simply reads, converts, dumps.</p>

2006-04-07T22:45:51-07:00Bryan Niederbergerhttp://code.activestate.com/recipes/users/2843232/http://code.activestate.com/recipes/483742-easy-cross-platform-excel-parsing-with-xlrd/

<p style="color: grey"> Python recipe 483742 by <a href="/recipes/users/2843232/">Bryan Niederberger</a> (<a href="/recipes/tags/ui/">ui</a>). Revision 3. </p> <p>Easily extract data from microsoft excel files using this wrapper class for xlrd (<a href="http://www.lexicon.net/sjmachin/xlrd.htm" rel="nofollow">http://www.lexicon.net/sjmachin/xlrd.htm</a>). The class allows you to create a generator which returns excel data one row at a time as either a list or dictionary. I found this very handy for easily pulling in a variety of excel files without having to deal with COM calls or even needing to have windows.</p>