?
Solved

Reading data from excel using shell script

Posted on 2015-01-16
9
Medium Priority
?
2,044 Views
Last Modified: 2015-03-29
I have an excel sheet which has 5 columns like name, age, sex, address,phone number. can any one please help me out in reading the excel sheet only using shell script instead of using Perl and python.

TIA
0
Comment
Question by:gaurav sharma
  • 3
  • 2
  • 2
  • +1
9 Comments
 
LVL 29

Assisted Solution

by:Jan Springer
Jan Springer earned 668 total points
ID: 40555207
You don't.  You use a tool like perl and modules.

You can use bash (or other shell) if you export that file to a csv/txt and remove the formatting.
0
 
LVL 18

Assisted Solution

by:Simon
Simon earned 664 total points
ID: 40555241
Slight update: It depends if you're referring to a true 'Excel file' ie. one of Excel's proprietary file formats. If you store it as csv or other delimited text format you can read it from bash.
0
 
LVL 29

Expert Comment

by:Jan Springer
ID: 40555243
Hint: It's not an excel file if it's in csv or txt format.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 18

Expert Comment

by:Simon
ID: 40555275
@Jan, Yes, I know, but I've had a few people recently refer to "Excel sheets" (as opposed to Workbooks) when they are actually CSV files that show with an Excel icon on their desktop and open in Excel by default.
0
 
LVL 21

Expert Comment

by:Mazdajai
ID: 40555277
Other expert already responded "you don't" ... And in fact - you can't.

There is no bash API to read excel natively. In fact, other languages don't by default - they rely on pre-build modules.
0
 
LVL 29

Expert Comment

by:Jan Springer
ID: 40555291
Understood.  I just don't think it's correct to perpetuate an inaccuracy.  A nit perhaps but felt that clarity was needed.
0
 

Author Comment

by:gaurav sharma
ID: 40681621
I've requested that this question be deleted for the following reason:

incorrect
0
 
LVL 21

Accepted Solution

by:
Mazdajai earned 668 total points
ID: 40681622
What is incorrect?
0
 

Author Comment

by:gaurav sharma
ID: 40685892
Incorrect question
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, an awarded photographer, Selina De Maeyer (http://www.selinademaeyer.com/), completed a photo shoot of a beautiful event (http://www.sintjacobantwerpen.be/verslag-en-fotoreportage-van-de-sacramentsprocessie-door-antwerpen#thumbnails) in An…
Often times it's very very easy to extend a volume on a Linux instance in AWS, but impossible to shrink it. I wanted to contribute to the experts-exchange community a way of providing a procedure that works on an AWS instance. It can also be used on…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Suggested Courses
Course of the Month4 days, 1 hour left to enroll

599 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question