08-16-2013
UNIX data to be updated to ms excel sheet
hi,
i wanted to add unix data to be updated to the excel sheet.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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)
Discussion started by: Anne Grace
1 Replies
2. Shell Programming and Scripting
Hi all
I have a shell script that uses a stored proc to generate output from some tables and send the same in an e-mail using mailx command. Now I need to convert the output to excel format and send e-mail. How can I achieve this. Please help me in this regard, as it's very urgent and I have been... (5 Replies)
Discussion started by: sanbabu
5 Replies
3. Shell Programming and Scripting
Hi,
I have an excel sheet which has 100000 records. All these records are having 3 columns each with the last column as "Y" or "N". I would like to filter those records which has the value "Y". Can you please let me know how to proceed with that?
Thanks in advance.
-Sri
----------... (8 Replies)
Discussion started by: bhanusri83
8 Replies
4. Shell Programming and Scripting
Hi
HOWTO create in UNIX a Microsoft Excel sheet (with data from Oracle). At the moment I am making CSV files (using SQL statemens with || ';'), but search for more advanced formatting. Don't wish to use Perl.
cheers (4 Replies)
Discussion started by: slashdotweenie
4 Replies
5. Shell Programming and Scripting
Hi folks,
I am working on assignment that captures all the records(2 columns one column contains names and other contain date of birth) from excel sheet stored in a directory and checks for current date and month.
If it matches current date and month then the matched records are printed as... (1 Reply)
Discussion started by: giridhar276
1 Replies
6. Programming
guys i have data in excel sheet , how do i convert that data to database table (2 Replies)
Discussion started by: Gl@)!aTor
2 Replies
7. Shell Programming and Scripting
Hi All, Firstly I will like to wish A Happy New Year to all.
Now my issue is
I have one csv file say(data.csv) and one excel file say(result.xls)
The result.xls contains two sheet name Sheet1 and Sheet2, Now What I am trying to do is to First I want to delete that data of Sheet2 if present any,... (6 Replies)
Discussion started by: adisky123
6 Replies
8. UNIX for Dummies Questions & Answers
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)
Discussion started by: vinit raj
3 Replies
9. Shell Programming and Scripting
Hello,
I have the following data format in a log file :
a : x1
b : x2
c : x3
d : x4
--------
a : x5
b : x6
c : x7
d : x8
so the same fields ( a ,b ,c,d) repeated many times in the same log file but with different "x" values (x5,x6,x7,x8).
I need a script to save this data in an... (6 Replies)
Discussion started by: mm00123
6 Replies
10. Shell Programming and Scripting
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies
LEARN ABOUT DEBIAN
bookletimposer
BOOKLETIMPOSER(1) General Commands Manual BOOKLETIMPOSER(1)
NAME
bookletimposer - An utility to reorganize PDF pages
SYNOPSIS
bookletimposer [options] [input-file]
bookletimposer -a [options] input-file
DESCRIPTION
bookletimposer is an utility to achieve some basic imposition on PDF documents, especially designed to work on booklets.
It allows:
o to transform linear documents to booklets;
o to reduce a document to put many on one sheet (for tracts for example);
o to transform booklets to linear documents.
It is a free software released under the GNU General Public License, either version 3 or (at your option) any later version.
OPTIONS
--version
show program's version number and exit.
-h, --help
show an help message and exit.
-o OUTFILE, --output=OUTFILE
set output PDF file to OUTFILE.
-a, --no-gui
automatic converstion (don't show the user interface). In that mode, the input file must be defined.
-i, --gui
show the user interface (default).
-b, --booklet
produce a booklet out of a linear document (default).
-l, --linearize
produce a linear document out of a booklet.
-n, --no-reorganisation
don't reorganize (will only scale and assemble pages).
-c, --copy-pages
copy the same group of input pages on one output page.
-p PAGES_PER_SHEET,
--pages-per-sheet=PAGES_PER_SHEET
number of pages per sheet, in the format HORIZONTALxVERTICAL, e.g. 2x1.
-f OUTPUT_FORMAT,
--format=OUTPUT_FORMAT
output page format, e.g. A4 or A3R.
-k, --keep
do not overwrite output file if it exists.
EXAMPLES
bookletimposer
Displays the GTK+ user interface.
bookletimposer --no-gui --booklet --pages-per-sheet=2x1
--output=out.pdf in.pdf
Converts in.pdf into a booklet with two pages per sheet an saves the result as out.pdf.
bookletimposer --no-gui --linearise --pages-per-sheet=2x1 in.pdf
Converts the two-pages-per-sheet booklet in.pdf into a page-by-page PDF. As the output file name is not defined, it will default to in-
conv.pdf.
SEE ALSO
pdfshuffler(1)
BookletImposer source code and documentation can be found on the web at <https://kjo.herbesfolles.org/bookletimposer/>
KNOWN ISSUES
BookletImposer is under development, which means that for the moment, some things work, some others do not... Thanks to report bugs to
<kjo@a4nancy.net.eu.org> if you find some!
AUTHORS
Kjo Hansi Glaz <kjo@a4nancy.net.eu.org>.
bookletimposer user manual 2012 BOOKLETIMPOSER(1)