Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Multiple excel files processing on unix
Top Forums UNIX for Dummies Questions & Answers Multiple excel files processing on unix Post 302291923 by ShawnMilo on Thursday 26th of February 2009 03:02:48 PM
Old 02-26-2009
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):

Code:
abtab_cat --in xls://filename.xls --out tab://filename.tab

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Multiple excel work sheets through UNIX

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)
Discussion started by: puspendu
1 Replies

2. Shell Programming and Scripting

Processing Multiple Files

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)
Discussion started by: hakim
1 Replies

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

4. UNIX for Dummies Questions & Answers

single output of awk script processing multiple files

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)
Discussion started by: Kasimir
6 Replies

5. Shell Programming and Scripting

multiple groups of files processing

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)
Discussion started by: ksgreen
5 Replies

6. Shell Programming and Scripting

create separate files from one excel file with multiple sheets

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)
Discussion started by: harris
3 Replies

7. Shell Programming and Scripting

Processing multiple files awk

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)
Discussion started by: sarathyy
4 Replies

8. Shell Programming and Scripting

Write two csv files into one excel with multiple sheets

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)
Discussion started by: duplicate
1 Replies

9. Shell Programming and Scripting

Processing multiple files

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)
Discussion started by: captainrhodes
2 Replies

10. Shell Programming and Scripting

Processing multiple files (environment setting)

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 REDHAT

make_unicodemap

MAKE_UNICODEMAP(1)														MAKE_UNICODEMAP(1)

NAME

       make_unicodemap - construct a unicode map file for Samba

SYNOPSIS

       make_unicodemap codepage inputfile outputfile

DESCRIPTION

       This tool is part of the Samba suite.

       make_unicodemap compiles text unicode map files into binary unicode map files for use with the internationalization features of Samba 2.2.

OPTIONS

       codepage
	      This is the codepage or UNIX character set we are processing (a number, e.g. 850).

       inputfile
	      This is the input file to process. This is a text unicode map file such as the ones found in the Samba source/codepages directory.

       outputfile
	      This is the binary output file to produce.

SAMBA UNICODE MAP FILES

       A  text Samba unicode map file is a description that tells Samba how to map characters from a specified DOS code page or UNIX character set
       to 16 bit unicode.

       A binary Samba unicode map file is a binary representation of the same information, including a value that specifies what codepage or  UNIX
       character set this file is describing.

FILES

       CP<codepage>.TXT

       These are the input (text) unicode map files provided in the Samba source/codepages directory.

       A text unicode map file consists of multiple lines containing two fields. These fields are :

       o character - which is the (hex) character mapped on this line.

       o unicode - which is the (hex) 16 bit unicode character that the character will map to.

       unicode_map.<codepage>  -  These are the output (binary) unicode map files produced and placed in the Samba destination lib/codepage direc-
       tory.

INSTALLATION

       The location of the server and its support files is a matter for individual system administrators. The following are thus suggestions only.

       It is recommended that the make_unicodemap program be installed under the $prefix/samba hierarchy, in a directory readable by  all,  write-
       able only by root. The program itself should be executable by all. The program should NOT be setuid or setgid!

VERSION

       This man page is correct for version 2.2 of the Samba suite.

SEE ALSO

       smbd(8) smb.conf(5)

AUTHOR

       The  original  Samba  software  and  related utilities were created by Andrew Tridgell. Samba is now developed by the Samba Team as an Open
       Source project similar to the way the Linux kernel is developed.

       The original Samba man pages were written by Karl Auer.	The man page sources were converted to YODL format  (another  excellent  piece	of
       Open  Source  software,	available  at ftp://ftp.icce.rug.nl/pub/unix/ <URL:ftp://ftp.icce.rug.nl/pub/unix/>) and updated for the Samba 2.0
       release by Jeremy Allison. The conversion to DocBook for Samba 2.2 was done by Gerald Carter

								 19 November 2002						MAKE_UNICODEMAP(1)
All times are GMT -4. The time now is 01:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy