Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Excel to Doc

by TJPride (Pilgrim)
on Mar 04, 2012 at 16:41 UTC ( [id://957785]=note: print w/replies, xml ) Need Help??


in reply to Excel to Doc

Docs are generally messy to work with. Is the only data inside the docs what you pasted?

apple.c Entry No:321 monks.pl Entry No:125

There are modules for reading docs and writing docs, but without some messy manipulation, I'm guessing the two aren't necessarily going to translate to each other without some messy code. The easiest solution would be to read the docs, convert the text, and then write out as something simpler, like plaintext or HTML or at worst, rtf. Short of that, you might consider batch converting the docs to text or rtf from MS Word itself, then batch converting them back once you're done running your script. Nothing knows how to convert docs better than MS Word, why reinvent the wheel?

The Excel sheet is relatively simple, you can convert to CSV and then use something basic like Text::CSV to read and write it.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://957785]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chanting in the Monastery: (2)
As of 2024-04-26 03:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found