Writing to an Excel file layout is possible, but can be complicated and requires add-ons.
One way many write to Excel is to create csv files. For instance, if you create a file called output.csv:
output.csv
Excel would read this as a spreadsheet with three rows of data, each row with three columns. Would this accomplish what you want?
Thanks for your posting. This format is fine for me. What can be the approach for this?
I have 3 columns in an excel sheet.
c1 c2 c3
EIP_ACCOUNT SMALL_TS_01 select A.* from acc;
All the above 3 col shoud be passed a variable in the unix code.
1.How to read an excel file
2.How to pass these data as variable to the unic script (1 Reply)
Hi,
I need to email a data in excel sheet from unix using shell scripting.I could able to generate the data file with tab delimiter with extension .xls could able to email it.
The problem is when a coulmn with 16 digit number is exported, it is showing in scientific format. Any help in... (1 Reply)
Hi,
How to extract the data from Oracle database and sent the output data to mails using mailx command with .xls attachement?
Here i know how to connect the database using unix shell script and
how to use the mailx command in UNIX script
But i don't know how to use the .xls format file (i... (1 Reply)
Am currently working on CVS projects .. I have generated the cvs log file which is in the RCS file format . .I want to extract file path ,total revision ,date ,author and message from that file . .I want a program in java which would extract the data from cvs log file. .Pls help me out..
My... (0 Replies)
Hi,
i have some data in a temporary file in Unix (the data is taken from the result of an SQL query). Now i want to dump that data into an excel sheet. How to do that. Someone please advise. Thanks
Regards,
Vinit (3 Replies)
Hi guys - I have a file and output like this below:
File: myfile.dat
File has content like this: ABCD, 34, 456, 2324
I would like excel to have this:
Name (ABCD) Quantity (34), Type (456), Status (2324)
(Name, Quantity, Type and Status are columns)
I would like to export... (4 Replies)
Hi,
I would like to extract the data from particular date,
1. may i know which command i need to use?
2. Extract from unix command (those extracted above) to excel?
Please assist.
Thanks (2 Replies)
Discussion started by: Peru
2 Replies
LEARN ABOUT DEBIAN
mongo
MONGO(1) Mongo Database MONGO(1)NAME
mongo - the Mongo command-line tool
SYNOPSIS
mongo [OPTIONS] [DB_ADDRESS] [FILE+]
DESCRIPTION
mongo is a JavaScript shell (with GNU readline capabilities). It supports interactive and non-interactive use. When used interactively,
JavaScript can be used to query the database or perform any other function normally available with SpiderMonkey. Database output is dis-
played in JSON format.
If JavaScript files are specified on the command line, the shell will run non-interactively, running each one in sequence and then exiting.
EXAMPLES
mongo start the shell, connecting to the server at localhost:27017 and using the test database
mongo foo
start the shell using the foo database at localhost:27017
mongo 192.169.0.5/foo
start the shell using the foo database at 192.169.0.5:27017
mongo 192.169.0.5:9999/foo
start the shell using the foo database at 192.169.0.5:9999
mongo script1.js script2.js script3.js
run three scripts and exit
OPTIONS --shell
run the shell after executing files
--help show usage information
--host HOST
server to connect to (default HOST=localhost)
--port PORT
port to connect to (default PORT=27017)
--nodb do not connect to mongod
--eval SCRIPT
evaluate JavaScript
-u USERNAME
specify user to log in as
-pPASSWORD
specify password of user (notice there is no space)
COPYRIGHT
Copyright 2007-2009 10gen
SEE ALSO
For more information, please refer to the MongoDB wiki, available at http://www.mongodb.org.
AUTHOR
Kristina Chodorow
10gen June 2009 MONGO(1)