Skip to content

Instantly share code, notes, and snippets.

View parano's full-sized avatar
🍱

Chaoyu parano

🍱
View GitHub Profile
@parano
parano / gist:1868242
Created February 20, 2012 07:18
Excel表格密码保护的解除方法
表格受密码保护时,我们修改数据Excel弹出“您试图更改的单元格或图表受保护,因而是只读的。
若要修改受保护单元格或图表,请先使用‘撤消工作表保护’命令(在‘审阅’选项卡的‘更改’组中)来取消保护。
可能会提示输入密码。这时候我们可以用VBA宏代码破解法来破解表格保护密码:
第一步:打开该文件,先解除默认的“宏禁用”状态,方法是点击工具栏下的“选项”状态按钮,
打开“Microsoft Office安全选项”窗口,选择其中的“启用此内容”,“确定”
再切换到“视图”选项卡,点击“宏”→“录制宏”,出现“录制新宏”窗口,在“宏名”定义一个名称为:
PasswordBreaker,点击“确定”退出;
第二步:再点击“宏”→“查看宏”,选择“宏名”下的“PasswordBreaker”并点击“编辑”,
打开“Microsoft Visual Basic”编辑器,用如下内容替换右侧窗口中的所有代码:
@parano
parano / gist:181bcbf4046bab23a716
Last active October 1, 2015 05:28
scrape jingdina
#!/usr/bin/ruby
# coding: utf-8
require 'uri'
require 'iconv'
require 'open-uri'
if $0 == __FILE__
url = 'http://jingdian.tuniu.com/fengjing/'
num = 1
@parano
parano / gist:44c086b3d09c329751f0
Last active October 1, 2015 06:28
multithread scrape
#!/usr/bin/ruby
# coding: utf-8
require 'uri'
#require 'iconv'
require 'open-uri'
require 'thread'
def scrape(from,to,n)
begin
@parano
parano / dom-like-parsing.rb
Created February 29, 2012 08:41
scrape jingdian
#!/usr/bin/ruby -w
require 'rexml/document'
include REXML
xmlfile = File.new("tour_treepath_area.xml")
xmldoc = Document.new(xmlfile)
root = xmldoc.root
#puts root.attributes["ver"]
@parano
parano / gist:9c7290220a230b82de37
Created April 19, 2013 04:59
use peterson method to implement semaphore
/*
* =====================================================================================
*
* Filename: mutex_semaphore.c
*
* Description: use peterson method to implement semaphore
*
* Version: 1.0
* Created: 04/16/2013 03:27:04 PM
* Revision: none
#!/bin/ruby
require 'RMagick'
include Magick
animation = ImageList.new(*Dir["*.png"])
animation.delay = 10
animation.write("animated.gif")
@parano
parano / gist:9518893
Created March 12, 2014 23:29
Sending Keystrokes to OS X via osascript, in Ruby
#!/usr/bin/ruby -w
def presskey(keycode)
system "osascript -e 'tell application \"System Events\" to key code #{keycode}'"
end
kVK_LeftArrow = 123
kVK_RightArrow = 124
kVK_DownArrow = 125
kVK_UpArrow = 126
@parano
parano / gist:9653676
Created March 19, 2014 23:19
Send random arrow keys using ruby, Mac OS X only
#!/usr/bin/ruby -w
def presskey(keycode)
system "osascript -e 'tell application \"System Events\" to key code #{keycode}'"
end
kVK_LeftArrow = 123
kVK_RightArrow = 124
kVK_DownArrow = 125
kVK_UpArrow = 126
@parano
parano / gist:10683720
Created April 14, 2014 21:23
Recursively delete all the '.DS_Store' files under current folder and its sub-folders
sudo find ./ -name ".DS_Store" -depth -exec rm -f {} \;
@parano
parano / gist:3ccaeeb5974564f8132d
Last active August 29, 2015 14:05
Ruby on Rails Controller - Allow Origin Header
class ApplicationController < ActionController::Base
before_filter :cors_set_access_control_header
# other staff
private
def cors_set_access_control_header
headers['Access-Control-Allow-Origin'] = '*'
headers['Access-Control-Allow-Methods'] = 'POST, PUT, DELETE, GET, OPTIONS'
headers['Access-Control-Request-Method'] = '*'