05-30-2014
Check if you are transfering the file in binary mode not in text, since xlsx is nothing more the zip file with xml files inside.
Regards
Peasant.
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::stock
Excel::Writer::XLSX::Chart::Stock(3pm) User Contributed Perl Documentation Excel::Writer::XLSX::Chart::Stock(3pm)
NAME
Stock - A class for writing Excel Stock charts.
SYNOPSIS
To create a simple Excel file with a Stock chart using Excel::Writer::XLSX:
#!/usr/bin/perl -w
use strict;
use Excel::Writer::XLSX;
my $workbook = Excel::Writer::XLSX->new( 'chart.xlsx' );
my $worksheet = $workbook->add_worksheet();
my $chart = $workbook->add_chart( type => 'stock' );
# Add a series for each High-Low-Close.
$chart->add_series( categories => '=Sheet1!$A$2:$A$6', values => '=Sheet1!$B$2:$B$6' );
$chart->add_series( categories => '=Sheet1!$A$2:$A$6', values => '=Sheet1!$C$2:$C$6' );
$chart->add_series( categories => '=Sheet1!$A$2:$A$6', values => '=Sheet1!$D$2:$D$6' );
# Add the worksheet data the chart refers to.
# ... See the full example below.
__END__
DESCRIPTION
This module implements Stock charts for Excel::Writer::XLSX. The chart object is created via the Workbook "add_chart()" method:
my $chart = $workbook->add_chart( type => 'stock' );
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.
Stock Chart Methods
There aren't currently any stock chart specific methods. See the TODO section of Excel::Writer::XLSX::Chart.
The default Stock chart is an High-Low-Close chart. A series must be added for each of these data sources.
EXAMPLE
Here is a complete example that demonstrates most of the available features when creating a Stock chart.
#!/usr/bin/perl
use strict;
use warnings;
use Excel::Writer::XLSX;
use Excel::Writer::XLSX;
my $workbook = Excel::Writer::XLSX->new( 'chart_stock.xlsx' );
my $worksheet = $workbook->add_worksheet();
my $bold = $workbook->add_format( bold => 1 );
my $date_format = $workbook->add_format( num_format => 'dd/mm/yyyy' );
my $chart = $workbook->add_chart( type => 'stock', embedded => 1 );
# Add the worksheet data that the charts will refer to.
my $headings = [ 'Date', 'High', 'Low', 'Close' ];
my $data = [
[ '2007-01-01T', '2007-01-02T', '2007-01-03T', '2007-01-04T', '2007-01-05T' ],
[ 27.2, 25.03, 19.05, 20.34, 18.5 ],
[ 23.49, 19.55, 15.12, 17.84, 16.34 ],
[ 25.45, 23.05, 17.32, 20.45, 17.34 ],
];
$worksheet->write( 'A1', $headings, $bold );
for my $row ( 0 .. 4 ) {
$worksheet->write_date_time( $row+1, 0, $data->[0]->[$row], $date_format );
$worksheet->write( $row+1, 1, $data->[1]->[$row] );
$worksheet->write( $row+1, 2, $data->[2]->[$row] );
$worksheet->write( $row+1, 3, $data->[3]->[$row] );
}
$worksheet->set_column( 'A:D', 11 );
# Add a series for each of the High-Low-Close columns.
$chart->add_series(
categories => '=Sheet1!$A$2:$A$6',
values => '=Sheet1!$B$2:$B$6',
);
$chart->add_series(
categories => '=Sheet1!$A$2:$A$6',
values => '=Sheet1!$C$2:$C$6',
);
$chart->add_series(
categories => '=Sheet1!$A$2:$A$6',
values => '=Sheet1!$D$2:$D$6',
);
# Add a chart title and some axis labels.
$chart->set_title ( name => 'High-Low-Close', );
$chart->set_x_axis( name => 'Date', );
$chart->set_y_axis( name => 'Share price', );
$worksheet->insert_chart( 'E9', $chart );
__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::Stock(3pm)