01-03-2007
It's not your module - although you may have problems with that in the future.
Quote:
when I try to use the perl module in a perl code - its showing :
/home/mukher2> perl testpl.pl
syntax error at testpl.pl line 11, near "use Spreadsheet::WriteExcel"
Execution of testpl.pl aborted due to compilation errors.
/home/mukher2>
This is a syntax error. Your perl script won't even compile, which means it's not written correctly. It hasn't even tried to load the module yet.
Can you paste the lines around line 11 of your script?
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to replace a Perl module name in all my Perl Scripts in the cgi-bin directory. How is it possible?
I have the following statement in my scripts
use myUtil;
I want to change it to
use myUtil777;
Regards,
Rahul (2 Replies)
Discussion started by: rahulrathod
2 Replies
2. Shell Programming and Scripting
----------
This is perl, v5.6.1 built for MSWin32-x86-multi-thread
(with 1 registered patch, see perl -V for more detail)
----------in win 2000 advanced server,..
i am somewhat comfortable with perl but i am new to perl modules..
when i tried to install xml::simple and xml::parser
there... (4 Replies)
Discussion started by: sekar sundaram
4 Replies
3. Shell Programming and Scripting
Hi All,
I am failry new to Perl.I am trying to install a Perl module (Filesys::df.pm) in an IBM AIX5.3 server.But I could not succeed in that.I am getting the following error:
abcd3dev# make
cc_r -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias... (6 Replies)
Discussion started by: surjithss
6 Replies
4. Shell Programming and Scripting
All,
Is it possible to call a subroutine from the perl expect module after logging to a system that is within the same program. My situation is I need to run a logic inside a machine that I'm logging in using the expect module, the logic is also available in the same expect program.
Thanks,... (5 Replies)
Discussion started by: arun_maffy
5 Replies
5. Windows & DOS: Issues & Discussions
Hi,
I am struggling in installing TK module for strawberry perl.
I downloaded TK804 module,
extracted to a folder, kept in c:/strawberry/perl/lib path,
then from tht path
1) perl makefile.pl
2)dmake
3)dmake test
4)dmake install
During perl makefile.pl it is giving error as... (3 Replies)
Discussion started by: vasanth.vadalur
3 Replies
6. Shell Programming and Scripting
Hi 'm getting error while installing perl mdule on linux.can any one tell me how to resolve that error?
problem is:
CPAN: File::Temp loaded ok (v0.22)
CPAN.pm: Going to build J/JD/JDB/Win32-OLE-0.1709.tar.gz
OS unsupported
Warning: No success on command
Warning (usually harmless):... (1 Reply)
Discussion started by: kavi.mogu
1 Replies
7. Red Hat
Hi,
I am using Red Hat 9.0 and it does not have the inbuilt driver module for my onboard lan card (RTL 8169). I downloaded the module (file - r8169-6.017.00.tar.bz2 and even r8169-6.015.00.tar.bz2), but when try to install it it says r8169.h , r8169_n.c , Makefile etc are not ELF formats.
... (0 Replies)
Discussion started by: dextergenious
0 Replies
8. Linux
Hi,
I am using Red Hat 9.0 and it does not have the inbuilt driver module for my onboard lan card (RTL 8169). I downloaded the module (file - r8169-6.017.00.tar.bz2 and even r8169-6.015.00.tar.bz2), but when try to install it it says r8169.h , r8169_n.c , Makefile etc are... (2 Replies)
Discussion started by: dextergenious
2 Replies
9. Shell Programming and Scripting
I have issue with the perl module installed in the new Linux server
I have installed the required module, but still the perl program was not able to find the path
I'm getting the below error:
Can't locate Log/Log4perl.pm in @INC (@INC contains: /usr/lib/perl5/site_perl/Log4perl.pm... (5 Replies)
Discussion started by: help_scr_seeker
5 Replies
LEARN ABOUT DEBIAN
spreadsheet::writeexcel::chart::column
Spreadsheet::WriteExcel::Chart::Column(3pm) User Contributed Perl Documentation Spreadsheet::WriteExcel::Chart::Column(3pm)
NAME
Column - A writer class for Excel Column charts.
SYNOPSIS
To create a simple Excel file with a Column chart using Spreadsheet::WriteExcel:
#!/usr/bin/perl -w
use strict;
use Spreadsheet::WriteExcel;
my $workbook = Spreadsheet::WriteExcel->new( 'chart.xls' );
my $worksheet = $workbook->add_worksheet();
my $chart = $workbook->add_chart( type => 'column' );
# Configure the chart.
$chart->add_series(
categories => '=Sheet1!$A$2:$A$7',
values => '=Sheet1!$B$2:$B$7',
);
# Add the worksheet data the chart refers to.
my $data = [
[ 'Category', 2, 3, 4, 5, 6, 7 ],
[ 'Value', 1, 4, 5, 2, 1, 5 ],
];
$worksheet->write( 'A1', $data );
__END__
DESCRIPTION
This module implements Column charts for Spreadsheet::WriteExcel. The chart object is created via the Workbook "add_chart()" method:
my $chart = $workbook->add_chart( type => 'column' );
Once the object is created it can be configured via the following methods that are common to all chart classes:
$chart->add_series();
$chart->set_x_axis();
$chart->set_y_axis();
$chart->set_title();
These methods are explained in detail in Spreadsheet::WriteExcel::Chart. Class specific methods or settings, if any, are explained below.
Column Chart Methods
There aren't currently any column chart specific methods. See the TODO section of Spreadsheet::WriteExcel::Chart.
EXAMPLE
Here is a complete example that demonstrates most of the available features when creating a chart.
#!/usr/bin/perl -w
use strict;
use Spreadsheet::WriteExcel;
my $workbook = Spreadsheet::WriteExcel->new( 'chart_column.xls' );
my $worksheet = $workbook->add_worksheet();
my $bold = $workbook->add_format( bold => 1 );
# Add the worksheet data that the charts will refer to.
my $headings = [ 'Number', 'Sample 1', 'Sample 2' ];
my $data = [
[ 2, 3, 4, 5, 6, 7 ],
[ 1, 4, 5, 2, 1, 5 ],
[ 3, 6, 7, 5, 4, 3 ],
];
$worksheet->write( 'A1', $headings, $bold );
$worksheet->write( 'A2', $data );
# Create a new chart object. In this case an embedded chart.
my $chart = $workbook->add_chart( type => 'column', embedded => 1 );
# Configure the first series. (Sample 1)
$chart->add_series(
name => 'Sample 1',
categories => '=Sheet1!$A$2:$A$7',
values => '=Sheet1!$B$2:$B$7',
);
# Configure the second series. (Sample 2)
$chart->add_series(
name => 'Sample 2',
categories => '=Sheet1!$A$2:$A$7',
values => '=Sheet1!$C$2:$C$7',
);
# Add a chart title and some axis labels.
$chart->set_title ( name => 'Results of sample analysis' );
$chart->set_x_axis( name => 'Test number' );
$chart->set_y_axis( name => 'Sample length (cm)' );
# Insert the chart into the worksheet (with an offset).
$worksheet->insert_chart( 'D2', $chart, 25, 10 );
__END__
AUTHOR
John McNamara jmcnamara@cpan.org
COPYRIGHT
Copyright MM-MMX, John McNamara.
All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.
perl v5.10.1 2010-02-02 Spreadsheet::WriteExcel::Chart::Column(3pm)