11-17-2011
thanks Jayan .... it worked
10 More Discussions You Might Find Interesting
1. 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
2. Shell Programming and Scripting
how to convert a xls file into .csv file?
is tghere any command in unix for that?
please help
thanks (3 Replies)
Discussion started by: infyanurag
3 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 does anybody know how to convert xls to csv undex linux.
I need only data (that is log from test, dont need any macro and so on) from xls.
Any idea how to do that? Perl? shell? Could you give me any example?
Thanks in advance for answer.
Gracjan (4 Replies)
Discussion started by: Gracjan
4 Replies
5. Shell Programming and Scripting
Hi,
I have problem..How to convert .xls file to .csv..
Plz help me for this problem.. (1 Reply)
Discussion started by: varma457
1 Replies
6. Shell Programming and Scripting
Ok, every morning at my office we send out excel sheets to Economy people with statistics for yesterdays trading.
All the trading run's in Redhat or Solaris environments.
We run a script on a Redhat server whitch generates the stats in CSV format.
After we download we open it in Excel and... (3 Replies)
Discussion started by: chipmunken
3 Replies
7. Shell Programming and Scripting
I would like to know if have one way with read table from oracle converter in CSV o TXT and After converter in XLS or spreedsheet
Thanks so much
JAvier (3 Replies)
Discussion started by: javeiregh
3 Replies
8. Shell Programming and Scripting
Hello,
I have one csv file(";" separated). I would like to mail it as an attachment in xls format.
I tried it using below command but its coming in one column. I wan to have different columns as per delimiter ";".
unix2dos FILENAME | uuencode FILENAME FILENAME.xls | mailx -s "Hi" mailid... (1 Reply)
Discussion started by: skhichi
1 Replies
9. Shell Programming and Scripting
Hello
I have a script which converts log to csv.
Now I need to have xls.
Is there any easy way/command which can convert csv to xls?:confused:
preferably just using bash and not perl,... is it possible? (1 Reply)
Discussion started by: frhling
1 Replies
10. UNIX for Dummies Questions & Answers
Hi
I have a mail attachment coming from a mail id and evreytime with the same name in .xls format.I have to download the .xls file into a location and convert it itno .csv format and copy the .csv file to another location. (1 Reply)
Discussion started by: bikky6
1 Replies
LEARN ABOUT DEBIAN
bb-csvinfo.cgi
BB-CSVINFO.CGI(1) General Commands Manual BB-CSVINFO.CGI(1)
NAME
bb-csvinfo.cgi - CGI program to show host information from a CSV file
SYNOPSIS
bb-csvinfo.cgi
DESCRIPTION
bb-csvinfo.cgi is invoked as a CGI script via the bb-csvinfo.sh CGI wrapper. Based on the parameters it receives, it searches a comma-
separated file for the matching host, and presents the information found as a table.
bb-csvinfo.cgi is passed a QUERY_STRING environment variable with the following parameters:
key (string to search for, typically hostname)
column (columnnumber to search - default 0)
db (name of the CSV database file in $BBHOME/etc/, default hostinfo.csv)
delimiter (delimiter character for columns, default semi-colon)
CSV files are easily created from e.g. spreadsheets, by exporting them in CSV format. You should have one host per line, with the first
line containing the column headings. Despite their name, the default delimiter for CSV files is the semi-colon - if you need a different
delimiter, invoke bb-csvinfo.cgi with the "delimiter=<character>" in the query string.
Example usage
This example shows how you can use the bb-csvinfo CGI. It assumes you have a CSV-formatted file with information about the hosts stored as
$BBHOME/etc/hostinfo.csv, and the hostname is in the first column of the file.
Use with the bbgen --docurl
The --docurl option to bbgen(1) sets up all of the hostnames on your Xymon webpages to act as links to a CGI script. To invoke the
bb-csvinfo CGI script, run bbgen with the option
--docurl=/cgi-bin/bb-csvinfo.sh?db=hostinfo.csv&key=%s
SEE ALSO
bb-hosts(5), hobbitserver.cfg(5), bbgen(1)
Xymon Version 4.2.3: 4 Feb 2009 BB-CSVINFO.CGI(1)