Sponsored Content
Top Forums Shell Programming and Scripting Removing worksheets from xls using unix. Post 302512833 by DGPickett on Monday 11th of April 2011 05:03:34 PM
Old 04-11-2011
I used to do something similar using xls2txt.c, there are excel friendly PERL libs, and JAVA apis. Your challenge is to find the worksheet title. Do you want a one-worksheet xls as the product, or the data on the other pages?
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
USERNETCTL(8)						      System Manager's Manual						     USERNETCTL(8)

NAME
usernetctl - allow a user to manipulate a network interface if permitted SYNOPSIS
usernetctl interface-name up|down|report DESCRIPTION
usernetctl checks to see if users are allowed to manipulate the network interface specified by interface-name, and then tries to bring the network interface up or down, if up or down was specified on the command line, or returns true or false status (respectively) if the report option was specified. usernetctl is not really meant to be called directly by users, though it currently works fine that way. It is used as a wrapper by the ifup and ifdown scripts, so that users can do exactly the same thing as root: ifup interface-name ifdown interface-name and ifup and ifdown will call usernetctl automatically to allow the interface status change. OPTIONS
interface-name The name of the network interface to check; for example, "ppp0". For backwards compatibility, "ifcfg-ppp0" and "/etc/sysconfig/net- work-scripts/ifcfg-ppp0" are also supported. up|down Attempt to bring the interface up or down. report Report on whether users can bring the interface up or down. NOTES
Alternate device configurations may inherit the default configuration's permissions. RHS
Red Hat, Inc. USERNETCTL(8)
All times are GMT -4. The time now is 11:47 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy