PeformIQ Wiki - User contributions [en]

Capacity Forecasting Tool

2007-12-17T22:26:39Z

MatthewBretherton: /* UNIX Packages Required */

= Introduction =

A web based tool to analyse data extracted from various devices via MRTG and generate a capacity forecast.

= Implementation =

MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to export forecasts as Excel Spreadsheets to facilitate what-if analysis.

= Generating Excel Files =

See [[Generating Excel Spreadsheets Programatically]]

= Parsing MRTG Files =

See [[Parsing MRTG Files]]

= Generating Graphs =

Us the Python module matplotlib to generate images for data encapsulated in a MySQL database. Images will be displayed via a web server.

= UNIX Packages Required =

{| style="color:green;background-color:#ffffcc;" cellpadding="5" cellspacing="0" border="1"
! style="background-color:#33ff33;"|Name
! style="color:red;background-color:#33ff33;"|Required by
!style="background-color:#33ff33;"|Download Location
|-
|Apache (2.2)
|style="color:black;background-color:#99ff99;"|Application
|http://httpd.apache.org/
|-
|Python
| style="color:black;background-color:#99ff99;"|Application
|http://www.python.org
|-
|Albatross
|
|http://www.object-craft.com.au/projects/albatross/
|-
|matplotlib
|
|http://matplotlib.sourceforge.com
|-
|numpy
|matplotlib
|http://sourceforge.net/projects/numpy/
|-
|ATLAS
|numpy
|http://sourceforge.net/projects/math-atlas/
|-
|BLAS
|numpy
|
|-
| PERL
|style="color:black;background-color:#99ff99;"|Application
| http://ww.perl.org/
|-
| SpreadSheet::WriteExcel
|
| http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/Spreadsheet/WriteExcel.pm
|-
| Parse::RecDescent
| SpreadSheet::WriteExcel
| http://search.cpan.org/~dconway/Parse-RecDescent-v1.95.1/lib/Parse/RecDescent.pm
|-
| OLE::StorageLite
| SpreadSheet::WriteExcel
| http://search.cpan.org/~jmcnamara/OLE-Storage_Lite-0.15/Storage_Lite.pm
|-
| LWP::UserAgent
|
|http://search.cpan.org/~gaas/libwww-perl-5.808/lib/LWP.pm
|-
| MySQL
|style="color:black;background-color:#99ff99;"|Application
|http://www.mysql.org/
|}

