07-20-2011
Hi kshji,
sorry for the confusion
I have tested the above script
I have one problem
Suppose i have recived file like
201005_FIRST_LAST_20110512.xls
I need to populate target like
FIRST_LAST.xls
The above scripting is failing this file.
can you please updat me the script
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
please help me out in below requirement.
I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side
Ex:
abc.xls
Eno Ename
101 hello
102 hero
103 india
bbc.xls
Eno Ename
201 delhi
202 Hyd
203... (0 Replies)
Discussion started by: jagadish99
0 Replies
2. Shell Programming and Scripting
Hi all,
please help me out in below requirement.
I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side
Ex:
abc.xls bbc.xls
Eno Ename Eno Ename
101 hello ... (2 Replies)
Discussion started by: jagadish99
2 Replies
3. Shell Programming and Scripting
I need to convert an excel file into a text file
and an excel file into a CSV file..
any code to do that is appreciated
thanks (6 Replies)
Discussion started by: bandar007
6 Replies
4. Shell Programming and Scripting
Hi,
I'm desperately in search for a solution of the following problem:
I have a directory full of zip-files. All these zip-files contain a single file with a name that should be used for the name of the zip-container.
Anybody a good idea. I'm an absolute beginner in shell scripting - so please... (7 Replies)
Discussion started by: mark_a17
7 Replies
5. Shell Programming and Scripting
Hi Guys!
1st of all, i am sorry for my bad english!
I got a Sat-Receiver and i recorded some Stuff for my Children, now the Harddrive is full and i want to convert and rename it, that i can put it on DVDs
But I've got a big Problem!
I want to rename the files , with a tag in a xml file... (4 Replies)
Discussion started by: crusty
4 Replies
6. Shell Programming and Scripting
Hello to all,
I have a zip file with any name like FileName.zip, within the zip file there are more than 30 files with different extensions in the following format.
FileName_BMN_ROSJ.txt
FileName_THEUS.jpg
.
.
.
FileName_KWPWP.shx
I would like to unzip the file and rename each file... (2 Replies)
Discussion started by: Ophiuchus
2 Replies
7. Shell Programming and Scripting
Hi guys,
I want to change the name of zip file and the files in zip. eg. there are two zip files 100_ABC_20101020.zip 101_ABC_20101020.zip
100_ABC_20101020.zip
|
--100_A_20101020.txt
--100_B_20101020.txt
--100_C_20101020.txt
101_ABC_20101021.zip
|
... (0 Replies)
Discussion started by: ambious
0 Replies
8. Shell Programming and Scripting
Hi All,
I've got in a situation where I need to convert .xlsx or .xls formatted files into simple text file or .csv file.
I've found many options but doing this using PERL script is the best way I believe.I'm in AIX box.
Perl code should have 2 params while running. i.e
perl... (1 Reply)
Discussion started by: manab86
1 Replies
9. Shell Programming and Scripting
HI,
I have multiple files per dept in folder
for eg : In a folder
File1_Dept100.xls
File2_Dept100.xls
File3_Dept100.xls
File1_Dept200.xls
File2_Dept200.xls
File3_Dept200.xls
Output should be :
Dept100.xls which has File1, File2, File3 in different tabs
Dept200.xls which has... (1 Reply)
Discussion started by: venkyzrocks
1 Replies
10. Shell Programming and Scripting
Hello, I have a text file "file.list" with the contents below.
file1
filename1
file2
filename2
file3
filename3
file1, file2 and file3 are files existing in the same directory as the text file file.list.
I want to rename file1 to filename1, file2 to filename2, as show in the text... (1 Reply)
Discussion started by: james2009
1 Replies
LEARN ABOUT DEBIAN
runxlrd
RUNXLRD(1) General Commands Manual RUNXLRD(1)
NAME
runxlrd - extract data from Microsoft Excel spreadsheet files
SYNOPSIS
runxlrd [options] command [input-file-patterns]
DESCRIPTION
This manual page documents briefly the runxlrd command.
runxlrd offers a commandline interface to the Python xlrd module; it extracts data from Microsoft Excel spreadsheet files.
OPTIONS
-h, --help
Show summary of options and exit.
-l logfilename
Contains error messages.
-v verbosity, --verbosity=verbosity
Level of information and diagnostics provided.
-p pickleable, --pickleable=pickleable
1: ensure Book object is pickleable (default); 0: don't bother.
-m mmap, --mmap=mmap
1: use mmap; 0: don't use mmap; -1: accept heuristic.
-e encoding, --encoding=encoding
Encoding override.
-f formatting, --formatting=formatting
0 (default): no fmt info 1: fmt info (all cells) 2: fmt info (margins trimmed).
-g gc, --gc=gc
0: auto gc enabled; 1: auto gc disabled, manual collect after each file; 2: no gc.
-s onesheet, --onesheet=onesheet
Restrict output to this sheet (name or index).
COMMANDS
Valid commands are
o dump
o count_records
o version
o hdr
o ov
o show
o 2rows
o 3rows
o bench
o names
o name_dump
o labels
o xfc
o hotshot
o profile
See the xlrd API documentation for the meaning of these commands.
EXAMPLES
To show the first, second and last rows of each sheet in each file, run
$ runxlrd 3rows *blah*.xls
Run
$ runxlrd -e koi8_r 3rows myfile.xls
to explicitly pass the needed codepage to xlrd, e.g. if the codepage record is missing, or if it exists but is wrong.
SEE ALSO
The xlrd API documentation, shipped in the file xlrd.html.
The xlrd website <http://www.lexicon.net/sjmachin/xlrd.htm>.
AUTHOR
runxlrd was written by John Machin.
This manual page was written by Joost van Baal <joostvb+debian@uvt.nl>, for the Debian project (but may be used by others).
xlrd 0.6.1a4 2007-05-24 RUNXLRD(1)