L
LeeRisq
Hi all,
Newbie question. I've written a script that outputs to a text file.
Now, I just want to copy the content to win32clipboard for access to
other applications. Here's the mess I've come up with so far
import xlrd
import win32clipboard
def program_uno():
ofile = open(r"C:\Query\DQL.txt", "w")
book = xlrd.open_workbook("C:\DocLoader\MCL_Drawing and Legacy
Docloader Sheet.xls")
sh = book.sheet_by_index(0)
e = sh.cell_value(1, 0)
a = sh.col_values(0, start_rowx=2, end_rowx=200)
b = r'%' + e
c = r'%Draft%'
y = r"some text..." %(b, c)
w = r"some more text..."
ofile.writelines(y)
for x in a:
d = r'%' + x
z = r" loop text..." %(d, c)
f = ofile.writelines(z)
ofile.writelines(w)
def copy_text():
ifile = open(r"C:\Query\DQL.txt", "r")
win32clipboard.OpenClipboard(0)
win32clipboard.EmptyClipboard()
win32clipboard.SetClipboardText()
win32clipboard.CloseClipboard
program_uno()
copy_text()
Newbie question. I've written a script that outputs to a text file.
Now, I just want to copy the content to win32clipboard for access to
other applications. Here's the mess I've come up with so far
import xlrd
import win32clipboard
def program_uno():
ofile = open(r"C:\Query\DQL.txt", "w")
book = xlrd.open_workbook("C:\DocLoader\MCL_Drawing and Legacy
Docloader Sheet.xls")
sh = book.sheet_by_index(0)
e = sh.cell_value(1, 0)
a = sh.col_values(0, start_rowx=2, end_rowx=200)
b = r'%' + e
c = r'%Draft%'
y = r"some text..." %(b, c)
w = r"some more text..."
ofile.writelines(y)
for x in a:
d = r'%' + x
z = r" loop text..." %(d, c)
f = ofile.writelines(z)
ofile.writelines(w)
def copy_text():
ifile = open(r"C:\Query\DQL.txt", "r")
win32clipboard.OpenClipboard(0)
win32clipboard.EmptyClipboard()
win32clipboard.SetClipboardText()
win32clipboard.CloseClipboard
program_uno()
copy_text()