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
pyexcelerator
PYEXCELERATOR(1) General Commands Manual PYEXCELERATOR(1)NAME
pyexcelerator - a module for reading/writing Excel spreadsheet files
SYNOPSIS
pyexcelerator
DESCRIPTION
This manual page was written for the Debian distribution because the original program does not have a manual page.
pyExcelerator is a Python module that can generate Excel 97/2000/XP/2003 spreadsheet files. It can also extract data from these files. It
supports Unicode in Excel files, and can use a variety of formatting features and printing options. It can dump Excel and OLE2 compound
files.
Numerous examples of usage can be found in the examples/ directory.
Additions utility scripts can be found in the tools/ directory.
OPTIONS
This program does not take any command line options.
AUTHOR
pyexcelerator was written by Roman V. Kiseliov <roman@kiseliov.ru>.
This manual page was written by Kevin Coyner <kcoyner@debian.org> for the Debian system (but may be used by others). Permission is granted
to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any later version published by
the Free Software Foundation.
On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.
SEE-ALSOpy_xls2csv(1), py_xls2txt(1), py_xls2html(1)
October 12, 2006 PYEXCELERATOR(1)