CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Intermediate:
text file to excel (.xls) file

 



ruisi27
New User

Dec 5, 2004, 10:16 PM

Post #1 of 3 (527 views)
text file to excel (.xls) file Can't Post

hi im currently working on a program that converts a text file (.txt) into excel file (.xls). I have a large .txt file containing raw data that is separated by tab.

---------------------------------

Example of the text file (below):

Code: E1: E2:

PLK001, 123, 0,

PLK002, 159, 15,

PLK003, 755, 20,

PLK004, 15, 12,

QLK001, 111, 152,

WLK001, 756, 125,

---------------------------------

For code starting with PLK, it is to be place in one excel file, QLK in another and so on. I am able to put all these data in a single excel file, but not able to put them in separate file. anyone have a solution for this?


davorg
Thaumaturge / Moderator

Dec 6, 2004, 1:34 AM

Post #2 of 3 (523 views)
Re: [ruisi27] text file to excel (.xls) file [In reply to] Can't Post

Sounds like you need Spreadsheet::WriteExcel.

--
Dave Cross, Perl Hacker, Trainer and Writer
http://www.dave.org.uk/
Get more help at Perl Monks


ruisi27
New User

Dec 12, 2004, 10:44 PM

Post #3 of 3 (518 views)
Re: [davorg] text file to excel (.xls) file [In reply to] Can't Post

im using Spreadsheet:writeexcel.

The problem im facing now is that i cant seem to be able to separate the data into different excel file.. any example for it?

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives