LinuxQuestions.org
Review your favorite Linux distribution.
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 03-21-2012, 11:20 PM   #1
ust
Senior Member
 
Registered: Mar 2003
Location: fasdf
Distribution: Debian / Suse /RHEL
Posts: 1,130

Rep: Reputation: 30
text file to excel


I would like to have a module which can be change text file ( prn ) to excel , I tried google text2execl , it show many software can do that , can advise which one is the best choice among them ?

thx
 
Old 03-22-2012, 04:13 PM   #2
suicidaleggroll
LQ Guru
 
Registered: Nov 2010
Location: Colorado
Distribution: OpenSUSE, CentOS
Posts: 5,258

Rep: Reputation: 1947Reputation: 1947Reputation: 1947Reputation: 1947Reputation: 1947Reputation: 1947Reputation: 1947Reputation: 1947Reputation: 1947Reputation: 1947Reputation: 1947
Need a lot more info than that. Excel can read standard text files, the question is how your data is formatted in the text document, and how you want it formatted in Excel. The usual approach is to convert your data into a standard "csv" file (comma separated variable), where every column is delimited with a comma or other special character, that Excel then uses to interpret and format the data into a table.
 
Old 03-22-2012, 04:36 PM   #3
John VV
LQ Muse
 
Registered: Aug 2005
Location: A2 area Mi.
Posts: 16,818

Rep: Reputation: 2408Reputation: 2408Reputation: 2408Reputation: 2408Reputation: 2408Reputation: 2408Reputation: 2408Reputation: 2408Reputation: 2408Reputation: 2408Reputation: 2408
why not just import a CSV or a space separated
into a tab on the sheet

i still do and did that years ago for "raw" ascii images

a spread sheet can even convert a ascii *.obj 3d mesh into a photo

now matlab( octave) replaces a spread sheet but it still has uses sometimes
 
Old 03-22-2012, 05:13 PM   #4
Satyaveer Arya
Senior Member
 
Registered: May 2010
Location: Palm Island
Distribution: RHEL, CentOS, Debian, Oracle Solaris 10
Posts: 1,415

Rep: Reputation: 305Reputation: 305Reputation: 305Reputation: 305
Use WriteExcel 2.37 - A cross-platform Perl module for creating Excel binary files.
WriteExcel is a Perl module which can be used to create native Excel binary files. Formatted text and numbers can be written to multiple worksheets in a workbook. Formulas and functions are also supported. It is 100% Perl and doesn't require any Windows libraries or a copy of Excel. It will also work on the majority of Unix and Macintosh platforms. Generated files are compatible with Excel 97, 2000, 2002, and 2003, and with OpenOffice and Gnumeric. An older version also supports Excel 5/95.

Last edited by Satyaveer Arya; 03-22-2012 at 05:14 PM.
 
  


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
[SOLVED] Text file to Excel adding column arjun_b Linux - Newbie 3 01-05-2012 08:53 AM
Convert from XML in excel format to Excel XLS file CPAN module Perseus Programming 9 10-14-2011 01:39 PM
[SOLVED] Manipulate text file to allow import to excel dimothy Linux - Software 3 06-14-2010 08:50 AM
Excel to Text tangle Programming 6 09-23-2006 10:31 PM
convert text file to binary excel file ust Linux - General 2 11-23-2004 03:33 AM


All times are GMT -5. The time now is 08:16 PM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration