LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 11-07-2011, 02:16 PM   #1
manalisharmabe
Member
 
Registered: Dec 2010
Posts: 240

Rep: Reputation: 1
Question HOWTO transfer Hosts in excel sheet to file in LINUX?


Hi guys!

I have around 300 hostsname is excelsheet in one column. These hosts I want to add in one file in linux one after the another like hostname1,hostname2.hostname3,


I don't want to waste enter it manually it very time consuming, so how to transfer these files from excelsheet to a file in Linux?
Edit/Delete Message
 
Old 11-07-2011, 02:18 PM   #2
suicidaleggroll
Senior Member
 
Registered: Nov 2010
Location: Colorado
Distribution: OpenSUSE, CentOS
Posts: 3,133

Rep: Reputation: 1101Reputation: 1101Reputation: 1101Reputation: 1101Reputation: 1101Reputation: 1101Reputation: 1101Reputation: 1101Reputation: 1101
I would save it out as a csv (comma separated variable) file, then parse it in a script, dividing the fields up using the comma delimiters.
 
Old 11-07-2011, 02:18 PM   #3
catkin
LQ 5k Club
 
Registered: Dec 2008
Location: Tamil Nadu, India
Distribution: Servers: Debian Squeeze and Wheezy. Desktop: Slackware64 14.0. Netbook: Slackware 13.37
Posts: 8,557
Blog Entries: 28

Rep: Reputation: 1178Reputation: 1178Reputation: 1178Reputation: 1178Reputation: 1178Reputation: 1178Reputation: 1178Reputation: 1178Reputation: 1178
Copy from spreadsheet and paste into an editor?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert from XML in excel format to Excel XLS file CPAN module Perseus Programming 9 10-14-2011 01:39 PM
i want c program for fetching data from excel sheet rinu budhbhatti Programming 3 01-31-2011 09:23 AM
Want to import an excel sheet data from from a remote linux server envisage Programming 1 01-31-2008 02:08 PM
how to import MS-Excel sheet data using PHP dileepkk Programming 1 07-28-2004 03:23 PM


All times are GMT -5. The time now is 08:27 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration