04-03-2018
Creating an excel file with filters using shell script.
Hi All,
I am new to shell scripting.
I have made a script that can convert an excel file from cvs file.
This excel file contains hundreds of records and i would like the reader to be able to filter.
Is it possible to create an excel file with filters? or that functionality has not been implemented yet?
Thanks to all!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Kindly help,
Suppose i am having a file that has got the following contents. Is there any way (eg. sed command) to remove the (*) (*any number) pattern.
se.bas
tulf.h
(1)
tuna.c
(1)
tunsim.c
(1)
tus.cpp
(1)
vp.c
(1)
vp.h
(1)
vpi.
(1) (1 Reply)
Discussion started by: frozensmilz
1 Replies
2. Shell Programming and Scripting
Hi,
I am having a business file in excel having charts based on data already present on it. I would like to add new rows after the existing data and refesh the chart on it using shell script.
For example--
In excel file in "sheet1", There is some data in first 10 rows ( from column A to F).... (0 Replies)
Discussion started by: sanjay1979
0 Replies
3. Shell Programming and Scripting
Hi,
Can any one tell me how to put data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column.
Say my text file data is:
15-dec-2008 15-dec-2009
16-dec-2008 16-dec-2009
say my first... (1 Reply)
Discussion started by: siri_886
1 Replies
4. UNIX for Dummies Questions & Answers
Is it possible to read an excel sheet using shell script ? (2 Replies)
Discussion started by: hiten.r.chauhan
2 Replies
5. UNIX for Advanced & Expert Users
Hi.
I wish to add data in a specific excel file on daily basis.However the currect dat's data should always come on top i.e for example should always occupy cell A7,B7,C7 ..
and the data of day before which was earlier on 7th row of each coloumn should move to 8th row..data on 8th row should... (1 Reply)
Discussion started by: kanus
1 Replies
6. Shell Programming and Scripting
Hi All,
Following is my requirement. I have searched the site and found some threads which has same queries, but non of them have any answer. I thought of posting it once more.
We are generating different reports through shell script after we finish our data load. Currently there are 7 such... (5 Replies)
Discussion started by: ace_friends22
5 Replies
7. Shell Programming and Scripting
Hi I have a dat file which has "n" number of columns. The file is delimited. The number of columns keep varying as the file is generated out of DB queries. Could you please help me in writing a script which will generate a XLS or CSV file out of the dat file. (5 Replies)
Discussion started by: Vee
5 Replies
8. UNIX for Dummies Questions & Answers
Hi,
i have shell script which compiles n number of test cases and execute them one by one. i want to create report in excel through script in which two columns namely "test id" and "release".second column have two subcolumns namely compiles and excutes. so i want first column should display test... (15 Replies)
Discussion started by: RamMore123
15 Replies
9. Shell Programming and Scripting
Hi Everyone,
I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet.
Example input:
IpAdress:InstanceName:Port:ServerName
10.255.255.1:abc:2232:xyz_abc
Output should be an excel sheet like below:
Column... (8 Replies)
Discussion started by: akabhinav18
8 Replies
10. Programming
Hello,
I have an excel sheet with 11 tabs. I need to take data from the first tab and write the output to the second tab. The first tab looks like this, starting from Row 3
The filters that needs to be created are
1) keep anything greater than 'POS' 5 and less than 160 AND
2)... (2 Replies)
Discussion started by: nans
2 Replies
LEARN ABOUT DEBIAN
cvs-debuild
CVS-DEBUILD(1) General Commands Manual CVS-DEBUILD(1)
NAME
cvs-debuild - build a Debian package using cvs-buildpackage and debuild
SYNOPSIS
cvs-debuild [debuild options] [cvs-buildpackage options] [--lintian-opts lintian options]
DESCRIPTION
cvs-debuild is a wrapper around cvs-buildpackage to run it with debuild as the package-building program. (This cannot simply be accom-
plished using the -C option of cvs-buildpackage, as it does not know how to handle all of the special debuild options.)
The program simply stashes the debuild and lintian options, and passes them to debuild when it is called by cvs-buildpackage. All of the
standard debuild options may be used (as listed below), but note that the root command specified by any --rootcmd or -r command-line option
will be passed as an option to cvs-buildpackage. The first non-debuild option detected will signal the start of the cvs-buildpackage
options.
The selection of the root command is slightly subtle: if there are any command-line options, these will be used. If not, then if cvs-
buildpackage is set up to use a default root command, that will be used. Finally, if neither of these are the case, then debuild will use
its procedures to determine an appropriate command, as described in its documentation.
See the manpages for debuild(1) and cvs-buildpackage for more information about the behaviour of each.
OPTIONS
The following are the debuild options recognised by cvs-debuild. All cvs-buildpackage and lintian options are simply passed to the appro-
priate program. For explanations of the meanings of these variables, see debuild(1).
--no-conf, --noconf
--rootcmd=gain-root-command, -rgain-root-command
--preserve-env
--preserve-envvar=var, -evar
--set-envvar=var=value, -evar=value
--lintian, --no-lintian
--ignore-dirname, --check-dirname
These should not be needed, but it is provided nevertheless.
SEE ALSO
cvs-buildpackage(1), debuild(1), dpkg-buildpackage(1) and lintian(1).
AUTHOR
This program was written by Julian Gilbey <jdg@debian.org>.
DEBIAN
Debian Utilities CVS-DEBUILD(1)