10-02-2014
You really can't run a UNIX script from Excel.
You can collect information on your UNIX system and create an import file (like a comma or other delimited file for import into Excel).
Perhaps what you want is automation of the process and this can be done a number of ways depending on your needs.
AUTOMATED PROCESS FROM WINDOWS
In this case you could use windows scheduler to run Excel and use command line options to automate the Excel session.
You could recreate a VB (Visual Basic), a VBA (Visual Basic for Applications) script, or a Powershell script and run it from Windows scheduler. If using VB or VBA there is a SHELL call that you could use to call SSH to log into the UNIX system and create the CSV/Import flie.
In Powershell you could use SSH directly into the UNIX system. You would need an SSH client like PUTTY).
Once the import file is created you could copy it back with SCP and then the script would call Excel with command line option to import the CSV file created on UNIX.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I have a report which I am running from unix shell script using CONCSUB utility.
Just for testing I put the order number in shell script as ord_low and ord_high.
But Actually what is going to happen is that the order numbers will be in a file say a.txt
and this CONCSUB... (2 Replies)
Discussion started by: isingh786
2 Replies
2. Shell Programming and Scripting
I want to create an automated script which is called by another maually executed script.
The condition is that the no one should be able to manually execute the automated script.
The automated script can be on the same machine or it can be on a remote machine.
Can any one suggest a check in the... (1 Reply)
Discussion started by: adi_bang76
1 Replies
3. Shell Programming and Scripting
Hi,
I have an UNIX script which runs in every 20 mins of all the days scheduled through CRON.
But i need to modify the CRON entry such that it should run from 00:00 AM to 18:00 and again from 22:00 to 23:59 on Saturday. Remaning days, it should run as usual in every 20 mins.
Could... (1 Reply)
Discussion started by: rjanardhan83
1 Replies
4. Shell Programming and Scripting
Hi,
I have an UNIX script which runs in every 20 mins of all the days scheduled through CRON.
But i need to modify the CRON entry such that it should run from 00:00 AM to 18:00 and again from 22:30 to 23:59 on Saturday. Remaning days, it should run as usual in every 20 mins.
Could anybody... (1 Reply)
Discussion started by: rjanardhan83
1 Replies
5. UNIX and Linux Applications
Hi,
I want the Perl script with versions 5.8.2 and 5.8.5 starting with
#!/usr/bin/perl
The Perl program should read the excel file or text file line by line and taking into an array and search in the UNIX directories for reference file of .jsp or .js or .xsl with path .The Object names... (2 Replies)
Discussion started by: pasam
2 Replies
6. Shell Programming and Scripting
Hi,
I am using Send Keys to connect to UNIX server and invoke a script .
Is there an alternate way to connect to UNIX server using Excel macro and invoke a UNIX Shell script?
Anu (2 Replies)
Discussion started by: anandita.jha
2 Replies
7. Shell Programming and Scripting
Hi All,
I have the requirement in unix shell script.
I want to write the "ls -ltr" command out put to excel file as below.
Input :text file data :
drwxr-xr-x 5 root root 4096 Oct 2 12:26
drwxr-xr-x 2 apx aim 4096 Nov 29 18:40
drwxr-xr-x 5 root root 4096 Oct 2 12:26
drwxr-xr-x... (10 Replies)
Discussion started by: Balasankar
10 Replies
8. Shell Programming and Scripting
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies
9. Shell Programming and Scripting
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies
10. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
LEARN ABOUT DEBIAN
excel::writer::xlsx::chart::pie
Excel::Writer::XLSX::Chart::Pie(3pm) User Contributed Perl Documentation Excel::Writer::XLSX::Chart::Pie(3pm)
NAME
Pie - A class for writing Excel Pie charts.
SYNOPSIS
To create a simple Excel file with a Pie 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 => 'pie' );
# 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 Pie charts for Excel::Writer::XLSX. The chart object is created via the Workbook "add_chart()" method:
my $chart = $workbook->add_chart( type => 'pie' );
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_title();
These methods are explained in detail in Excel::Writer::XLSX::Chart. Class specific methods or settings, if any, are explained below.
Pie Chart Methods
There aren't currently any pie chart specific methods. See the TODO section of Excel::Writer::XLSX::Chart.
A Pie chart doesn't have an X or Y axis so the following common chart methods are ignored.
$chart->set_x_axis();
$chart->set_y_axis();
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_pie.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 = [ 'Category', 'Values' ];
my $data = [
[ 'Apple', 'Cherry', 'Pecan' ],
[ 60, 30, 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 => 'pie', embedded => 1 );
# Configure the series. Note the use of the array ref to define ranges:
# [ $sheetname, $row_start, $row_end, $col_start, $col_end ].
$chart->add_series(
name => 'Pie sales data',
categories => [ 'Sheet1', 1, 3, 0, 0 ],
values => [ 'Sheet1', 1, 3, 1, 1 ],
);
# Add a title.
$chart->set_title( name => 'Popular Pie Types' );
# Set an Excel chart style. Colors with white outline and shadow.
$chart->set_style( 10 );
# Insert the chart into the worksheet (with an offset).
$worksheet->insert_chart( 'C2', $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::Pie(3pm)