Sponsored Content
Full Discussion: Read Ms-excel file in unix
Top Forums Shell Programming and Scripting Read Ms-excel file in unix Post 302250457 by koti_rama on Thursday 23rd of October 2008 11:12:39 AM
Old 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

how can i read an excel file using C?

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

Opening an Excel File in Unix

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

how to read the data from an excel sheet and use those data as variable in the unix c

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

Win32::OLE open excel file as read only

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

use awk to read randomly located columns in an excel file

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

Read window Excel sheet to unix

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

Read microsoft excel in Unix

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

Read excel file using shell script

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

Perl Script to read an excel file into an array and search in the UNIX directories

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

Perl :Is it possible to read the excel 2007 sheet on unix machine using spredsheet::xlsx module

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
Data(3pm)						User Contributed Perl Documentation						 Data(3pm)

NAME
Test::Data -- test functions for particular variable types SYNOPSIS
use Test::Data qw(Scalar Array Hash Function); DESCRIPTION
Test::Data provides utility functions to check properties and values of data and variables. Functions Plug-in modules define functions for each data type. See the appropriate module. How it works The Test::Data module simply imports functions from Test::Data::* modules. Each module defines a self-contained function, and puts that function name into @EXPORT. Test::Data defines its own import function, but that does not matter to the plug-in modules. If you want to write a plug-in module, follow the example of one that already exists. Name the module Test::Data::Foo, where you replace Foo with the right name. Test::Data should automatically find it. BUGS
I'm not a very good Windows Perler, so some things don't work as they should on Windows. I recently got a Windows box so I can test things, but if you run into problems, I can use all the patches or advice you care to send. SEE ALSO
Test::Data::Scalar, Test::Data::Array, Test::Data::Hash, Test::Data::Function, Test::Builder SOURCE AVAILABILITY
This source is in Github: http://github.com/briandfoy/test-data/tree/master AUTHOR
brian d foy, "<bdfoy@cpan.org>" COPYRIGHT AND LICENSE
Copyright (c) 2002-2009 brian d foy. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2009-02-12 Data(3pm)
All times are GMT -4. The time now is 02:47 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy