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

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

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


New User

Dec 5, 2004, 10:16 PM

Post #1 of 3 (544 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?

Thaumaturge / Moderator

Dec 6, 2004, 1:34 AM

Post #2 of 3 (540 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
Get more help at Perl Monks

New User

Dec 12, 2004, 10:44 PM

Post #3 of 3 (535 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