05-30-2014
FTP XLSX file from UNIX to windows
Hi,
Could someone suggest me how to FTP a xlsx file from unix to windows.
I can able to transfer xls file from unix to windows successfully. But if i transfer the xlsx file im not able to open, it through error like "The file format or file extension is not valid"
Thanks
Rathna
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::line
Excel::Writer::XLSX::Chart::Line(3pm) User Contributed Perl Documentation Excel::Writer::XLSX::Chart::Line(3pm)
NAME
Line - A class for writing Excel Line charts.
SYNOPSIS
To create a simple Excel file with a Line 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 => 'line' );
# 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 Line charts for Excel::Writer::XLSX. The chart object is created via the Workbook "add_chart()" method:
my $chart = $workbook->add_chart( type => 'line' );
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.
Line Chart Methods
There aren't currently any line 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_line.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 => 'line', 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::Line(3pm)