Reading data from excel using shell script

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
gaurav sharmaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
MazdajaiConnect With a Mentor Commented:
What is incorrect?
0
 
Jan SpringerConnect With a Mentor Commented:
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
 
SimonConnect With a Mentor Commented:
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
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
Jan SpringerCommented:
Hint: It's not an excel file if it's in csv or txt format.
0
 
SimonCommented:
@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
 
MazdajaiCommented:
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
 
Jan SpringerCommented:
Understood.  I just don't think it's correct to perpetuate an inaccuracy.  A nit perhaps but felt that clarity was needed.
0
 
gaurav sharmaAuthor Commented:
I've requested that this question be deleted for the following reason:

incorrect
0
 
gaurav sharmaAuthor Commented:
Incorrect question
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.