10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need help in debug following script. can somebody help....!!!
#!/usr/bin/perl -w
use strict;
use Spreadsheet::WriteExcel;
# Create a new workbook called simple.xls and add a worksheet.
my $workbook = Spreadsheet::WriteExcel->new('simple.xls');
my $worksheet =... (1 Reply)
Discussion started by: chettyravi
1 Replies
2. Shell Programming and Scripting
I'm pulling down some LUN usage data once per day. I store the data in a file name that matches the name of the LUN. Then I just append new usage amounts to the same file each day.
Filename might be serv01_luna, serv01_lunb, serv01_lunc, etc, etc.
Inside the file it would like the following... (7 Replies)
Discussion started by: dwcasey
7 Replies
3. Shell Programming and Scripting
Hi
I can't seem to figure out why i keep getting this error. the Spreadsheet::PhaseExcel is installed on 3 servers and is working on only 2... the last one it is installed exactly the same way but I keep getting this error.
This is whats odd.
If i run this script as a normal user i get... (2 Replies)
Discussion started by: vpundit
2 Replies
4. Shell Programming and Scripting
so in unix this command works works and shows me a list of directories
find . -name \*.xls -exec dirname {} \; | sort -u | > list.txt
but when i try running a perl script to run this command
my $query = 'find . -name \*.xls -exec dirname {} \; | sort -u | > list.txt';... (2 Replies)
Discussion started by: kpddong
2 Replies
5. Shell Programming and Scripting
And I have to modify this part of the script, I'm not sure what to change the content-type to for this to work, or what else I would need to change here:
# This script sends Email acoording to command line arguments.
# $1 - file to be attached (full path with name)
# $2 - file name as it... (1 Reply)
Discussion started by: NycUnxer
1 Replies
6. AIX
I may have posted in the wrong section, either way I need some help.
And I have to modify this part of the script, I'm not sure what to change the content-type to for this to work, or what else I would need to change here:
# This script sends Email acoording to command line arguments.
#... (1 Reply)
Discussion started by: NycUnxer
1 Replies
7. Shell Programming and Scripting
I understand that in order to run basic unix commands I would normally type at the prompt, I would have to use the following format
system(ls -l);
or
exec(ls -l);
But when I actually try to use the command, the script fails to compile and keeps telling me there is an error with this line. ... (1 Reply)
Discussion started by: userix
1 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
I am not a computer programmer nor a computer specialist but I do create some Excel speadsheets and I need to download the data generated from Excel to a Unix/linux programmed screen. Do you know if there is a way or a "trick" that could make this data transfer automated so it would... (2 Replies)
Discussion started by: claude73
2 Replies
9. Shell Programming and Scripting
I want to know that will Spreadsheet::WriteExcelXML coding will work in unix with perl and shell scripting. (1 Reply)
Discussion started by: akash
1 Replies
10. UNIX for Dummies Questions & Answers
Does anyone know if it's possible to import a Unix directory into an Excel spreadsheet?
I'm trying to create a report based on about several thousand files within a Unix server directory, I was thinking if I could import the directory into a spreadsheet it would be easier to sort the data based... (2 Replies)
Discussion started by: Arkitech
2 Replies
Spreadsheet::WriteExcel::Chart::Scatter(3pm) User Contributed Perl Documentation Spreadsheet::WriteExcel::Chart::Scatter(3pm)
NAME
Scatter - A writer class for Excel Scatter charts.
SYNOPSIS
To create a simple Excel file with a Scatter 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 => 'scatter' );
# 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 Scatter charts for Spreadsheet::WriteExcel. The chart object is created via the Workbook "add_chart()" method:
my $chart = $workbook->add_chart( type => 'scatter' );
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.
Scatter Chart Methods
There aren't currently any scatter 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_scatter.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 => 'scatter', 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::Scatter(3pm)