03-03-2011
I suppose the closest "parallel" we could make this to a "Shell Scripting" question would be to export the .xls file to an .xml file (a "Save As" option of Excel), modify that, then import it back to Excel?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all
how can can remove the underscore from this number in this series
_1234567.abc
_1234567.abcd
I was trying mv _1234567* 1234567
but did not work ?
thanks
s (2 Replies)
Discussion started by: simon2000
2 Replies
2. UNIX for Dummies Questions & Answers
I have a file named -^, I want to look at it, rename, etc. Any help out there?? (5 Replies)
Discussion started by: nj78
5 Replies
3. Shell Programming and Scripting
hi,
im doin an assignment which requires you to build a shell script to do the MS DOS style equivilant (sp?) of the rename function. What i have to do is a loop which checks the following rules and output messages (same):
Can't have anything after target
Can't have more than one dot
Can't... (1 Reply)
Discussion started by: bohoo
1 Replies
4. UNIX for Dummies Questions & Answers
hi guys i am writing a script to change the filename which is enterered as input to lower case letter even if one letter is upper case i have to change it to lower case
i get the input and use
sed comand should i use like that
sed/s/a-z/A-Z/d
will it be like that can u please help me (8 Replies)
Discussion started by: farhan_t49
8 Replies
5. Shell Programming and Scripting
hi,
my directory has the following files
I want to rename or mv them as
file 1 corresponds to new_1.bed, file2 to new_2.bed and so on.
How do I do it using awk or bash? TIA (4 Replies)
Discussion started by: jacobs.smith
4 Replies
6. Shell Programming and Scripting
Hi All,
I need a solution to convert my .xlsx file which has lot of worksheet, convert to separate csv file. Is there any shell script to do this? I can’t use excel macro to do this, since it was password locked.
I need the csv output as an input to my shell script. (1 Reply)
Discussion started by: ranjancom2000
1 Replies
7. Shell Programming and Scripting
Hi, I have multiple files in a directory e.g.
file1.txt.gz
file2.txt.gz
file3.txt.gz
and I want to rename them to:
file1.dat.gz
file2.dat.gz
file3.dat.gz
I don't have 'rename' command on my system.
Thanks! (4 Replies)
Discussion started by: apenkov
4 Replies
8. Shell Programming and Scripting
Hi,
I need to redirect of a script to different worksheet in a single excel file. I have four queries in that script. Each query output needs to be placed in separate worksheet of a excel file. can someone help me to find this? (10 Replies)
Discussion started by: Arasu
10 Replies
9. UNIX for Dummies Questions & Answers
I want to rename files
Files show like this
1977SSD_rsdtst.pdf
1976SDP_rstdtsr.pdf
1943FDT_rstdsrt.pdf
1996DFF_stdstrd.pdf
I want to introduce _ after the year, and move the characters to the end
to get
1977_rsdtst_SSD.pdf
1976_rstdtsr_SDP.pdf
1943_rstdsrt_FDT.pdf... (4 Replies)
Discussion started by: kristinu
4 Replies
10. Shell Programming and Scripting
Renaming files using rename on the following files
rename 's/.99999/.99999.sac.pzs/g' *.99999
sac_pzs_iv_esml_hhz__2013.074.10.18.23.0000_2599.365.23.59.59.99999
sac_pzs_iv_favr_hhe__2010.187.00.00.00.0000_2599.365.23.59.59.99999... (1 Reply)
Discussion started by: kristinu
1 Replies
LEARN ABOUT DEBIAN
spreadsheet::writeexcel::chart::bar
Spreadsheet::WriteExcel::Chart::Bar(3pm) User Contributed Perl Documentation Spreadsheet::WriteExcel::Chart::Bar(3pm)
NAME
Bar - A writer class for Excel Bar charts.
SYNOPSIS
To create a simple Excel file with a Bar 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 => 'bar' );
# 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 Bar charts for Spreadsheet::WriteExcel. The chart object is created via the Workbook "add_chart()" method:
my $chart = $workbook->add_chart( type => 'bar' );
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.
Bar Chart Methods
There aren't currently any bar 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_bar.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 => 'bar', 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::Bar(3pm)