Sponsored Content
Top Forums Shell Programming and Scripting Code to get 5 unix files in 5 different tabs in a single excel Post 302336358 by DukeNuke2 on Wednesday 22nd of July 2009 01:34:00 AM
Old 07-22-2009
Homework is not permitted at The UNIX and Linux Forums.

Please read the rules, which you agreed to when you registered, if you have not already done so.

More-than-likely, posting homework has resulting in a forum infraction. If you did not post homework, please explain the company you work for and the nature of the problem you are working on.

Thank You.

The UNIX and Linux Forums.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Exporting files from unix to Excel sheet

How can we export a file in unix with certain number of columns to an excel sheet. It's very useful in time saving...... (3 Replies)
Discussion started by: bishweshwar
3 Replies

2. Shell Programming and Scripting

How to combine different Excel sheets into a single work book using UNIX

Hi All, I have 4 excel files and i want to combine these 4 files into a single workbook .. my constraints is each work sheet should go to a seperate sheet or tab with sheet name .. my final workbook should have 4 tabs(sheets) each for one. Thanks in Advance.. (3 Replies)
Discussion started by: jagadish99
3 Replies

3. Shell Programming and Scripting

PERL: Split Excel Workbook to Indiv Excel files

Hi, I am trying to find a way to read an excel work book with multiple worksheets. And write each worksheet into a new excel file using perl. My environment is Unix. For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies

4. Shell Programming and Scripting

Add multiple .csv files as sheets to an excel file in unix.

Hi, I am using Solaris 8. My script outputs 4 .csv files. Currently I am SFTPing the files and creating a new excel file with the 4 files as sheets. Can anyone suggest ways to do this in UNIX ? Thanks, David. (2 Replies)
Discussion started by: libin4u2000
2 Replies

5. UNIX for Dummies Questions & Answers

Multiple excel files processing on unix

Hi all, I am faced with a rather unusual problem regarding interaction between NT and UNIX. I am using an ETL (Extract-Transform-Load) tool on unix that has the capability to read .xls files. So, when I FTP an excel (.xls) file from a windows server to unix and attempt to read it with this... (3 Replies)
Discussion started by: ucode_2482
3 Replies

6. UNIX for Dummies Questions & Answers

Please help Question about Excel Files and Unix

Hello I have an excel file , it has 4 tabs , each having specific details for example it has a customer tab , it has a payments tab and it has an address tab Question is How do I seperate each of these tabs and load them into 3 different excel files Using Unix That is the... (2 Replies)
Discussion started by: arnab1978
2 Replies

7. UNIX and Linux Applications

Differentiate between MS Word and Excel files in Unix

Hi, I want to differentiate between a MS Word and Excel file in Unix (not by extension). The condition which we are currently checking for is the pattern "\320\317\021\340" within first 40 bytes of the file. However this format is same in all MS Office files. Can somebody tell me any special... (4 Replies)
Discussion started by: phatak_rajan
4 Replies

8. Shell Programming and Scripting

Converting specific Excel file tabs to CSV in Python

Hi list, This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module. I have an excel document with multiple tabs of data and graphs. One of the tabs is just data which I require to have dumped to... (8 Replies)
Discussion started by: landossa
8 Replies

9. Shell Programming and Scripting

Perl script to Merge contents of 2 different excel files in a single excel file

All, I have an excel sheet Excel1.xls that has some entries. I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls These may be in different workbooks. They are totally independent made by 2 different users. I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies

10. Shell Programming and Scripting

Tabbed multiple csv files into one single excel file with using shell script not perl

Hi Experts, I am querying backup status results for multiple databases and getting each and every database result in one csv file. so i need to combine all csv files in one excel file with separate tabs. I am not familiar with perl script so i am using shell script. Could anyone please... (4 Replies)
Discussion started by: ramakrk2
4 Replies
TABS(1) 						    BSD General Commands Manual 						   TABS(1)

NAME
tabs -- set terminal tabs SYNOPSIS
tabs [-n|-a|-a2|-c|-c2|-c3|-f|-p|-s|-u] [+m[n]] [-T type] tabs [-T type] [+[n]] n1[,n2,...] DESCRIPTION
The tabs utility displays a series of characters that first clears the hardware terminal tab settings and then initializes the tab stops at the specified positions and optionally adjusts the margin. The phrase "tab-stop position N" means that, from the start of a line of output, tabbing to position N shall cause the next character output to be in the (N+1)th column on that line. The following options are supported: -n Specifies repetitive tab stops separated by a uniform number of columns, n, where n is a single digit decimal number. The default usage of tabs with no arguments is equivalent to tabs -8. When -0 is used, the tab stops are cleared and no new ones set. -a Assembler, applicable to some mainframes. Equivalent to tabs 1,10,16,36,72 . -a2 Assembler, applicable to some mainframes. Equivalent to tabs 1,10,16,40,72 -c COBOL, normal format. Equivalent to tabs 1,8,12,16,20,55 -c2 COBOL, compact format (columns 1 to 6 omitted). Equivalent to tabs 1,6,10,14,49 -c3 COBOL, compact format (columns 1 to 6 omitted), with more tabs than -c2. Equivalent to tabs 1,6,10,14,18,22,26,30,34,38,42,46,50,54,58,62,67 -f FORTRAN. Equivalent to tabs 1,7,11,15,19,23 -p PL/1. Equivalent to tabs 1,5,9,13,17,21,25,29,33,37,41,45,49,53,57,61 -s SNOBOL. Equivalent to tabs 1,10,55 -T type Indicates the type of terminal. -u Assembler, applicable to some mainframes. Equivalent to tabs 1,12,20,44 EXIT STATUS
The tabs utility exits 0 on success, and >0 if an error occurs. ENVIRONMENT
The COLUMNS and TERM environment variables affect the execution of tabs as described in environ(7). The -T option overrides TERM. If neither TERM nor the -T option are present, tabs will fail. SEE ALSO
expand(1), stty(1), tput(1), unexpand(1), termcap(5) STANDARDS
The tabs utility conforms to IEEE Std 1003.1 (``POSIX.1''). HISTORY
A tabs utility first appeared in PWB UNIX. This implementation was introduced in NetBSD 6.0. AUTHORS
Roy Marples <roy@NetBSD.org> BUGS
The current termcap(5) database does not define the set left soft margin 'ML' capability for any terminals. BSD
December 9, 2008 BSD
All times are GMT -4. The time now is 05:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy