Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

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

by graq (Curate)
on Oct 05, 2005 at 07:39 UTC ( #497504=note: print w/replies, xml ) Need Help??

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

You are referencing the "xls" file which is still binary. Change your filename to "spreadsheet.xml" and save the file as xml.

OK. This is meant to be an automated process, removing the human interaction - how do I do this with Perl?

  • Comment on Re^2: Problems with Microsft's new Office 'XML'

Replies are listed 'Best First'.
Re^3: Problems with Microsft's new Office 'XML'
by Corion (Pope) on Oct 05, 2005 at 07:47 UTC

    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().

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://497504]
[Discipulus]: ..or inspect the source code of the module
[makita]: I am doing this:
[makita]: my $sig = $wss->signature( schema => $wsdl, token => $token, sign_types=>'wsa: Action','wsa:To', 'wsu:Timestamp', 'wsa:MessageID',' SOAP-ENV:Body', signer=>DSIG_RSA_S HA1, public_key => $cert,
[Corion]: Oof, I haven't done much with signing SOAP requests. markov is usually somebody good to ask via mail ;)
[makita]: I need to create a SOAP call where are signed more types not only the body
[makita]: I am inspecting it second day :)
[makita]: Thanks
[Discipulus]: better to ask a full SOPW
erix self-flagellates with the cluebat
[erix]: indeed had to be( time make check-world ) > test_run2.output 2>&1

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (11)
As of 2017-03-23 08:49 GMT
Find Nodes?
    Voting Booth?
    Should Pluto Get Its Planethood Back?

    Results (285 votes). Check out past polls.