Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Removing worksheets from xls using unix.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Removing worksheets from xls using unix.
# 8  
Old 04-13-2011
Well, I anticipate an unsophisticated end-user interface where spreadsheets are supplied by users on a web service or network directory, and loaded without operator intervention. If it was ad-hoc, you can just save as text and edit into sql.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging Multiple XLS into Different tabs in xls/ xlsx

HI, I have multiple files per dept in folder for eg : In a folder File1_Dept100.xls File2_Dept100.xls File3_Dept100.xls File1_Dept200.xls File2_Dept200.xls File3_Dept200.xls Output should be : Dept100.xls which has File1, File2, File3 in different tabs Dept200.xls which has... (1 Reply)
Discussion started by: venkyzrocks
1 Replies

2. UNIX for Advanced & Expert Users

Shell script for dealing with XLS file with multiple tabs/worksheets

Hey Guys , Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below : 1. Convert one XLS file with multiple tabs to multiple CSV files. -- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But... (2 Replies)
Discussion started by: himanshu sood
2 Replies

3. UNIX for Dummies Questions & Answers

Merging the content of 2 cells in XLS using UNIX command

Hi All, I am creating an XLS using unix which fetches the data from database. In the first row i have 2 columns which i want to merge. Is it possible to merge the columns using unix command? Thanks, Sashanka (1 Reply)
Discussion started by: Sashanka_545
1 Replies

4. Shell Programming and Scripting

Expand cells in .xls file created in unix

Hi Guys, I am creating a comma separated file by quering the table and routing it to a file with an extension .xls. I am using the mailx command to send the .xls file to windows mail box. The file is coming as a excel attachment, but the cells are not expanded. Is there a way by which... (4 Replies)
Discussion started by: mac4rfree
4 Replies

5. UNIX and Linux Applications

Tool for Convert XLS into CSV in UNIX

Hi I wanted to convert some XLS files into CSV format in my UNIX box. Unix box is handling very important data which are related to data warehouse.It is fully optimized by installing minimum packages since server need more resources to handle reports generating. Just for convert XLS files... (6 Replies)
Discussion started by: luke_devon
6 Replies

6. Shell Programming and Scripting

How to create xls file using unix script

Hi All, I want to create an xls file using shell script. I mean that I have written one script. It is having sql output. So I want to save that sql output into one xls file and I want to send that file as a attachment to my team MAIL_IDs. Can You any guy help me in this? Thanks in... (3 Replies)
Discussion started by: raghu.iv85
3 Replies

7. UNIX for Dummies Questions & Answers

WINDOWS to UNIX : xls to csv

Hi, I need to ftp a .xls file from WINDOWS to UNIX. When I do it, the file coversion doesn't happen(??) or UNIX doesn't recognixe this format I know not. But there will be junk values in the ftp'd file. Note: The ftp will be done by a script and I don't think we could place a WINDOWS script on... (5 Replies)
Discussion started by: preethgideon
5 Replies

8. Shell Programming and Scripting

How to acheive ALT+Enter of xls in Unix ksh/sqlplus

Hi, I am using sqlplus (called inside my ksh) to create a file which is mailed to the users as an xls. There is one DESCRIPTION column which is currently coming as wrapped, but, the users want a new line for each of the fields present in the desricription column. Below is an example - ... (11 Replies)
Discussion started by: Sree_2503
11 Replies

9. Shell Programming and Scripting

copying the csv file into different worksheets of xls file

Hi, I have a script which will generate three csv files. i want to copy the contents of these csv files into a .XLS file but in different worksheets. Can a this be done in the same script? :confused: Can Perl come to my help in coping the csv files into different worksheets of .XLS file ?... (0 Replies)
Discussion started by: nimish
0 Replies

10. UNIX for Advanced & Expert Users

UNIX files to XLS

People, I am wondering if there is a Software(Filter) that can convert my UNix text file (delimeted text file) to Excel, for my business users to launch and see. Thanx Zia (4 Replies)
Discussion started by: rahzia
4 Replies
Login or Register to Ask a Question

LEARN ABOUT SUSE

ifservices

IFSERVICES(5)						       Network configuration						     IFSERVICES(5)

NAME

       ifservices-* - control network services with ifup/down

SYNOPSIS

       /etc/sysconfig/network/ifservices-<configuration_name>/

DESCRIPTION

       The  directory  /etc/sysconfig/network/ifservices-<configuration_name>/	is read by the script /etc/sysconfig/network/scripts/ifup-services
       which starts and stops system services when an interface is set up/down.  ifup-services is used by /sbin/ifup, which is	the  command  line
       user interface for setting up network interfaces.

       This  is useful if you don't have a permanent network connection. If you sometimes boot without network and plug in the network cable later
       you can add links to system services in this directory. These services will then be started with ifup and stopped with ifdown.

       The configuration name used for ifservices-* should match exactly the configuration name of the ifcfg-* file for the interface.

       For the usage with NetworkManager (where you don't necessarily  need  a	ifcfg-*  file)	you  can  also	use  /etc/sysconfig/network/ifser-
       vices-<interface>-<essid>/  (for  wlan  interfaces)  or	if that does not exist /etc/sysconfig/network/ifservices-<interface>/.	As a final
       fallback /etc/sysconfig/network/ifservices/ is checked as well. If NetworkManager is active services will be stopped after the interface is
       down.

       The  links  in  this  directory	are  equal to the links in the runlevel directories /etc/init.d/rc*.d/ They have to point to service start
       scripts which are usually in /etc/init.d/.  Links starting with 'S' are start links, which are called in alphabetical order after ifup  has
       set  up	the  interface.  Links starting with 'K' are kill links which are called before ifdown takes down the interface.  See also section
       Sequencing Directories in boot (7).

EXAMPLE

       In this example we use an interface with MAC address 00:de:ad:be:af:00. This interface is not always physically connected. As soon  as  you
       plug in the cable ypbind and autofs should be started. When you pull the cable they should be stopped. This can be reached with:

       in file /etc/sysconfig/network/ifcfg-eth-id-00:de:ad:be:af:00

	   ...
	   STARTMODE=ifplugd
	   ...

       in dir /etc/sysconfig/network/ifservices-eth-id-00:de:ad:be:af:00/

	   S10portmap -> /etc/init.d/portmap
	   S20ypbind  -> /etc/init.d/ypbind
	   S30autofs  -> /etc/init.d/autofs
	   S20autofs  -> /etc/init.d/autofs
	   K30ypbind  -> /etc/init.d/ypbind

       Now you have to disable the start of this services at boot time

	   chkconfig ypbind off
	   chkconfig autofs off

       Notes:

       You  may call scripts/create-ifservices-directory [<interface_name>] to create a directory with the links from this example. This will cre-
       ate the directory ifservices-<interface_name> or if no interface name was given ifservices-template.

       Maybe you have to add also variable IFPLUGD_PRIORITY. For details about startmode ifplugd read ifup (8).

       The service portmap had to be added because ypbind needs it. This service is still started at boot time because it does not need an  active
       network	connection.  But  ypbind  may  now be started earlier as usual. Therefore we make sure that portmap is started before. Starting an
       already running service again does not affect the service.

SEE ALSO

       ifup(8), ifcfg(5).

AUTHOR

       Christian Zoz <zoz@suse.de>

sysconfig							   February 2005						     IFSERVICES(5)