Note that there are some explanatory texts on larger screens.

plurals
  1. USuser1070061
    primarykey
    data
    text
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COThinking that maybe copy didn't copy over the macro button, I thought I'd try using deepcopy() by putting in these lines: wb1 = deepcopy(rb) wb = xlrd.open_workbook(wb1) but that gets me the following error: > File "N:\Tools\Scripts-DEV\Scan_Analysis_DEV\tcompliance8.py", line 25, i n <module> wb.get_sheet(0).write(3, 0, 'Due Date') File "C:\Python27\lib\site-packages\xlrd\__init__.py", line 984, in get_sheet raise XLRDError("Can't load sheets after releasing resources.") xlrd.biffh.XLRDError: Can't load sheets after releasing resources.
      singulars
    2. COOK, I've been coding and testing while you guys have been answering (THANKS!). Here's what I changed the import lines to 'from time import time, sleep, localtime from datetime import datetime, timedelta' which enabled everything to work except the sleep statement. If I use 'time.sleep(60)' I get _AttributeError: 'builtin_function_or_method' object has no attribute 'sleep'_ but if I use 'time.time.sleep(60)' I get the same error.
      singulars
    3. COOK, I've been coding and testing while you guys have been answering (THANKS!). Here's what I changed the import lines to: from time import time, sleep, localtime from datetime import datetime, timedelta which enabled everything to work except the sleep statement. After mucking around with 'time.sleep(60)' then 'time.time.sleep(60)', what finally worked was 'sleep(60)'
      singulars
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload