Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: .TXT to Excel

by GrandFather (Sage)
on Sep 20, 2016 at 21:09 UTC ( #1172247=note: print w/replies, xml ) Need Help??


in reply to .TXT to Excel

Why are you doing this? The assistance you need is different depending on the motive for your task:

  1. This is homework: you need hints so you can figure out how to do it for yourself
  2. You are learning and this is a self assigned exercise: as above, but sample code and some discussion are indicated
  3. You have a real world task: sample code using "production" techniques, probably including use of modules, are indicated, but tutorial type discussion is not needed
  4. You have a real world problem to solve and are using it to learn Perl and programming fundamentals: as above except some discussion of the code is appropriate.

So, why are you doing this?

Premature optimization is the root of all job security

Replies are listed 'Best First'.
Re^2: .TXT to Excel
by UCLAdan06 (Initiate) on Sep 21, 2016 at 13:54 UTC

    Grandfather, this is a real world problem that I have been instructed to use Perl for. I have a large model that will accept data from excel files and my current data is in .txt files. I have rows and columns of data in a .txt file that need to be put into an excel spreadsheet- each item in its own box. In the txt file, there are spaces between the columns of data, and I need a Perl mechanism for reading these spaces and assigning a new cell for each number.

      This sounds exactly like what csv2xls already does.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1172247]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (2)
As of 2018-07-23 06:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    It has been suggested to rename Perl 6 in order to boost its marketing potential. Which name would you prefer?















    Results (459 votes). Check out past polls.

    Notices?