01-10-2012
Are you comfortable w using Perl? There are a few modules that parse/read-write excel formats.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi!
I'm using SunOS 5.7 w/ Bash 2.01.
Currently, I'm working on a script that will make it possible to find textfiles which match certain criteria. While I write this message, I had some brainfarts, found the answer myself :D and the question I had in mind is now no longer the question I... (3 Replies)
Discussion started by: indo1144
3 Replies
2. Shell Programming and Scripting
Hi,
Can anyone tell the option to change the file type in unix.
i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format.
Thanks in advance,
Milton. (1 Reply)
Discussion started by: miltony
1 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. UNIX for Advanced & Expert Users
Hi All,
I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box .
I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column... (1 Reply)
Discussion started by: krthkmuthu
1 Replies
5. Shell Programming and Scripting
Hi All,
Please give me the solution to the following ASAP.
1) Converting the .xls into .csv
Script i tried,
mv hello.xls hello.csv
The above given script converting the .xls file into .csv successfully. But after i run the below unix command I am no able to open the .csv file, its giving... (4 Replies)
Discussion started by: velava
4 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. Shell Programming and Scripting
i have installed CENTOS in VMware. I want the linux command to run in CENTOS.
The command is to select data's from Event table(our table name) convert into .xls and mail every 2hrs. Can you please help me in writing this script.
Thanks,
Shobana (1 Reply)
Discussion started by: shobana praveen
1 Replies
8. UNIX for Advanced & Expert Users
Hey Guys ,
Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below :
1. Convert one XLS file with multiple tabs to multiple CSV files.
-- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But... (2 Replies)
Discussion started by: himanshu sood
2 Replies
9. Emergency UNIX and Linux Support
Hey Guys ,
Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below :
1. Convert one XLS file with multiple tabs to multiple CSV files.
-- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But... (6 Replies)
Discussion started by: himanshu sood
6 Replies
10. 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
LEARN ABOUT DEBIAN
go-show-paths-to-root
GO-SHOW-PATHS-TO-ROOT(1p) User Contributed Perl Documentation GO-SHOW-PATHS-TO-ROOT(1p)
NAME
go-show-paths-to-root.pl - shows all possible paths from a term to the top
SYNOPSIS
go-show-paths-to-root.pl -id GO:0008021 ontology/gene_ontology.obo
go-show-paths-to-root.pl -names -id GO:0008021 ontology/gene_ontology.obo
DESCRIPTION
traverses DAG showing all paths (terms and intervening relationships) to the root
This script is purely file based; it needs to parse the ontology each time
Subsequent parses can be speeded up using the use_cache option
If you wish to use the GO MySQL db, see the script go-db-show-paths-to-root.pl in the go-db-perl distribution
ARGUMENTS
-e ERRFILE
writes parse errors in XML - defaults to STDERR (there should be no parse errors in well formed files)
-p FORMAT
determines which parser to use; if left unspecified, will make a guess based on file suffix. See below for formats
-use_cache
If this switch is specified, then caching mode is turned on.
With caching mode, the first time you parse a file, then an additional file will be exported in a special format that is fast to parse.
This file will have the same filename as the original file, except it will have the ".cache" suffix.
The next time you parse the file, this program will automatically check for the existence of the ".cache" file. If it exists, and is more
recent than the file you specified, this is parsed instead. If it does not exist, it is rebuilt.
DOCUMENTATION
<http://www.godatabase.org/dev>
perl v5.14.2 2010-05-12 GO-SHOW-PATHS-TO-ROOT(1p)