Popular recipes by Philip Kromer http://code.activestate.com/recipes/users/552075/2008-02-14T00:39:22-08:00ActiveState Code RecipesSimple conversion of excel files into CSV and YAML (Python) 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> Dump all the attributes of an object (Python) 2002-07-05T23:05:49-07:00Philip Kromerhttp://code.activestate.com/recipes/users/552075/http://code.activestate.com/recipes/137951-dump-all-the-attributes-of-an-object/ <p style="color: grey"> Python recipe 137951 by <a href="/recipes/users/552075/">Philip Kromer</a> (<a href="/recipes/tags/debugging/">debugging</a>). </p> <p>Print a nicely formatted overview of an object, including _everything_ in the object's `dir'. This is great when programming interactively.</p> <p>More comprehensive than help(), prettier than dir().</p>