Yes -- the abtab utilities I linked to above. The abtab_cat utility should allow you to pass parameters identifying the input as XLS and the output as CSV (or at least tab-delimited, which is easy enough to convert).
The syntax will be something like the following (untested):
Hi,
There is this requirement to create multiple work sheets in an MS Excel file through UNIX.
We normally can create one work sheet in unix by either tab or comma delimiting and appending .xls or .csv to the file name, but can we create multiple work sheets.
Regards,
Puspendu (1 Reply)
Hello Everyone,
I am new to scripting and confused with how to do this efficiently. I am trying to use AWK to do this.
I have a lot of files in a folder which has the data of my throughput measurements in two columns i.e. Serial # and Throughput. like this
177.994 847.9
178.996 ... (1 Reply)
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)
Helllo UNIX Forum :)
Since I am posting on this board, yes, I am new to UNIX!
I read a copy of "UNIX made easy" from 1990, which felt like a making a "computer-science time jump" backwards ;)
So, basically I have some sort of understanding what the basic concept is.
Problem Description:... (6 Replies)
I have five directories, dir1 to dir5
for each directory, I have all same number-named folders. There are four types of folders, {1..10}, {20..30}, { 40..50}, {60..70}
Now for each types of folder, I will do the same thing, here is the code
for i in {1..5}
do
cd dir$i
mkdir temp1
for... (5 Replies)
Hi,
I have one requirement, create separate files (".csv") from one excel file(xlsx) with multiple sheets. These ".csv" files are my source files. So anybody please suggest me the process.
Thanks in Advance.
Regards,
Harris (3 Replies)
hai i need my single awk script to act on 4 trace files of ns2 and to calculate througput and it should print result from each trace file in a single trace file. i tried with the following code but it doesnt work awk -f awkscript inputfile1 inputfile2 inputfile3 inputfile4>outputfile ... (4 Replies)
I have requirement to write two CSV files to one single excel with multiple sheets.
Data present in the two files should sit in excel as different sheets.
How can we achieve this using shell script?
1.csv 2. csv
1,2,3,4 5,6,7,8
XXXXX YYYYY
Res.excel
1.csv data... (1 Reply)
Hello
I have a program cfxfrwb which is designed to remove headers from reports files.
The cfxfrwb is located in the following directory /u01/efin/v40/live/bin
I run the program against a single report file in the temp directory and it does it's job../cfxfrwb... (2 Replies)
Hello
I posted on here a while ago about processing multiple files within a script.
See original post below:
I have a program cfxfrwb which is designed to remove headers from reports files.
The cfxfrwb is located in the following directory /u01/efin/v40/live/bin
I run the program against... (8 Replies)
Discussion started by: captainrhodes
8 Replies
LEARN ABOUT CENTOS
gsf
GSF(1) GNOME GSF(1)NAME
gsf - archiving utility using the G Structured File library
SYNOPSIS
gsf [OPTION...] SUBCOMMAND ARCHIVE...
DESCRIPTION
This manual page briefly documents the gsf command.
gsf is a simple archive utility, somewhat similar to tar(1). It operates on files following one of the structured file formats understood
by the G Structured File library, for example, Microsoft Excel(TM) files.
OPTIONS
Options
-?, --help
Show help options
-v, --version
Display gsf's version
Subcommands
cat Output one or more files in archive
dump Dump one or more files in archive as formatted hexadecimal
help List subcommands
list List files in archive
props Archive list of property names
EXAMPLES
To list the content structure of a Microsoft Excel(TM) file arrays.xls:
gsf list arrays.xls
To dump Workbook, an individual data stream in arrays.xls:
gsf dump arrays.xls Workbook
AUTHORS
gsf's primary authors are Morten Welinder <terra@gnome.org> and Jody Goldberg <jody@gnome.org>.
The initial version of this manpage was written by J.H.M. Dassen (Ray) <jdassen@debian.org>.
SEE ALSO gnumeric(1)
The Gnumeric homepage <http://www.gnome.org/projects/gnumeric/>
The GNOME project page <http://www.gnome.org/>
gsf 29 November 2009 GSF(1)