11-17-2013
hi,
more probably, your .xls file is not an xls file.
what does answer ``file yourFile.xls'' ?
I've already downloaded files as .xls which were in fact html ones.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Is it possible to convert an excel file into a text file using standard HP UNIX commands? Possibly in K Shell? (5 Replies)
Discussion started by: stevefox
5 Replies
2. UNIX for Advanced & Expert Users
I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner.
I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
I have to convert the excel file which will be placed in the Unix box to a CSV file using a shell script.
Please Advise.
Thanks & Regards,
Kumar66 (1 Reply)
Discussion started by: kumar66
1 Replies
4. Shell Programming and Scripting
Dear Members,
I am using the attached script to convert a input file delimited by '|' to excel.
However, while processing the attribute change_reason, the whole content of the text under change_reason is not displayed completely in the cell in excel. It is truncated after only first few words.... (1 Reply)
Discussion started by: Yoodit
1 Replies
5. Shell Programming and Scripting
Hi All,
Can you please suggest me how to convert excel format to ‘|' delimiter file. I need to use perl script
Thanks
Rama (5 Replies)
Discussion started by: murari83.ds
5 Replies
6. Shell Programming and Scripting
Hi list,
This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module.
I have an excel document with multiple tabs of data and graphs.
One of the tabs is just data which I require to have dumped to... (8 Replies)
Discussion started by: landossa
8 Replies
7. Programming
guys i have data in excel sheet , how do i convert that data to database table (2 Replies)
Discussion started by: Gl@)!aTor
2 Replies
8. Shell Programming and Scripting
Hi I have a dat file which has "n" number of columns. The file is delimited. The number of columns keep varying as the file is generated out of DB queries. Could you please help me in writing a script which will generate a XLS or CSV file out of the dat file. (5 Replies)
Discussion started by: Vee
5 Replies
9. UNIX for Dummies Questions & Answers
Hi All,
I have a csv file in unix and I need to convert it into excel formate.
Please help me out (1 Reply)
Discussion started by: Abhisrajput
1 Replies
10. Shell Programming and Scripting
Hello,
For i while i have been using XMLStarlet to convert several XML files to CSV files. So far this always went fine.
Today however i got a new XML format however but i cannot find out how to get the data i need.
Below is part of the code where it shows the different format. What... (10 Replies)
Discussion started by: SDohmen
10 Replies
LEARN ABOUT DEBIAN
test::excel::template::plus
Test::Excel::Template::Plus(3pm) User Contributed Perl Documentation Test::Excel::Template::Plus(3pm)
NAME
Test::Excel::Template::Plus - Testing module for use with Excel::Template::Plus
SYNOPSIS
use Test::More tests => 1;
use Test::Excel::Template::Plus;
my $template = Excel::Template::Plus->new(
engine => 'TT',
template => 'test.tmpl',
config => { INCLUDE => [ '/templates' ] },
params => { ... }
);
$template->write_file('test.xls');
# compare the file we just made with
# an existing example file ...
cmp_excel_files("test.xls", "t/xls/test.xls", '... the excel files matched');
DISCLAIMER
This module is woefully incomplete. It works for my very basic purposes right now, but it is surely going to need lots or work in the
future to make it really usable.
DESCRIPTION
This module attempts to provide a means of testing and comparing dynamically generated excel files. Currently it only supports comparing
two excel files for some approximation of strutural (values within cells) and visual (formatting of said cells) equivalence.
As a by product of the implementation, elements may get compared which don't really need comparing, and things which do need comparing may
be skipped. This will get refined as time goes by and the module is used in more heavyweight situations.
FUNCTIONS
cmp_excel_files($file1, $file2, $msg)
BUGS
All complex software has bugs lurking in it, and this module is no exception. If you find a bug please either email me, or add the bug to
cpan-RT.
AUTHOR
Stevan Little <stevan@iinteractive.com>
COPYRIGHT AND LICENSE
Copyright 2007-2010 by Infinity Interactive, Inc.
<http://www.iinteractive.com>
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-05-06 Test::Excel::Template::Plus(3pm)