Make Great Spreadsheets

Casey West (Casey West Consulting)
Perl
Location: Meeting Room B2
Average rating: ****.
(4.17, 6 ratings)

Spreadsheet::WriteExcel is a great Perl module for generating useful Spreadsheets with multiple worksheets, cell formatting, and data validation. You can use these spreadsheets for simple reporting, of course, or you can use them as an alternate interface to a data heavy application. In this talk we’ll learn a handful of techniques for making a custom, usable spreadsheet that your users can download and fill in. The can they can upload a completed spreadsheet to load data into the app.

This talk will focus on advanced techniques available with Spreadsheet::WriteExcel. We will also take a quick look at techniques for making spreadsheets available for download from a web application, as well as options for parsing and interpreting uploaded spreadsheets. After this talk you will be able to create usable, interactive spreadsheets with Perl.

Photo of Casey West

Casey West

Casey West Consulting

Casey West lives in Pittsburgh with his wife and three awesome kids. When he’s working for CombineNet people call him a Lead Product Engineer, Infrastructure and Architecture which means he writes code and tries to make the world a better place for his team.

Comments on this page are now closed.

Comments

Picture of Timothy Ace
Timothy Ace
07/23/2009 5:08pm PDT

A great job putting together a presentation at the last minute with your computer dying.

  • Intel
  • Microsoft
  • Google
  • SourceForge.net
  • Sun Microsystems
  • Facebook
  • Gear6
  • Kaltura
  • Liferay
  • MindTouch
  • MySpace.com
  • Novell, Inc.
  • Open Invention Network
  • Rackspace Cloud
  • Schooner Information Technology
  • Silicon Mechanics
  • Symbian Foundation
  • Twilio
  • WSO2
  • Yabarana Corporation

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the OSCON Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

OSCON Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the OSCON newsletter (login required)

Contact Us

View a complete list of OSCON contacts