12-20-2018
What kind of excel? XLS or XLSX? Perl has common solutions for automating XLS, while XLSX is really difficult.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
When I create filesystems in AIX i often get confused(using smit)
When you specify size in aix, it is asked like this
SIZE of file system (in 512-byte blocks)
I never seem to grasp this, what is the equation to get say
500mb? Or is there a program anyone knows of that does this, like a... (1 Reply)
Discussion started by: csaunders
1 Replies
2. UNIX for Dummies Questions & Answers
Hello,
I transferred some .txt files from windows to Unix. When i used the editor in Unix to open up the file, all the <cr> show up. How to I get rid of all of them? (4 Replies)
Discussion started by: laila63
4 Replies
3. Shell Programming and Scripting
I want to convert string into uppercase string. How can i do that ? Ex: Enter the user name:
read name
show=upper(name)
echo $show --- This output should be the uppercase output.
Thanks (3 Replies)
Discussion started by: dreams5617
3 Replies
4. SCO
I use Sco_Sv 3.2v5.0.5 with parellel conection using dump terminals and i want to convert them to desktop pc.
Anybody knows what hardware and other thing that would be involved? (3 Replies)
Discussion started by: seeyou
3 Replies
5. Shell Programming and Scripting
Hi - I have seen some similar posts but I am a bit stumped here
below is the first line of a 'od -c filename' command. I want to change the \0 to \n
0000000 l s \0 c d - \0 c d . . \0 l s
I have tried a sed construct in a script.........
sed... (2 Replies)
Discussion started by: ajcannon
2 Replies
6. Shell Programming and Scripting
Hi all,
I have never written a script so I guess you could say I am very yellow.:) However, I could use some help.... I need to write a Korn Shell Script that converts coins. Meaning if I print or echo "Please enter amount:" and the user puts in 3.87, I need to know the least amount of coins... (11 Replies)
Discussion started by: tzeman
11 Replies
7. SCO
Hi everybody
Is there any sco unix command to convert .so library to .a
(under sco unix openserver.5.0.6)
tnx (2 Replies)
Discussion started by: javad1_maroofi
2 Replies
8. UNIX for Advanced & Expert Users
I have a file that ends with a ctlU:
> cat -v test.file
blah,blah,blah,GEAEA*1*xx0000111xxx^UIEA*xxx0^U
would like to replace the ctlU (^U) with a "\12"...due to printers or something.
I believe I might be able to utilize the tr command, if I could only identify the correct... (4 Replies)
Discussion started by: mr_manny
4 Replies
9. Solaris
So i have been asked to write a script for a friend who has a server running solaris 11. My problem is the correct syntax i can't seem to get it work with the follow code, i have read through the date man page and found no work around
Below is the code for part of the rsync script.
The code i... (2 Replies)
Discussion started by: paperghost
2 Replies
10. Shell Programming and Scripting
I have a set of values separated by a tab
ch:12 1 3 4
ch:13 3 3 4
ch:25 1 8
ch:23 2 8 1
There is a missing value in the third column and i would like replace it with
NA such that the final output would look like
ch:12 1 3 ... (7 Replies)
Discussion started by: johnkim0806
7 Replies
LEARN ABOUT DEBIAN
excel::writer::xlsx::chart::area
Excel::Writer::XLSX::Chart::Area(3pm) User Contributed Perl Documentation Excel::Writer::XLSX::Chart::Area(3pm)
NAME
Area - A class for writing Excel Area charts.
SYNOPSIS
To create a simple Excel file with a Area chart using Excel::Writer::XLSX:
#!/usr/bin/perl
use strict;
use warnings;
use Excel::Writer::XLSX;
my $workbook = Excel::Writer::XLSX->new( 'chart.xlsx' );
my $worksheet = $workbook->add_worksheet();
my $chart = $workbook->add_chart( type => 'area' );
# 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 Area charts for Excel::Writer::XLSX. The chart object is created via the Workbook "add_chart()" method:
my $chart = $workbook->add_chart( type => 'area' );
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 Excel::Writer::XLSX::Chart. Class specific methods or settings, if any, are explained below.
Area Chart Methods
There aren't currently any area chart specific methods. See the TODO section of Excel::Writer::XLSX::Chart.
EXAMPLE
Here is a complete example that demonstrates most of the available features when creating a chart.
#!/usr/bin/perl
use strict;
use warnings;
use Excel::Writer::XLSX;
my $workbook = Excel::Writer::XLSX->new( 'chart_area.xlsx' );
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', 'Batch 1', 'Batch 2' ];
my $data = [
[ 2, 3, 4, 5, 6, 7 ],
[ 40, 40, 50, 30, 25, 50 ],
[ 30, 25, 30, 10, 5, 10 ],
];
$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 => 'area', embedded => 1 );
# Configure the first series.
$chart->add_series(
name => '=Sheet1!$B$1',
categories => '=Sheet1!$A$2:$A$7',
values => '=Sheet1!$B$2:$B$7',
);
# Configure second series. Note alternative use of array ref to define
# ranges: [ $sheetname, $row_start, $row_end, $col_start, $col_end ].
$chart->add_series(
name => '=Sheet1!$C$1',
categories => [ 'Sheet1', 1, 6, 0, 0 ],
values => [ 'Sheet1', 1, 6, 2, 2 ],
);
# 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 (mm)' );
# Set an Excel chart style. Blue colors with white outline and shadow.
$chart->set_style( 11 );
# 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-MMXII, 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 2012-04-02 Excel::Writer::XLSX::Chart::Area(3pm)