Skip to content

Instantly share code, notes, and snippets.

@hahastudio
hahastudio / gist:4bca83824d594db350a3e90e538f1171
Created August 23, 2018 11:17 — forked from parano/gist:1868242
Excel表格密码保护的解除方法
表格受密码保护时,我们修改数据Excel弹出“您试图更改的单元格或图表受保护,因而是只读的。
若要修改受保护单元格或图表,请先使用‘撤消工作表保护’命令(在‘审阅’选项卡的‘更改’组中)来取消保护。
可能会提示输入密码。这时候我们可以用VBA宏代码破解法来破解表格保护密码:
第一步:打开该文件,先解除默认的“宏禁用”状态,方法是点击工具栏下的“选项”状态按钮,
打开“Microsoft Office安全选项”窗口,选择其中的“启用此内容”,“确定”
再切换到“视图”选项卡,点击“宏”→“录制宏”,出现“录制新宏”窗口,在“宏名”定义一个名称为:
PasswordBreaker,点击“确定”退出;
第二步:再点击“宏”→“查看宏”,选择“宏名”下的“PasswordBreaker”并点击“编辑”,
打开“Microsoft Visual Basic”编辑器,用如下内容替换右侧窗口中的所有代码:
@hahastudio
hahastudio / bar-data.csv
Created December 4, 2018 04:00
D3.js time scale on IE
category date value
A 1/1/2013 53
B 1/2/2013 165
C 1/3/2013 269
def continuous_sum(lst):
if len(lst) <= 1:
return lst
total = 0
results = []
for i in lst:
if i == 0:
continue
if i > 0:
if total >= 0:
@hahastudio
hahastudio / terminal.log
Last active December 13, 2021 03:05
npm log when installing create-react-app
npm http fetch GET 200 https://registry.npmjs.org/tar/-/tar-2.2.2.tgz 1693ms (cache miss)
npm WARN deprecated [email protected]: This version of tar is no longer supported, and will not receive security updates. Please upgrade asap.
npm timing reifyNode:node_modules/tar Completed in 1770ms
npm timing reify:unpack Completed in 1773ms
npm timing reify:unretire Completed in 1ms
npm timing build:queue Completed in 5ms
npm timing build:link:node_modules/tmp/node_modules/rimraf Completed in 27ms
npm timing build:link:node_modules/create-react-app Completed in 31ms
npm timing build:link:node_modules/envinfo Completed in 30ms
npm timing build:link:node_modules/rimraf Completed in 31ms
import openai
# add your API key here
openai.api_key = ''
messages = []
system_msg = input("你想要创建什么样的聊天机器人?")
messages.append({"role": "system", "content": system_msg})
print("和你的聊天机器人问好!输入quit来退出。")