Your question as posed leaves many questions. Do you
actually need Perl to convert the flatfile to an Excel
".xls" document or do you just want to put it into a
compatible format that can be imported into Excel?
I would choose the latter since you can import your data
directly into Excel as is:
- Name your file "something.txt"
- Start Excel
- Click File, Open
- Change 'Files of type:' to 'Text Files'
- Select the file to import and click the Open button
- Click the 'Delimited' radio button and click next
- In the delimiters section type '|' in the 'Other' box and click through whatever other options you need.
If this is something that you plan to do repetitively, you can always set up an Excel macro to handle it. HTH,
--Jim
Update: Note that unless you can find a module that converts directly from a text file of your format to an Excel "*.xls" file that you will still have to go through the Excel import feature (even if you tweak it with Perl).
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
| |
For: |
|
Use: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.