Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Excel and Win32::Clipboard

by roho (Bishop)
on Mar 25, 2020 at 23:29 UTC ( [id://11114650]=note: print w/replies, xml ) Need Help??


in reply to Excel and Win32::Clipboard

Thank you for the suggestions, but unfortunately none of those made any difference.
The spreadsheet cell contains the value "Test"
The output in the file (with no encode and no binmode) is 48,265 bytes long!. It only copied the first four characters when I copied/pasted it here. Needless to say, it is a far cry from "Test": 

BMBl

[download]

Update: It works when "GetText()" is used instead of "Get()". Problem solved. :)

"It's not how hard you work, it's how much you get done."

Replies are listed 'Best First'.
Re^2: Excel and Win32::Clipboard
by pryrt (Abbot) on Mar 26, 2020 at 02:00 UTC
    The output in the file ... is 48,265 bytes long! ... It works when "GetText()" is used instead of "Get()"

    The Windows clipboard allows storing multiple formats of the same data in the same clipboard entry. When you copy from Excel, the clipboard both has a native-Excel format (your 48k), which includes all the cell information, formatting, etc; and has a plaintext; and maybe has other formats as well.

    Win32::Clipboard has the EnumFormats() to list the formats currently in the clipboard, and GetFormatName() to give you more info for "custom" formats. By switching to GetText() , you were forcing it to give you the CF_TEXT version instead of the native Excel format.

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://11114650]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others chilling in the Monastery: (3)
As of 2024-04-25 19:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found