Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 03-21-2012, 11:20 PM   #1
Senior Member
Registered: Mar 2003
Location: fasdf
Distribution: Debian / Suse /RHEL
Posts: 1,130

Rep: Reputation: 31
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 ?

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

Rep: Reputation: 2130Reputation: 2130Reputation: 2130Reputation: 2130Reputation: 2130Reputation: 2130Reputation: 2130Reputation: 2130Reputation: 2130Reputation: 2130Reputation: 2130
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: 17,400

Rep: Reputation: 2584Reputation: 2584Reputation: 2584Reputation: 2584Reputation: 2584Reputation: 2584Reputation: 2584Reputation: 2584Reputation: 2584Reputation: 2584Reputation: 2584
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.


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 > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 05:25 PM.

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