08-01-2012
any help on this will be much appreciated..
Thanks in advance...
Regards,
Giridhar S
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,
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
3. Shell Programming and Scripting
I need to insert new column to already existing file ..can any one help me..?? (6 Replies)
Discussion started by: kavi.mogu
6 Replies
4. 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
5. 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
6. Shell Programming and Scripting
Hi folks,
I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx).
Spreadsheet contains few lines of hyperlink data (pic attached).
P.S. Hyperlink is behind the data and not visible in excel sheet directly.
Now using perl script I need to copy the hyperlinks in... (3 Replies)
Discussion started by: scriptscript
3 Replies
7. 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
8. UNIX for Dummies Questions & Answers
hi,
i wanted to add unix data to be updated to the excel sheet. (3 Replies)
Discussion started by: rupesh.bombale
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
odfbuild
ODFBUILD(1p) User Contributed Perl Documentation ODFBUILD(1p)
NAME
odfbuild - OpenDocument file creation utility
SYNOPSIS
odfbuild filename.odt
odfbuild filename.odt --title "My Document" --subject "Test"
odfbuild filename.ods --class spreadsheet --source "data.csv" --tablesize "8x16"
cat data.txt | odfbuild filename.odt -
OPTIONS
--class Document class (text, spreadsheet, drawing, presentation)
Default: text
--opendocument (no value). If this option is on, the document will be in
OpenDocument format. Without this option, the format will
be selected according to the general configuration of the
OpenOffice::OODoc installation.
--creator The author of the document. Default: the current user's
login name.
--date Creation date. Default is current local time.
If provided, must be in ISO-8601 format
(YYYY-MM-DDTHH:MM:SS)
--description The description (abstract) of the document. Default: none.
--force (no value). If this option is on, any existing file with
the same path as the target file will be replaced. Without
this option, the program will fail if the target exists.
--generator Software signature to be stored in the file (not visible
for the end user).
Default: "Genicorp OpenOffice::OODoc <version>"
--keywords A list of comma-separated keywords. Default: none.
--source A text file, to be used as the content of the document.
If the document class is 'text', each line is loaded as a new
paragraph with the standard style. If the document class is
'spreadsheet', the file is processed as CSV data and loaded
in one sheet. If the document class is neither 'text' nor
'spreadsheet', the file is not processed.
If source = '-', or if a '-' argument is provided, the data
file is read through the standard input.
--subject The subject of the document. Default: none.
--tablename The name of the sheet to be created if the document class is
'spreadsheet' and if a data file is provided. Default: the name
of the data file, or "Unnamed Sheet" if the data is read from
the standard input.
--tablesize The size of the sheet to be created if the document class is
'spreadsheet' and if a data file is provided, in 'HxW' format
where H is the number of lines and W the number of columns.
Default: '16x8'
--title The title of the document. Default: "Untitled".
--readable_XML (no value). For debugging only. If this option is on, the XML
content of the target file is indented, in order to be later
edited.
perl v5.14.2 2008-05-07 ODFBUILD(1p)