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.

[reply]

      This sounds exactly like what csv2xls already does.

[reply]

In Section Seekers of Perl Wisdom