honzapav

SELECT
    cols.table_schema,
    cols.table_name,
    cols.column_name,
    cols.data_type,
    cols.column_default,
    (
        SELECT CASE 
               WHEN COUNT(*) > 0 THEN 'Yes' 
               ELSE 'No' 

honzapav

Sub HideEveryOtherRow()
'Updateby20140317
Dim rng As Range
Dim InputRng As Range
xTitleId = "KutoolsforExcel"
Set InputRng = Application.Selection
Set InputRng = Application.InputBox("Range :", xTitleId, InputRng.Address, Type:=8)
Application.ScreenUpdating = False
For i = 1 To InputRng.Rows.Count Step 2
    Set rng = InputRng.Cells(i, 1)

honzapav

Sub ExtractHL()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
Next
End Sub

honzapav

'ač', 'ad', 'ah', 'ai', 'aj', 'ak', 'ap', 'aš', 'ať', 'au', 'až', 'by', 'či', 'čj', 'čl', 'co', 'dá', 'do', 'dr', 'ec', 'es', 'fa', 'fn', 'fy', 'hd', 'hl', 'ho', 'hw', 'já', 'je', 'ji', 'kb', 'ke', 'km', 'ks', 'ku', 'kv', 'lg', 'li', 'lq', 'má', 'mb', 'mé', 'mi', 'mu', 'na', 'nc', 'nd', 'ne', 'ně', 'nf', 'nv', 'od', 'ok', 'on', 'op', 'os', 'pa', 'pc', 'pí', 'po', 'př', 'pt', 'sb', 'se', 'si', 'sk', 'ss', 'sš', 'st', 'sw', 'ta', 'té', 'ti', 'tj', 'to', 'tř', 'tu', 'ty', 'uč', 'uk', 'úl', 'um', 'úv', 'už', 've', 'ví', 'vš', 'vy', 'wc', 'xt', 'za', 'ze', 'že', 'zš', 'a přec', 'a přece', 'a přeci', 'a sice', 'a to', 'a/čeština', 'aby', 'aji', 'ale', 'an', 'aneb', 'ani', 'aniž', 'ano i', 'anžto', 'avšak', 'ačkoli', 'ačkoliv', 'ba', 'bo', 'buď', 'div', 'dokud', 'dílem', 'enem', 'hned', 'i', 'i když', 'jakkoliv', 'jako', 'jakoby', 'jednak', 'jen', 'jenom', 'jenže', 'jestli', 'jestliže', 'jinak', 'kdyby', 'když', 'kór', 'ledva', 'leč', 'málem', 'neb', 'nebo', 'neboli', 'neboť', 'než', 'nežli', 'ni', 'nicméně', 'nobrž

honzapav

https://free.sharedcount.com/?url={sem-patri-url}&apikey={sem-patri-api-key}

pro OpenRefine:

'https://free.sharedcount.com/?url=' + value + '&apikey={sem-patri-api-key}'

value.parseJson()[„like_count“] 
value.parseJson()[„share_count“]
value.parseJson()[„GooglePlusOne“]
value.parseJson()[„Twitter“]

honzapav

a able about across after ain't all almost also am among an and any are aren't as at be because been but by can can't cannot could could've couldn't did didn't do does doesn't don't either else ever every for from get got had has hasn't have he he'd he'll he's her hers him his how how'd how'll how's however i i'd i'll i'm i've if in into is isn't it it's its just least let like likely may me might might've most must must've mustn't my neither no nor not of off often on only or other our own rather said say says she she'd she'll she's should should've shouldn't since so some than that that'll that's the their them then there there's these they they'd they'll they're they've this to too us wants was wasn't we we'd we'll we're were weren't what what's when where where'd where'll where's which while who who'd who'll who's whom why why'd will with won't would would've wouldn't yet you you'd you'll you're you've your

honzapav

ač,ad,ah,ai,aj,ak,ap,aš,ať,au,až,by,či,čj,čl,co,dá,do,dr,ec,es,fa,fn,fy,hd,hl,ho,hw,já,je,ji,kb,ke,km,ks,ku,kv,lg,li,lq,má,mb,mé,mi,mu,na,nc,nd,ne,ně,nf,nv,od,ok,on,op,os,pa,pc,pí,po,př,pt,sb,se,si,sk,ss,sš,st,sw,ta,té,ti,tj,to,tř,tu,ty,uč,uk,úl,um,úv,už,ve,ví,vš,vy,wc,xt,za,ze,že,zš,a přec,a přece,a přeci,a sice,a to,a/čeština,aby,aji,ale,an,aneb,ani,aniž,ano i,anžto,avšak,ačkoli,ačkoliv,ba,bo,buď,div,dokud,dílem,enem,hned,i,i když,jakkoliv,jako,jakoby,jednak,jen,jenom,jenže,jestli,jestliže,jinak,kdyby,když,kór,ledva,leč,málem,neb,nebo,neboli,neboť,než,nežli,ni,nicméně,nobrž,nýbrž,pak,pokud,potom,protože,přesto,přestože,seč,sice,sotva,tak,takže,tedy,totiž,tož,třeba,třebaže,však,vždyť,zatím co,zatímco,zda,čili,bez,beze,blízko,během,cestou,coby,dle,dík,díky,k,kol,kolem,kromě,kvůli,mezi,mimo,místo,nad,nade,naproti,navzdory,o,ob,ode,ohledně,okolo,oproti,poblíž,pod,pode,podle,podlevá,podlivá,podél,pomocí,pro,prostřednictvím,proti,před,přede,přes,přese,při,s,skrz,skrze,stran,u,u příležitosti,uprostřed,v,vedle,vino