10-23-2008
Read Ms-excel file in unix
Hi,
I have the Ms Excel file(test.xls) in my UNIX box. I would like to read the excel file and create files for each column.
Please find an example.
My excel file like this data:
Num Data
1 a1
2 b2
3 c3
4 d4
5 e5
6 f6
7 h7
My output:
I want create 2 files(num.log and data.log)
Data in num.log file:
1
2
3
4
5
6
7
Data in Data.log file:
a1
b2
c3
d4
e5
f6
h7
Thanks
Koti.
10 More Discussions You Might Find Interesting
1. Programming
hi..
i have the next question:
i need to read an excel file (xls) using a C program. Is that possible?
how can i do that?
please, any idea
thanks (6 Replies)
Discussion started by: DebianJ
6 Replies
2. UNIX for Advanced & Expert Users
Hi all,
I want to open an Excel file in Unix(ABC.xls) and copy one column of the file onto another text file (xyz.txt) .Please let me know if there is a way of going about to perform this operation.
Thanks in Advance,
bubeshj (5 Replies)
Discussion started by: bubeshj
5 Replies
3. UNIX for Advanced & Expert Users
I have 3 columns in an excel sheet.
c1 c2 c3
EIP_ACCOUNT SMALL_TS_01 select A.* from acc;
All the above 3 col shoud be passed a variable in the unix code.
1.How to read an excel file
2.How to pass these data as variable to the unic script (1 Reply)
Discussion started by: Anne Grace
1 Replies
4. Shell Programming and Scripting
I am using Win32::OLE to write a perl script which opens an excel file. That excel file is password protected and everytime i run that script dialog box pops up and I have to click on Read-Only then my script executes. Is there any way I can specify the readonly attribute in my code so i dont have... (0 Replies)
Discussion started by: dguy
0 Replies
5. Shell Programming and Scripting
Hi,
I have an excel file that have a random count of columns/fields and what im trying to do is to only retrieve all the rows under 2 specific field headers.
I can use the usually command for awk which is awk 'print{ $1 $2}' > output.txt, but the location of the 2 specific field headers is... (9 Replies)
Discussion started by: mdap
9 Replies
6. Shell Programming and Scripting
I would like to read data from excel sheet as a input to a shell script.
Myproblem is the excel sheet is in windows. How can I write a shell script to read data from that excel sheet?
How can I do that?. (4 Replies)
Discussion started by: vj8436
4 Replies
7. UNIX for Dummies Questions & Answers
Hey guys,
Can we read a microsoft excel spreadsheet in Unix / linux. If so, what are the steps to be followed?
I know we can convert the excel workbook as a CSV and then read it in unix. Are there any other direct methods?
thanks
prasan81 (2 Replies)
Discussion started by: prasan81
2 Replies
8. UNIX for Dummies Questions & Answers
Is it possible to read an excel sheet using shell script ? (2 Replies)
Discussion started by: hiten.r.chauhan
2 Replies
9. UNIX and Linux Applications
Hi,
I want the Perl script with versions 5.8.2 and 5.8.5 starting with
#!/usr/bin/perl
The Perl program should read the excel file or text file line by line and taking into an array and search in the UNIX directories for reference file of .jsp or .js or .xsl with path .The Object names... (2 Replies)
Discussion started by: pasam
2 Replies
10. Shell Programming and Scripting
I have an Excel 2007 excel sheet on windows machine and using
Spreadsheet::XLSX I had written a script to read the excel sheet and was successful.
My requirement is I need to generate another excel sheet from the old excel 2007 sheet on unix machine.
Now is it possible to read the excel... (2 Replies)
Discussion started by: giridhar276
2 Replies
LEARN ABOUT CENTOS
nislog
nislog(1M) System Administration Commands nislog(1M)
NAME
nislog - display the contents of the NIS+ transaction log
SYNOPSIS
/usr/sbin/nislog [-h num | -t num] [-v] [directory...]
DESCRIPTION
nislog displays the contents of the NIS+ server transaction log on the standard output. This command can be used to track changes in the
namespace. The /var/nis/trans.log file contains the transaction log maintained by the NIS+ server. When updates occur, they are logged to
this file and then propagated to replicas as log transactions. When the log is checkpointed, updates that have been propagated to the
replicas are removed.
The nislog command can only be run on an NIS+ server by superuser. It displays the log entries for that server only.
If directory is not specified, the entire log is searched. Otherwise, only those logs entries that correspond to the specified directories
are displayed.
OPTIONS
-h num Display num transactions from the ``head'' of the log. If the numeric parameter is 0, only the log header is displayed.
-t num Display num transactions from the ``tail'' of the log. If the numeric parameter is 0, only the log header is displayed.
-v Verbose mode.
FILES
/var/nis/trans.log transaction log
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWnisu |
+-----------------------------+-----------------------------+
SEE ALSO
nis+(1), rpc.nisd(1M), nisfiles(4), attributes(5)
NOTES
NIS+ might not be supported in future releases of the SolarisTM Operating Environment. Tools to aid the migration from NIS+ to LDAP are
available in the Solaris 9 operating environment. For more information, visit http://www.sun.com/directory/nisplus/transition.html.
SunOS 5.10 12 Dec 2001 nislog(1M)