06-10-2005
Quote:
Originally Posted by radhika
Issue is:
I could do it manually by loading excel and deleting the header row and copying the cells into the other excel spreadsheet.
But, requirement is to automate the whole process of removing the header column in all three files, combine them into one file, store them as comma or tab delimited text file, so I could run my process which reformats the data.
Doesn't Excel have a builtin language just for this sort of thing? I belive its called VBA,
http://www.excel-vba.com/
try that.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have several hundreds of text files which I would like to combine them onto excel sheet. Does anyone know how to combine them into different excel sheet in one workbook using Bash script?
Please advise. THanks.
I forgot to mention my file is something like below:-
A B ... (5 Replies)
Discussion started by: ahjiefreak
5 Replies
2. Shell Programming and Scripting
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
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
eg.
file 1 has:
4 0 8628380 653253 0 0 0 0 0 0
2 0 8626407 655222 0 0 0 0 0 0
4 0 8633729 647892 0 0 0 0 0 0
5 0 8646253 635367 0 0 0 0 0 0
file 2 has:
4798 48717 11554
5408 56487 14359
6010 58415 15220
5541 41044... (2 Replies)
Discussion started by: netbanker
2 Replies
5. UNIX for Dummies Questions & Answers
I need to combine two files based on the content in first column and combine it into one file . For example :
file1:
A 10
B 20
C 30
D 40
File2:
B 200
E 500
A 100
D 400
Need the output in this format:
file 3 :
column 1 Column 2 Column 3
A 10 100
B 20 ... (4 Replies)
Discussion started by: tsm2011
4 Replies
6. Shell Programming and Scripting
Hii
I have these files , and I want to merge them in an excel file
each file have two columns
file1
title1
1 1
2 2
3 3
file2
title2
5 5
6 6
7 7
8 8
9 9 (10 Replies)
Discussion started by: maryre89
10 Replies
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
The script below is an attempt to combine 3 shells into 1.
The first part: match.sh
prompts the user for an id of a patient and runs a match script based on the response of "y" or "n". After completing the user is asked if there are additional patients, and based on "y" or "n" a certain action... (2 Replies)
Discussion started by: cmccabe
2 Replies
9. Shell Programming and Scripting
I am hoping the attached shell file is at least somewhat close to this.
Combining two shell file into one, where depending on the user input of"y" or "n" different commands are run. Thank you :).
So first he user is asked for an ID to match, once the id is entered a script is run that uses... (4 Replies)
Discussion started by: cmccabe
4 Replies
10. Shell Programming and Scripting
Hello All , I am new to this Forum,
I am trying to write a script to combine two data files with 1 column in common and others columns are different .
File1
Apple 29
tomatao 4
grapes 25
File2
Apple fruit
tomatao veg
grapes fruit
other (3 Replies)
Discussion started by: gagan0119
3 Replies
LEARN ABOUT PHP
sccs-comb
sccs-comb(1) User Commands sccs-comb(1)
NAME
sccs-comb, comb - combine SCCS deltas
SYNOPSIS
/usr/ccs/bin/comb [-os] [-csid-list] [-psid] s.filename...
DESCRIPTION
comb generates a shell script (see sh(1)) that you can use to reconstruct the indicated s.files. This script is written to the standard
output.
If a directory name is used in place of the s.filename argument, the comb command applies to all s.files in that directory. Unreadable
s.files produce an error; processing continues with the next file (if any). The use of `-' as the s.filename argument indicates that the
names of files are to be read from the standard input, one s.file per line.
If no options are specified, comb preserves only the most recent (leaf) delta in a branch, and the minimal number of ancestors needed to
preserve the history.
OPTIONS
The following options are supported:
-o For each `get -e' generated, access the reconstructed file at the release of the delta to be created. Otherwise, the recon-
structed file is accessed at the most recent ancestor. The use of -o may decrease the size of the reconstructed s.file. It
may also alter the shape of the delta tree of the original file.
-s Generate scripts to gather statistics, rather than combining deltas. When run, the shell scripts report: the file name,
size (in blocks) after combining, original size (also in blocks), and the percentage size change, computed by the formula:
100 * ( original - combined ) / original
This option can be used to calculate the space that will be saved, before actually doing the combining.
-csid-list Include the indicated list of deltas. All other deltas are omitted. sid-list is a comma-separated list of SCCS delta IDs
(SIDs). To specify a range of deltas, use a `-' separator instead of a comma, between two SIDs in the list.
-pSID The SID of the oldest delta to be preserved.
FILES
s.COMB reconstructed SCCS file
comb????? temporary file
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWsprot |
+-----------------------------+-----------------------------+
SEE ALSO
sccs(1), sccs-admin(1), sccs-cdc(1), sccs-delta(1), sccs-help(1), sccs-prs(1), sccs-prt(1), sccs-rmdel(1), sccs-sccsdiff(1), what(1), sccs-
file(4), attributes(5)
DIAGNOSTICS
Use the SCCS help command for explanations (see sccs-help(1)).
BUGS
comb may rearrange the shape of the tree of deltas. It may not save any space; in fact, it is possible for the reconstructed file to actu-
ally be larger than the original.
SunOS 5.10 1 Nov 1999 sccs-comb(1)