Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^3: Problems with Microsft's new Office 'XML'

by Corion (Pope)
on Oct 05, 2005 at 07:47 UTC ( #497508=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Problems with Microsft's new Office 'XML'
in thread Problems with Microsft's new Office 'XML'

As always, you do this by using Win32::OLE to automate Excel.

The steps are the usual six steps:

  1. Start the Excel Macro Recorder
  2. Perform the desired action(s) manually, in your case, save the file as XML
  3. Stop the Excel Macro Recorder
  4. Inspect the generated VB code
  5. Check that the generated VB code does what you want
  6. Translate the generated VB code to Perl / Win32::OLE invocations

There are many examples on this website which should give you a good start on how to do the translation. It consists mostly of s!\.!->! applied to every line of the code, and you will have to exchange the global properties like "ActiveWorkSheet" by the local values you get from $excel->OpenFile().


Comment on Re^3: Problems with Microsft's new Office 'XML'
Select or Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (18)
As of 2014-07-29 16:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (223 votes), past polls