Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Excel to Doc

by Gangabass (Priest)
on Mar 05, 2012 at 10:50 UTC ( #957873=note: print w/ replies, xml ) Need Help??


in reply to Excel to Doc

You can do this using Win32::OLE for changes in Word.

Just read data from Excel file (with Spreadsheet::ParseExcel?). Next you need to open each *.doc file you have with Win32:OLE and make advanced search (using Word's regular expressions) for string you need (for example, monks.pl[ ]@Entry[ ]@No:[0-9]@>) and change finded string to the value you need.

Next you need to make another search (from beginning of the document) for another Excel entry.


Comment on Re: Excel to Doc
Select or Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (2)
As of 2014-12-27 06:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (176 votes), past polls