Home
Program
- OSCON Schedule
- Sessions
  - Administration
  - Apache
  - Business
  - Cloud Computing
  - Databases
  - Design & Usability
  - Desktop Applications
  - Emerging Topics
  - Fundamentals
  - Government
  - Java
  - Legal
  - Linux
  - Mobile
  - Mozilla
  - People
  - Perl
  - PHP
  - Products & Services
  - Programming
  - Python
  - Ruby
  - Security
  - Ubuntu
  - Web Applications
- Tutorials
- Keynotes
- Speakers
- Events
- What's FREE at OSCON
- Birds of a Feather Sessions
- Speaker Presentation Files
About
Expo
Connect

Make Great Spreadsheets

11:35am–12:20pm Thursday, 07/23/2009

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.

Casey West

Pivotal

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.

Website

Comments on this page are now closed.

Comments

Timothy Ace

07/23/2009 10:08am PDT

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

Schedule views

Diamond Sponsors

Platinum Sponsor

Gold Sponsors

Silver Sponsors

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