Post thumbnail of Perl Spreadsheet::ParseExcel to convert Excel Spreadsheets
14 September 2009
Continue reading Perl Spreadsheet::ParseExcel to convert Excel Spreadsheets

Perl Spreadsheet::ParseExcel to convert Excel Spreadsheets

#!/usr/bin/perl -w
# For each tab (worksheet) in a file (workbook),
# spit out columns separated by “,”,
# and rows separated by c/r.
use Spreadsheet::ParseExcel;
use strict;
my $filename = shift || “Book1.xls”;
my $e = new Spreadsheet::ParseExcel;
my $eBook = $e->Parse($filename);
my $sheets = $eBook->{SheetCount};
my ($eSheet, $sheetName);
foreach my $sheet (0 .. $sheets - 1) {

Post thumbnail of Install bugzilla on Fedora 10 without using perl CPAN
26 February 2009
Continue reading Install bugzilla on Fedora 10 without using perl CPAN

Install bugzilla on Fedora 10 without using perl CPAN

This howto will get bugzilla with ALL of the optional modules installed on Fedora 10. If you just want a barebones bugzilla up and running, you might want to read the whole thing and then just look for the required parts. Otherwise, you can follow me through the install and end up with all the bells and whistles.

The checksetup.pl script will tell you what you’re missing and what you need to install to get bugzilla up and running. But the problem is it pushes you to use perl’s package management to build the perl modules which may or may not work. I think it’s best to use YUM to install and manage all of your packages and not to mix and match both. This will help to avoid conflicting packages and seemingly random complaints of a package missing when it’s not.

Share this:
  • Digg
  • Facebook
  • Reddit
  • LinkedIn
  • Google Bookmarks
Post thumbnail of Grep IP addresses from ifconfig
5 February 2009
Continue reading Grep IP addresses from ifconfig

Grep IP addresses from ifconfig

Here’s a bunch of ways to get the ip addresses for all your network interfaces using ifconfig.

Share this:
  • Digg
  • Facebook
  • Reddit
  • LinkedIn
  • Google Bookmarks
Powered by Wordpress   |   Lunated designed by ZenVerse