06-10-2005
VBA is capable of meeting your requirement. However, id you need a UNIX scripting approach, you are going to have to use OpenOffice. The only issue with OpenOffice is that when Microsoft alters the XLS file structure, you're going to have to keep your versions status quo until OpenOffice can catch up. VBA is less likely to be a problem in this regard. Excel can change all it wants but the VB code should stay essentially the same.
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 DEBIAN
fig2sxd
FIG2SXD(1) General Commands Manual FIG2SXD(1)
NAME
fig2sxd - utility to convert .fig to .sxd
SYNOPSIS
fig2sxd [-w] [-l(ine)w(idth)1 l] figfile sxdfile
DESCRIPTION
The program tries to convert the given file in xfig format into a sxd file for OpenOffice.org Draw. If figfile ends with .fig or .xfig and
sxdfile is omitted, the output file will be named like figfile ending with .sxd instead of .(x)fig. Using - for figfile makes the program
read from stdin so that it is possible to use
pstoedit -f fig file.ps - | fig2sxd - file.sxd
to convert ps files. (For files with many objects you might want to use something like
pstoedit -f 'fig:-startdepth 9999' file.ps - | fig2sxd - file.sxd
to get more layers; the output of pstoedit then is no longer a valid xfig file, but it makes the z ordering of the objects in Open-
Office.org Draw stay correct.) Using - for sxdfile makes the program write to stdout. With the -linewidth1 (or -lw1) option, the width of
lines with thickness 1 in xfig can be set, unit is 1 cm. Using 0 here gives fine lines. Example:
pstoedit -f 'fig:-startdepth 9999' file.ps - | fig2sxd -lw1 0 - file.sxd
With the -w option, out-of-specification values are only warnings but will be sanitized.
DEFICIENCIES
Not all of the .fig objects are converted correctly: splines look quite similar, but are not exactly the same; text placement might be a
little bit wrong, especially for very small font sizes; hatches look different in many cases; hollow arrows are not supported and replaced
by their filled counterparts. There are various other things that could be improved.
It looks like OpenOffice.org cannot read xml attribute values longer than 64kB as they might appear for very long polygons/-lines. For
unfilled polylines, fig2sxd therefore creates several smaller polylines of 500 points each and groups them together. Splitting an arbitrary
filled polygon is not trivial and not implemented.
SEE ALSO
pstoedit(1), xfig(1) and http://fig2sxd.sourceforge.net/ (for updates).
AUTHOR
Program and manual page were written by Alexander Burger <acfb@users.sourceforge.net>.
FIG2SXD(1)