See [http://www.mediawiki.org/wiki/Help:Tables Help onTables]

Capacity Forecasting Tool

2007-12-17T22:26:10Z

MatthewBretherton: /* UNIX Packages Required */

= Introduction =

A web based tool to analyse data extracted from various devices via MRTG and generate a capacity forecast.

= Implementation =

MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to export forecasts as Excel Spreadsheets to facilitate what-if analysis.

= Generating Excel Files =

See [[Generating Excel Spreadsheets Programatically]]

= Parsing MRTG Files =

See [[Parsing MRTG Files]]

= Generating Graphs =

Us the Python module matplotlib to generate images for data encapsulated in a MySQL database. Images will be displayed via a web server.

= UNIX Packages Required =

{| style="color:green;background-color:#ffffcc;" cellpadding="5" cellspacing="0" border="1"
! style="background-color:#33ff33;"|Name
! style="color:red;background-color:#33ff33;"|Required by
!style="background-color:#33ff33;"|Download Location
|- Apache (2.2)
|style="color:black;background-color:#99ff99;"|Application
|http://httpd.apache.org/
|-
|Python
| style="color:black;background-color:#99ff99;"|Application
|http://www.python.org
|-
|Albatross
|
|http://www.object-craft.com.au/projects/albatross/
|-
|matplotlib
|
|http://matplotlib.sourceforge.com
|-
|numpy
|matplotlib
|http://sourceforge.net/projects/numpy/
|-
|ATLAS
|numpy
|http://sourceforge.net/projects/math-atlas/
|-
|BLAS
|numpy
|
|-
| PERL
|style="color:black;background-color:#99ff99;"|Application
| http://ww.perl.org/
|-
| SpreadSheet::WriteExcel
|
| http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/Spreadsheet/WriteExcel.pm
|-
| Parse::RecDescent
| SpreadSheet::WriteExcel
| http://search.cpan.org/~dconway/Parse-RecDescent-v1.95.1/lib/Parse/RecDescent.pm
|-
| OLE::StorageLite
| SpreadSheet::WriteExcel
| http://search.cpan.org/~jmcnamara/OLE-Storage_Lite-0.15/Storage_Lite.pm
|-
| LWP::UserAgent
|
|http://search.cpan.org/~gaas/libwww-perl-5.808/lib/LWP.pm
|-
| MySQL
|style="color:black;background-color:#99ff99;"|Application
|http://www.mysql.org/
|}

See [http://www.mediawiki.org/wiki/Help:Tables Help onTables]

Capacity Forecasting Tool

2007-12-16T03:34:43Z

MatthewBretherton: /* Implementation */

= Introduction =

A web based tool to analyse data extracted from various devices via MRTG and generate a capacity forecast.

= Implementation =

MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to export forecasts as Excel Spreadsheets to facilitate what-if analysis.

= Generating Excel Files =

See [[Generating Excel Spreadsheets Programatically]]

= Parsing MRTG Files =

See [[Parsing MRTG Files]]

= Generating Graphs =

Us the Python module matplotlib to generate images for data encapsulated in a MySQL database. Images will be displayed via a web server.

= UNIX Packages Required =

{| style="color:green;background-color:#ffffcc;" cellpadding="5" cellspacing="0" border="1"
! style="background-color:#33ff33;"|Name
! style="color:red;background-color:#33ff33;"|Required by
!style="background-color:#33ff33;"|Download Location
|-
|Python
| style="color:black;background-color:#99ff99;"|Application
|http://www.python.org

|-
|matplotlib
|
|http://matplotlib.sourceforge.com
|-
|numpy
|matplotlib
|http://sourceforge.net/projects/numpy/
|-
|ATLAS
|numpy
|http://sourceforge.net/projects/math-atlas/
|-
|BLAS
|numpy
|
|-
| PERL
|style="color:black;background-color:#99ff99;"|Application
| http://ww.perl.org/
|-
| SpreadSheet::WriteExcel
|
| http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/Spreadsheet/WriteExcel.pm
|-
| Parse::RecDescent
| SpreadSheet::WriteExcel
| http://search.cpan.org/~dconway/Parse-RecDescent-v1.95.1/lib/Parse/RecDescent.pm
|-
| OLE::StorageLite
| SpreadSheet::WriteExcel
| http://search.cpan.org/~jmcnamara/OLE-Storage_Lite-0.15/Storage_Lite.pm
|-
| LWP::UserAgent
|
|http://search.cpan.org/~gaas/libwww-perl-5.808/lib/LWP.pm
|-
| MySQL
|style="color:black;background-color:#99ff99;"|Application
|http://www.mysql.org/
|}

See [http://www.mediawiki.org/wiki/Help:Tables Help onTables]

Capacity Forecasting Tool

2007-12-15T23:04:13Z

MatthewBretherton: /* UNIX Packages Required */

= Introduction =

A web based tool to analyse data extracted from various devices via MRTG and generate a capacity forecast.

= Implementation =

MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to download forecasts as Excel Spreadsheets.

= Generating Excel Files =

See [[Generating Excel Spreadsheets Programatically]]

= Parsing MRTG Files =

See [[Parsing MRTG Files]]

= Generating Graphs =

Us the Python module matplotlib to generate images for data encapsulated in a MySQL database. Images will be displayed via a web server.

= UNIX Packages Required =

{| style="color:green;background-color:#ffffcc;" cellpadding="5" cellspacing="0" border="1"
! style="background-color:#33ff33;"|Name
! style="color:red;background-color:#33ff33;"|Required by
!style="background-color:#33ff33;"|Download Location
|-
|Python
| style="color:black;background-color:#99ff99;"|Application
|http://www.python.org

|-
|matplotlib
|
|http://matplotlib.sourceforge.com
|-
|numpy
|matplotlib
|http://sourceforge.net/projects/numpy/
|-
|ATLAS
|numpy
|http://sourceforge.net/projects/math-atlas/
|-
|BLAS
|numpy
|
|-
| PERL
|style="color:black;background-color:#99ff99;"|Application
| http://ww.perl.org/
|-
| SpreadSheet::WriteExcel
|
| http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/Spreadsheet/WriteExcel.pm
|-
| Parse::RecDescent
| SpreadSheet::WriteExcel
| http://search.cpan.org/~dconway/Parse-RecDescent-v1.95.1/lib/Parse/RecDescent.pm
|-
| OLE::StorageLite
| SpreadSheet::WriteExcel
| http://search.cpan.org/~jmcnamara/OLE-Storage_Lite-0.15/Storage_Lite.pm
|-
| LWP::UserAgent
|
|http://search.cpan.org/~gaas/libwww-perl-5.808/lib/LWP.pm
|-
| MySQL
|style="color:black;background-color:#99ff99;"|Application
|http://www.mysql.org/
|}

See [http://www.mediawiki.org/wiki/Help:Tables Help onTables]

Capacity Forecasting Tool

2007-12-15T23:02:48Z

MatthewBretherton: /* UNIX Packages Required */

= Introduction =

A web based tool to analyse data extracted from various devices via MRTG and generate a capacity forecast.

= Implementation =

MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to download forecasts as Excel Spreadsheets.

= Generating Excel Files =

See [[Generating Excel Spreadsheets Programatically]]

= Parsing MRTG Files =

See [[Parsing MRTG Files]]

= Generating Graphs =

Us the Python module matplotlib to generate images for data encapsulated in a MySQL database. Images will be displayed via a web server.

= UNIX Packages Required =

{| style="color:green;background-color:#ffffcc;" cellpadding="5" cellspacing="0" border="1"
! style="background-color:#33ff33;"|Name
! style="color:red;background-color:#33ff33;"|Required by
!style="background-color:#33ff33;"|Download Location
|-
|Python
| style="color:black;background-color:#99ff99;"|Application
|http://www.python.org

|-
|matplotlib
|
|http://matplotlib.sourceforge.com
|-
|numpy
|matplotlib
|http://sourceforge.net/projects/numpy/
|-
|ATLAS
|numpy
|http://sourceforge.net/projects/math-atlas/
|-
|BLAS
|numpy
|
|-
| PERL
|style="color:black;background-color:#99ff99;"|Application
| http://ww.perl.org/
|-
| SpreadSheet::WriteExcel
|
| http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/Spreadsheet/WriteExcel.pm
|-
| Parse::RecDescent
| SpreadSheet::WriteExcel
| http://search.cpan.org/~dconway/Parse-RecDescent-v1.95.1/lib/Parse/RecDescent.pm
|-
| OLE::StorageLite
| SpreadSheet::WriteExcel
| http://search.cpan.org/~jmcnamara/OLE-Storage_Lite-0.15/Storage_Lite.pm
|-
| LWP::UserAgent
|
|http://search.cpan.org/~gaas/libwww-perl-5.808/lib/LWP.pm
|}

See [http://www.mediawiki.org/wiki/Help:Tables Help onTables]

Capacity Forecasting Tool

2007-12-15T07:43:59Z

MatthewBretherton:

= Introduction =

A web based tool to analyse data extracted from various devices via MRTG and generate a capacity forecast.

= Implementation =

MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to download forecasts as Excel Spreadsheets.

= Generating Excel Files =

See [[Generating Excel Spreadsheets Programatically]]

= Parsing MRTG Files =

See [[Parsing MRTG Files]]

= Generating Graphs =

Us the Python module matplotlib to generate images for data encapsulated in a MySQL database. Images will be displayed via a web server.

= UNIX Packages Required =

{| style="color:green;background-color:#ffffcc;" cellpadding="5" cellspacing="0" border="1"
!Name
! style="color:red;"|Required by
!Download Location
|-
|Python
| style="color:black;background-color:#ff00cc;"|Application
|http://www.python.org

|-
|matplotlib
|
|http://matplotlib.sourceforge.com
|-
|numpy
|matplotlib
|http://sourceforge.net/projects/numpy/
|-
|ATLAS
|numpy
|http://sourceforge.net/projects/math-atlas/
|-
|BLAS
|numpy
|
|-
| PERL
|
| http://ww.perl.org/
|-
| SpreadSheet::WriteExcel
|
| http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/Spreadsheet/WriteExcel.pm
|-
| Parse::RecDescent
| SpreadSheet::WriteExcel
| http://search.cpan.org/~dconway/Parse-RecDescent-v1.95.1/lib/Parse/RecDescent.pm
|-
| OLE::StorageLite
| SpreadSheet::WriteExcel
| http://search.cpan.org/~jmcnamara/OLE-Storage_Lite-0.15/Storage_Lite.pm
|}

See [http://www.mediawiki.org/wiki/Help:Tables Help onTables]

Capacity Forecasting Tool

2007-12-15T07:42:54Z

MatthewBretherton:

= Introduction =

A web based tool to analyse data extracted from various devices via MRTG and generate a capacity forecast.

= Implementation =

MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to download forecasts as Excel Spreadsheets.

= Generating Excel Files =

See [[Generating Excel Spreadsheets Programatically]]

= Parsing MRTG Files =

See [[Parsing MRTG Files]]

= Generating Graphs =

Us the Python module matplotlib to generate images for data encapsulated in a MySQL database. Images will be displayed via a web server.

= UNIX Packages Required =

{| style="color:green;background-color:#ffffcc;" cellpadding="5" cellspacing="0" border="1"
!Name
! style="color:red;"|Required by
!Download Location
|-
|Python
| style="color:black;"|XXX
|http://www.python.org

|-
|matplotlib
|
|http://matplotlib.sourceforge.com
|-
|numpy
|matplotlib
|http://sourceforge.net/projects/numpy/
|-
|ATLAS
|numpy
|http://sourceforge.net/projects/math-atlas/
|-
|BLAS
|numpy
|
|-
| PERL
|
| http://ww.perl.org/
|-
| SpreadSheet::WriteExcel
|
| http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/Spreadsheet/WriteExcel.pm
|-
| Parse::RecDescent
| SpreadSheet::WriteExcel
| http://search.cpan.org/~dconway/Parse-RecDescent-v1.95.1/lib/Parse/RecDescent.pm
|-
| OLE::StorageLite
| SpreadSheet::WriteExcel
| http://search.cpan.org/~jmcnamara/OLE-Storage_Lite-0.15/Storage_Lite.pm
|}

See [http://www.mediawiki.org/wiki/Help:Tables Help onTables]

Capacity Forecasting Tool

2007-12-15T07:42:00Z

MatthewBretherton:

= Introduction =

A web based tool to analyse data extracted from various devices via MRTG and generate a capacity forecast.

= Implementation =

MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to download forecasts as Excel Spreadsheets.

= Generating Excel Files =

See [[Generating Excel Spreadsheets Programatically]]

= Parsing MRTG Files =

See [[Parsing MRTG Files]]

= Generating Graphs =

Us the Python module matplotlib to generate images for data encapsulated in a MySQL database. Images will be displayed via a web server.

= UNIX Packages Required =

{| style="color:green;background-color:#ffffcc;" cellpadding="5" cellspacing="0" border="1"
!Name
! style="color:red;"|Required by
!Download Location
|-
|Python
|
|http://www.python.org

|-
|matplotlib
|
|http://matplotlib.sourceforge.com
|-
|numpy
|matplotlib
|http://sourceforge.net/projects/numpy/
|-
|ATLAS
|numpy
|http://sourceforge.net/projects/math-atlas/
|-
|BLAS
|numpy
|
|-
| PERL
|
| http://ww.perl.org/
|-
| SpreadSheet::WriteExcel
|
| http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/Spreadsheet/WriteExcel.pm
|-
| Parse::RecDescent
| SpreadSheet::WriteExcel
| http://search.cpan.org/~dconway/Parse-RecDescent-v1.95.1/lib/Parse/RecDescent.pm
|-
| OLE::StorageLite
| SpreadSheet::WriteExcel
| http://search.cpan.org/~jmcnamara/OLE-Storage_Lite-0.15/Storage_Lite.pm
|}

See [http://www.mediawiki.org/wiki/Help:Tables Help onTables]

Capacity Forecasting Tool

2007-12-15T07:38:59Z

MatthewBretherton:

= Introduction =

A web based tool to analyse data extracted from various devices via MRTG and generate a capacity forecast.

= Implementation =

MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to download forecasts as Excel Spreadsheets.

= Generating Excel Files =

See [[Generating Excel Spreadsheets Programatically]]

= Parsing MRTG Files =

See [[Parsing MRTG Files]]

= Generating Graphs =

Us the Python module matplotlib to generate images for data encapsulated in a MySQL database. Images will be displayed via a web server.

= UNIX Packages Required =

{| style="color:green;background-color:#ffffcc;" cellpadding="5" cellspacing="0" border="1"
!Name
!Required by
!Download Location
|-
|Python
|
|http://www.python.org

|-
|matplotlib
|
|http://matplotlib.sourceforge.com
|-
|numpy
|matplotlib
|http://sourceforge.net/projects/numpy/
|-
|ATLAS
|numpy
|http://sourceforge.net/projects/math-atlas/
|-
|BLAS
|numpy
|
|-
| PERL
|
| http://ww.perl.org/
|-
| SpreadSheet::WriteExcel
|
| http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/Spreadsheet/WriteExcel.pm
|-
| Parse::RecDescent
| SpreadSheet::WriteExcel
| http://search.cpan.org/~dconway/Parse-RecDescent-v1.95.1/lib/Parse/RecDescent.pm
|-
| OLE::StorageLite
| SpreadSheet::WriteExcel
| http://search.cpan.org/~jmcnamara/OLE-Storage_Lite-0.15/Storage_Lite.pm
|}

See [http://www.mediawiki.org/wiki/Help:Tables Help onTables]

Capacity Forecasting Tool

2007-12-15T07:38:26Z

MatthewBretherton:

= Introduction =

A web based tool to analyse data extracted from various devices via MRTG and generate a capacity forecast.

= Implementation =

MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to download forecasts as Excel Spreadsheets.

= Generating Excel Files =

See [[Generating Excel Spreadsheets Programatically]]

= Parsing MRTG Files =

See [[Parsing MRTG Files]]

= Generating Graphs =

Us the Python module matplotlib to generate images for data encapsulated in a MySQL database. Images will be displayed via a web server.

= UNIX Packages Required =

{| style="color:green;background-color:#ffffcc;" cellpadding="5" cellspacing="0" border="1"
!Name
!Required by
!Location
|-
|Python
|
|http://www.python.org

|-
|matplotlib
|
|http://matplotlib.sourceforge.com
|-
|numpy
|matplotlib
|http://sourceforge.net/projects/numpy/
|-
|ATLAS
|numpy
|http://sourceforge.net/projects/math-atlas/
|-
|BLAS
|numpy
|
|-
| PERL
|
| http://ww.perl.org/
|-
| SpreadSheet::WriteExcel
|
| http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/Spreadsheet/WriteExcel.pm
|-
| Parse::RecDescent
| SpreadSheet::WriteExcel
| http://search.cpan.org/~dconway/Parse-RecDescent-v1.95.1/lib/Parse/RecDescent.pm
|-
| OLE::StorageLite
| SpreadSheet::WriteExcel
| http://search.cpan.org/~jmcnamara/OLE-Storage_Lite-0.15/Storage_Lite.pm
|}

See [http://www.mediawiki.org/wiki/Help:Tables Help onTables]

Capacity Forecasting Tool

2007-12-15T07:31:16Z

MatthewBretherton:

Capacity Forecasting Tool

2007-12-15T07:19:30Z

MatthewBretherton:

Capacity Forecasting Tool

2007-12-15T07:17:29Z

MatthewBretherton:

Capacity Forecasting Tool

2007-12-15T07:16:50Z

MatthewBretherton:

Capacity Forecasting Tool

2007-12-15T07:16:32Z

MatthewBretherton:

Capacity Forecasting Tool

2007-12-15T07:16:14Z

MatthewBretherton:

Capacity Forecasting Tool

2007-12-15T07:15:52Z

MatthewBretherton:

Capacity Forecasting Tool

2007-12-15T07:11:02Z

MatthewBretherton:

Capacity Forecasting Tool

2007-12-15T07:10:25Z

MatthewBretherton:

Capacity Forecasting Tool

2007-12-15T07:08:28Z

MatthewBretherton:

Capacity Forecasting Tool

2007-12-15T07:08:11Z

MatthewBretherton:

Capacity Forecasting Tool

2007-12-15T07:01:09Z

MatthewBretherton:

= Introduction =

= Implementation =

= Generating Excel Files =

[[Generating Excel Spreadsheets Programatically]]

= Parsing MRTG Files =

[[Parsing MRTG Files]]

Generating Excel Spreadsheets Programatically

2007-12-15T06:59:55Z

MatthewBretherton:

Back to [[Capacity Forecasting Tool]]

= Perl =

* [http://search.cpan.org/ Write Excel Spreadsheets]
* [http://aspn.activestate.com/ASPN/CodeDoc/Spreadsheet-WriteExcel/WriteExcel.html]

= Python =

= Examples =

== PERL ==

=== Translating a CSV File to an Excel Spreadsheet ===

Here is the script:

#!/usr/bin/env perl
#
#-------------------------------------------------------------------------------

use strict;
use Spreadsheet::WriteExcel;

#-------------------------------------------------------------------------------

if ($#ARGV ne 1) {
print "\n Usage: txt2xls \n Example: txt2xls \"|\" *.psv\n\n";
}

my $token;
my $file;
my $del;
my $wb;

my $separator = quotemeta($ARGV[0]);
my @files = @ARGV[1..$#ARGV];

foreach $file (@files){
open (TXTFILE, "$file") or die;

my $wb = Spreadsheet::WriteExcel->new("$file.xls");
my $excel = $wb->addworksheet();
my $row = 0;
my $col;

while (<TXTFILE>) {
chomp;

my @Fld = split(/$separator/, $_);

$col = 0;

foreach $token (@Fld) {
$excel->write($row, $col, $token);
$col++;
}

$row++;
}
}

#-------------------------------------------------------------------------------

Here is how it is used:

$ cat example

aaa,bbb,ccc,ddd
aaa,bbb,ccc,ddd
aaa,bbb,ccc,ddd
aaa,bbb,ccc,ddd
aaa,bbb,ccc,ddd

$ ./txt2xls "," example

$ ls -l example.xls
-rw-r--r-- 1 user group 5632 2007-12-15 17:47 example.xls

The first argument is the separator character. So to convert the passwd file to a spreadsheet use the following command:

$ ./txt2xls ":" /etc/passwd

=== Write a Simple Spreadsheet with Two Worksheets ===

#!/usr/bin/env perl

#-------------------------------------------------------------------------------

use Spreadsheet::WriteExcel;

#-------------------------------------------------------------------------------

# Create a new Excel workbook

my $workbook = Spreadsheet::WriteExcel->new("perl.xls");

# Add a worksheet

$worksheet = $workbook->addworksheet("Test 1");

# Add and define a format

$format = $workbook->addformat(); # Add a format
$format->set_bold();
$format->set_color('red');
$format->set_align('center');

# Write a formatted and unformatted string, row and column notation.

$col = $row = 0;

$worksheet->write($row, $col, "In sheet l!", $format);
$worksheet->write(1, $col, "Hi Excel!");

# Write a number and a formula using A1 notation

$worksheet->write('A3', 1.2345);
$worksheet->write('A4', '=SIN(PI()/4)');

# Now create a second worksheet

$worksheet = $workbook->addworksheet("Test 2");

$worksheet->write($row, $col, "In sheet 2!", $format);

#-------------------------------------------------------------------------------

Generating Excel Spreadsheets Programatically

2007-12-15T06:51:44Z

MatthewBretherton:

Generating Excel Spreadsheets Programatically

2007-12-15T06:51:12Z

MatthewBretherton: `

Generating Excel Spreadsheets Programatically

2007-12-15T06:51:08Z

MatthewBretherton: `

Generating Excel Spreadsheets Programatically

2007-12-15T06:49:12Z

MatthewBretherton:

Generating Excel Spreadsheets Programatically

2007-12-15T06:48:26Z

MatthewBretherton:

Generating Excel Spreadsheets Programatically

2007-12-15T06:43:41Z

MatthewBretherton:

Back to [[Capacity Forecasting Tool]]

= Perl =

* [http://search.cpan.org/ Write Excel Spreadsheets]
* [http://aspn.activestate.com/ASPN/CodeDoc/Spreadsheet-WriteExcel/WriteExcel.html]

= Python =

= Examples =

== PERL ==

=== Ex 1 ===

#!/usr/bin/env perl
#
#-------------------------------------------------------------------------------

use strict;
use Spreadsheet::WriteExcel;

#-------------------------------------------------------------------------------

if ($#ARGV ne 1) {
print "\n Usage: txt2xls \n Example: txt2xls \"|\" *.psv\n\n";
}

my $token;
my $file;
my $del;
my $wb;

my $separator = quotemeta($ARGV[0]);
my @files = @ARGV[1..$#ARGV];

foreach $file (@files){
open (TXTFILE, "$file") or die;

my $wb = Spreadsheet::WriteExcel->new("$file.xls");
my $excel = $wb->addworksheet();
my $row = 0;
my $col;

while (<TXTFILE>) {
chomp;

my @Fld = split(/$separator/, $_);

$col = 0;

foreach $token (@Fld) {
$excel->write($row, $col, $token);
$col++;
}

$row++;
}
}

#-------------------------------------------------------------------------------