Removing worksheets from xls using unix.

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...

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...

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

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...

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. 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...

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...

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 - ...

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 ?...

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

LEARN ABOUT REDHAT

testparm

TESTPARM(1)															       TESTPARM(1)

NAME

       testparm - check an smb.conf configuration file for  internal correctness

SYNOPSIS

       testparm [ -s ]	[ -h ]	[ -x ]	[ -L <servername> ]  config filename [ hostname hostIP ]

DESCRIPTION

       This tool is part of the  Samba suite.

       testparm  is  a very simple test program to check an smbd configuration file for internal correctness. If this program reports no problems,
       you can use the configuration file with confidence that smbd will successfully load the configuration file.

       Note that this is NOT a guarantee that the services specified in the configuration file will be available or will operate as expected.

       If the optional host name and host IP address are specified on the command line, this test program will run  through  the  service  entries
       reporting whether the specified host has access to each service.

       If  testparm  finds  an error in the  smb.conf file it returns an exit code of 1 to the calling program, else it returns an exit code of 0.
       This allows shell scripts to test the output from testparm.

OPTIONS

       -s     Without this option, testparm will prompt for a carriage return after printing the service names and before dumping the service def-
	      initions.

       -h     Print usage message

       -x     Print only parameters that have non-default values

       -L servername
	      Sets the value of the %L macro to servername.  This is useful for testing include files specified with the %L macro.

       configfilename
	      This  is	the  name  of  the  configuration  file  to check. If this parameter is not present then the default smb.conf file will be
	      checked.

       hostname
	      If this parameter and the following are specified, then testparm will examine the hosts allow  and  hosts  deny  parameters  in  the
	      smb.conf	file  to  determine  if the hostname with this IP address would be allowed access to the smbd server. If this parameter is
	      supplied, the hostIP parameter must also be supplied.

       hostIP This is the IP address of the host specified in the previous parameter. This address must be supplied if the hostname  parameter	is
	      supplied.

FILES

       smb.conf
	      This is usually the name of the configuration file used by smbd.

DIAGNOSTICS

       The  program  will issue a message saying whether the configuration file loaded OK or not. This message may be preceded by errors and warn-
       ings if the file did not load. If the file was loaded OK, the program then dumps all known service details to stdout.

VERSION

       This man page is correct for version 2.2 of the Samba suite.

SEE ALSO

       smb.conf(5) smbd(8)

AUTHOR

       The original Samba software and related utilities were created by Andrew Tridgell. Samba is now developed by the  Samba	Team  as  an  Open
       Source project similar to the way the Linux kernel is developed.

       The  original  Samba  man  pages were written by Karl Auer.  The man page sources were converted to YODL format (another excellent piece of
       Open Source software, available at ftp://ftp.icce.rug.nl/pub/unix/ <URL:ftp://ftp.icce.rug.nl/pub/unix/>) and updated  for  the	Samba  2.0
       release by Jeremy Allison. The conversion to DocBook for Samba 2.2 was done by Gerald Carter

								 19 November 2002						       TESTPARM(1)

Shell Programming and Scripting