Stripping characters from windows clipboard with win32clipboard from excel

Neil Hodgson nhodgson at iinet.net.au
Thu Sep 12 23:43:46 EDT 2013


Stephen Boulet:

>  From the clipboard contents copied from the spreadsheet, the characters s[:80684] were the visible cell contents, and s[80684:] all started with "b'\x0" and lack any useful info for what I'm trying to accomplish.

    Looks like Excel is rounding up its clipboard allocation to the next 
64K. There used to be good reasons for trying to leave some extra room 
on the clipboard and avoid reallocating the block but I thought that was 
over a long time ago.

    To strip NULs off the end of the string use s.rstrip('\0')

    Neil




More information about the Python-list mailing list