This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'작성일 : 2012.09.05 | |
'작성자 : 서재원 | |
'출처 : http://support.microsoft.com/kb/2669736/ko | |
'설명 : 파워포인트용 VBA모듈 | |
' 파워포인트 메모를 모두 텍스트 파일로 익스포트 한다. | |
Sub ExportNotesText() | |
Dim oSlides As Slides | |
Dim oSl As Slide |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'사용법 | |
'이 모듈은 셀을 복사할 시트에 열 추가 -> 셀 붙여넣기 의 작업을 단순화 시킨다. | |
'PasteRangeWithInsertRows함수를 특정 단축키에 지정하고 사용하면 유용하다. | |
'<사용법 동영상 삽입예정> | |
'작성일 : 2012.08.22 | |
'작성자 : 서재원 | |
'설명 : 엑셀 VBA 매크로 | |
' 범위 열을 복사한다. | |
' 열이 모자라면 그만큼 열을 추가한다. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'작성일 : 2012.09.05 | |
'작성자 : 서재원 | |
'설명 : 파워포인트용 VBA모듈 | |
' 파워포인트 택스트를 검색한다. | |
' 검색조건에 부합하는 텍스트를 디버깅 창에 출력한다. | |
'검색조건 딕셔너리 프로퍼티 | |
Private Property Get keyWordsPatterns() As Collection | |
Dim patterns As New Collection | |
'이 시점에 검색할 문자열을 추가한다. | |
'RegExp형식이어야 한다. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'작성일 : 2012.09.11 | |
'작성자 : 서재원 | |
'출처 : http://support.microsoft.com/kb/2669736/ko | |
'설명 : 엑셀용 VBA모듈 | |
' 엑셀 시트를 나누어 출력하도록 양식을 맞추어 준다. | |
Sub activeSheetPageSetup(ByVal printOrientation As XlPageOrientation, ByVal leftHeaderImgSrc As String) | |
Dim targetOrientation As XlPageOrientation | |
targetOrientation = printOrientation | |
'페이지를레이아웃뷰로변경 | |
ActiveWindow.View = xlPageLayoutView |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# -*- coding: utf-8 -*- | |
""" | |
This script will delete all of the tweets in the specified account. | |
You may need to hit the "more" button on the bottom of your twitter profile | |
page every now and then as the script runs, this is due to a bug in twitter. | |
You will need to get a consumer key and consumer secret token to use this | |
script, you can do so by registering a twitter application at https://dev.twitter.com/apps | |
@requirements: Python 2.5+, Tweepy (http://pypi.python.org/pypi/tweepy/1.7.1) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# -*- coding: UTF-8 -*- | |
__author__ = 'cinos81' | |
import threading | |
import time | |
#함수를 쓰레드로 만들 때의 공유자원을 가정한 변수 | |
globalResource = 0 | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* Created by cinos81 on 2014. 6. 24.. | |
*/ | |
var paramFromQryStr = function(url){ | |
/* | |
* 첫번째 정규식 | |
* . : 모든 글자로부터 | |
* + : 1개 이상의 글자를 | |
* ? : ? 를 만날 때까지 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
__author__ = 'artemr' | |
''' | |
왜 파이썬 데코레이터를 만들때, @wraps어노테이션을 쓰는 것을 권장하는 걸까? | |
이유인 즉슨, 데코레이터 내부에서 인자로 전달받은 함수가 익명함수 처럼 취급되어 버리므로 디버깅이 난해해지는 단점이 있었기 때문이다. | |
자세한 설명은 아래의 링크에 첨부되어 있다. | |
원본: http://artemrudenko.wordpress.com/2013/04/15/python-why-you-need-to-use-wraps-with-decorators/ | |
사본: https://www.evernote.com/shard/s174/sh/78eaad5f-a8f2-4496-b984-e3385fb963c0/922d9ab4b5cd23ac7b85aab42536aa4f | |
''' | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
__author__ = 'cinos81' | |
if __name__ == '__main__': | |
testList = [{'a': 1, 'b': 2}, {'a': 'a', 'b': 'b'}] | |
print testList | |
subsetList = [{key: value for key,value in record.items() if key == 'a'} for record in testList] | |
print subsetList |
OlderNewer