06-03-2014
Probably the issue is then on server side, which is stopping you from upload of xlsx file based on some kind of file extension check on the server side.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Is there a way to ftp file from windows to Unix directory by using crontab to set up a job ?
Thanks! (4 Replies)
Discussion started by: whatisthis
4 Replies
2. Shell Programming and Scripting
Hi
I'm new working in UNIX, So, I want to know How I can send a file from UNIX to Windows server with FTP. This is my script.
ftp -i -n -v <<**
open 199.99.99.99
user user1 password1
lcd C01_07_06 /* source/
cd //199.98.98.98/group1/reports /*destination*/
put file1.sh ... (1 Reply)
Discussion started by: edzela
1 Replies
3. Shell Programming and Scripting
I need your help for a FTP Job to be schedule to copy files from windows to Unix.
in a set of time interval.
My requirement is as follows.
1.Script should check whether file is available in the windows folder ,
if available then do FTP to unix server , and then move... (3 Replies)
Discussion started by: sandeep.kamble
3 Replies
4. Shell Programming and Scripting
I run an application that creates a hostname_log.txt file on the c:\ of each windows workstation.
At the end of each day, these log files are FTP'd to a directory on a UNIX box.
When I run "ls -lrt", the timestamp that is displayed is the timestamp that the FTP occured, not the timestamp... (2 Replies)
Discussion started by: gavman99
2 Replies
5. Shell Programming and Scripting
Hi,
I have a ftp script to ftp files from unix to windows. Now i need to pull the latest file from unix to windows. It is not working.
ftp -nvi $SERVER > ${FILE_DIR}/NavigationftpLog << EOD
user $USER $PWD
lcd $FILE_DIR
echo "the local directory is $FILE_DIR"
cd $Remote_PATH
echo... (2 Replies)
Discussion started by: ammu
2 Replies
6. Shell Programming and Scripting
Hi all,
I have a file in windows, example
a.txt
****
aaa
bbb
ccc
<empty line>
when i transfer this file to unix using ftp, and viewed the file
# vi a.txt
aaa
bbb
ccc
#
I dont get the empty line which i specified in that file in windows.
Please help me, which in unix... (5 Replies)
Discussion started by: Nandagopal
5 Replies
7. Shell Programming and Scripting
Hi, I am new to this subject.....Can someone please help me out with the script...
unix usernm "sdhftst"
unix pwd "chsd13"
windows usernm "dfghtst"
windows pwd "chsd13"
path..../xxx/xxxxx/xxxxxx/xxxxxxx
please can u get me a script...its only one file to get ftp.
Thanks... (2 Replies)
Discussion started by: himakiran9
2 Replies
8. Shell Programming and Scripting
I have a problem with ftp. i want to ftp a file "file.txt" from unix box to windows server.
The destination folder is something like this:
"\\windowsservername\apps\is\"
FTPUSER=ftp1
FTPPASS=****
ftp -v -d -n > ftplog <<!EOF
open windowsservername
user $FTPUSER $FTPASS
cd... (3 Replies)
Discussion started by: Diddy
3 Replies
9. Shell Programming and Scripting
Hi all..
Please help me on below requirement.
I have an excel file ftped from windows to unix location. I am not able to open the file. if i am opening it in vi editor, i am getting only junk characters. I have to make the excel file as .csv file and read the data to put some business... (3 Replies)
Discussion started by: gani_85
3 Replies
10. Shell Programming and Scripting
Guys,
I've a xlsx file containing pivot tables and my job is to FTP it from one Linux terminal to another.
I use the script below :
ftp -in xxxx > /ftp.log 2>&1 <<EOT
user xxx yyyy
binary
cd <directory>
put xxx.xlsx `basename xxx.xlsx`
bye
EOT
After the file is received in the FTP... (2 Replies)
Discussion started by: bhagat.singh-j
2 Replies
LEARN ABOUT DEBIAN
excel::writer::xlsx::chart::scatter
Excel::Writer::XLSX::Chart::Scatter(3pm) User Contributed Perl Documentation Excel::Writer::XLSX::Chart::Scatter(3pm)
NAME
Scatter - A class for writing Excel Scatter charts.
SYNOPSIS
To create a simple Excel file with a Scatter 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 => '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 Excel::Writer::XLSX. 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 Excel::Writer::XLSX::Chart. Class specific methods or settings, if any, are explained below.
Scatter Chart Methods
The "Scatter" chart module also supports the following sub-types:
markers_only (the default)
straight_with_markers
straight
smooth_with_markers
smooth
These can be specified at creation time via the "add_chart()" Worksheet method:
my $chart = $workbook->add_chart(
type => 'scatter',
subtype => 'straight_with_markers'
);
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_scatter.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 ],
[ 10, 40, 50, 20, 10, 50 ],
[ 30, 60, 70, 50, 40, 30 ],
];
$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.
$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. Colors with white outline and shadow.
$chart->set_style( 10 );
# 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::Scatter(3pm)