http://code.activestate.com/recipes/tags/excel/views/2015-12-16T22:28:39-08:00ActiveState Code Recipes2015-11-22T22:15:25-08:00Vasudev Ramhttp://code.activestate.com/recipes/users/4173351/http://code.activestate.com/recipes/579128-convert-microsot-excel-xlsx-to-pdf-with-python-and/

<p style="color: grey"> Python recipe 579128 by <a href="/recipes/users/4173351/">Vasudev Ram</a> (<a href="/recipes/tags/excel/">excel</a>, <a href="/recipes/tags/formats/">formats</a>, <a href="/recipes/tags/openpyxl/">openpyxl</a>, <a href="/recipes/tags/pdf/">pdf</a>, <a href="/recipes/tags/python/">python</a>, <a href="/recipes/tags/xlsx/">xlsx</a>, <a href="/recipes/tags/xtopdf/">xtopdf</a>). </p> <p>This recipe shows how the basics of to convert the text data in a Microsoft Excel file (XLSX format) to PDF (Portable Document Format). It uses openpyxl to read the XLSX file and xtopdf to generate the PDF file.</p>

2008-06-22T18:33:50-07:00Wai Yip Tunghttp://code.activestate.com/recipes/users/2382677/http://code.activestate.com/recipes/573471-update-stock-quote-using-yahoo-finance-web-service/

<p style="color: grey"> Python recipe 573471 by <a href="/recipes/users/2382677/">Wai Yip Tung</a> (<a href="/recipes/tags/excel/">excel</a>, <a href="/recipes/tags/math/">math</a>). Revision 2. </p> <p>This script update the stock quote on your spreadsheet by fetching the latest quote from Yahoo!Finance web services. It uses the pywin32 library to update the cells on an Excel spreadsheet.</p>

2015-02-22T10:42:18-08:00Vasudev Ramhttp://code.activestate.com/recipes/users/4173351/http://code.activestate.com/recipes/579026-convert-excel-to-pdf-with-xlwings-and-xtopdf/

<p style="color: grey"> Python recipe 579026 by <a href="/recipes/users/4173351/">Vasudev Ram</a> (<a href="/recipes/tags/excel/">excel</a>, <a href="/recipes/tags/pdf/">pdf</a>, <a href="/recipes/tags/pdfwriter/">pdfwriter</a>, <a href="/recipes/tags/reportlab/">reportlab</a>, <a href="/recipes/tags/xlwings/">xlwings</a>, <a href="/recipes/tags/xtopdf/">xtopdf</a>). </p> <p>This recipe shows how to get the text content from an Excel file and convert it to PDF, using the xlwings and xtopdf Python libraries. It also shows how to create an Excel file programmatically using xlwings.</p>

2015-12-16T22:28:39-08:00Alfred Wanghttp://code.activestate.com/recipes/users/4193275/http://code.activestate.com/recipes/579137-read-all-excel-cells-in-all-sheets-without-telling/

<p style="color: grey"> Python recipe 579137 by <a href="/recipes/users/4193275/">Alfred Wang</a> (<a href="/recipes/tags/excel/">excel</a>). </p> <p>I constantly need to read an excel file. However, it seems there is no built in functions in xlwings to automatically read all cells without telling xlwings the range you want to read. So I wrote this function to achieve this.</p>

2014-09-20T18:45:09-07:00Tomas Nordinhttp://code.activestate.com/recipes/users/4189558/http://code.activestate.com/recipes/578941-spread-sheet-style-column-enumeration-letter-to-nu/

<p style="color: grey"> Python recipe 578941 by <a href="/recipes/users/4189558/">Tomas Nordin</a> (<a href="/recipes/tags/conversion/">conversion</a>, <a href="/recipes/tags/excel/">excel</a>, <a href="/recipes/tags/libreoffice/">libreoffice</a>, <a href="/recipes/tags/python/">python</a>, <a href="/recipes/tags/spreadsheet/">spreadsheet</a>). </p> <p>A post-it suggestion on how to convert "Excel style" notation of columns to a number.</p>

2011-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>

2012-05-22T18:25:21-07:00Garretthttp://code.activestate.com/recipes/users/4181290/http://code.activestate.com/recipes/578142-working-with-excel-indexes/

<p style="color: grey"> Python recipe 578142 by <a href="/recipes/users/4181290/">Garrett</a> (<a href="/recipes/tags/column/">column</a>, <a href="/recipes/tags/columns/">columns</a>, <a href="/recipes/tags/excel/">excel</a>, <a href="/recipes/tags/python/">python</a>). </p> <p>I have had extensive issues working with excel indexies (i.e. 'AA100'). Here is code to convert out of and into all of the indexes.</p> <p>There may be better ways to do this, I don't care anymore. This works.</p>