Syntactic Confectionery Delight | |
PerlMonks |
Excel and Win32::Clipboardby roho (Bishop) |
on Mar 25, 2020 at 19:52 UTC ( [id://11114648]=perlquestion: print w/replies, xml ) | Need Help?? |
roho has asked for the wisdom of the Perl Monks concerning the following question:
When I select and copy a cell in an Excel spreadsheet and use Win32::Clipboard to retrieve it (see code below), the cell contents I retrieve via Get() and write to a file are not displayed correctly when I edit the file. I tried setting binmode and encoding to UTF-8 but that has no affect. How can I get copied data from Excel to come through Win32::Clipboard and display correctly as text? As always, TIA.
Steps to reproduce the problem:
1. Open Excel spreadsheet, select and copy a cell.
"It's not how hard you work, it's how much you get done."
Back to
Seekers of Perl Wisdom
|
|