[B! PowerShell] yassan0627ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yassan0627 id:yassan0627

PowerShellã«é–¢ã™ã‚‹yassan0627ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (46)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

[PowerShell] Oh my Posh (Powerline) ã‚’ä½¿ã£ã¦PowerShellã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‚’ãŠã—ã‚ƒã‚Œã«ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã™ã‚‹ | DevelopersIO
[PowerShell] Oh my Posh (Powerline) ã‚’ä½¿ã£ã¦PowerShellã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‚’ãŠã—ã‚ƒã‚Œã«ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã™ã‚‹ ã—ã°ãŸã§ã™ã€‚ Bashã‚„Zshãªã©ã®ã‚·ã‚§ãƒ«ã§ã¯Powerlineã‚’ã¤ã‹ã£ã¦ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã®ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚’ãŠã—ã‚ƒã‚Œã«ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ (ä¸Šå›³ã¯ã“ã‚Œã‹ã‚‰èª¬æ˜Žã™ã‚‹å†…å®¹ã‚’å®Ÿæ–½ã—ãŸå¾Œã®çµæžœã§ã™ãŒã€ã“ã‚“ãªæ„Ÿã˜ã®è¡¨ç¤ºãŒã§ãã‚‹ã‚„ã¤ã§ã™) ã“ã®æœ¬å®¶Powerlineã¯PowerShellã«ã¯å¯¾å¿œã—ã¦ã„ãªã„ã®ã§ã™ãŒã€PowerShellã§ã‚‚æ´¾ç”Ÿãƒ—ãƒãƒ€ã‚¯ãƒˆã§ã‚ã‚‹chrisbenti / PS-Config ã€Jaykul / PowerLineã€JanDeDobbeleer / oh-my-poshã¨ã„ã£ãŸOSSãŒä»¥å‰ã‹ã‚‰å˜åœ¨ã—ã¦ãŠã‚Šæœ¬å®¶ã¨åŒã˜æ§˜ãªã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã‚’ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ã“ã®ã†ã¡oh-my-poshã«ã¤ã„ã¦ã¯Docsã§ã‚‚å–ã‚Šä¸Šã’ã‚‰ã‚ŒWindo
yassan0627 2021/01/08
PowerShell

windows
ãƒªãƒ³ã‚¯
PowerShell ã« git branch æƒ…å ±ã‚’è¡¨ç¤ºã™ã‚‹ - tokuhirom's blog
yassan0627 2020/03/22
PowerShell

git
ãƒªãƒ³ã‚¯
ãã‚Œã¦ã‚™ã‚‚åƒ•ã¯ãƒ¦ãƒ‹ãƒƒãƒˆãƒ†ã‚¹ãƒˆã‚’æ›¸ããŸã„ - Pester powered by PowerShell
yassan0627 2016/04/10
PowerShell
ãƒªãƒ³ã‚¯
http://winscript.jp/powershell/306
yassan0627 2015/12/16
powershell
ãƒªãƒ³ã‚¯
ã€PowerShellã€‘ä»–ãƒ—ãƒã‚»ã‚¹ã®å®Ÿè¡Œæ–¹æ³•ã¾ã¨ã‚ - Tumbling Dice
2018/11/22 è¿½è¨˜ ä»¥ä¸‹ã®ä¿®æ£ã‚’è¡Œã„ã¾ã—ãŸã€‚ ã¡ã‚ƒã‚“ã¨ã‚·ãƒ³ã‚¿ãƒƒã‚¯ã‚¹ãƒã‚¤ãƒ©ã‚¤ãƒˆã‚’é©ç”¨ã—ã¾ã—ãŸã€‚ å‘¼ã³å‡ºã—å…ƒã®ãƒ—ãƒã‚»ã‚¹ã«æ¨™æº– / ã‚¨ãƒ©ãƒ¼å‡ºåŠ›ã‚’ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã™ã‚‹æ–¹æ³•ã‚’è¿½è¨˜ã—ã¾ã—ãŸã€‚ ä¸€éƒ¨ã®ãƒªãƒ³ã‚¯ãŒ 404 ã‚’è¿”ã™ã‚ˆã†ã«ãªã£ãŸã®ã§å‰Šé™¤ã—ã¾ã—ãŸã€‚ å‰æ›¸ã ä½•ã ã‹ã‚“ã ã§æœ€è¿‘ PowerShell ã‚’æ›¸ãæ©Ÿä¼šãŒå¢—ãˆã¾ãã£ã¦ã„ã¾ã™ã€‚ã¾ãä¸èº«ã¯ã»ã¨ã‚“ã© C#ãªã‚“ã§ã™ãŒã€‚ ã§ã€å…¨éƒ¨ C#ã§æ›¸ã„ã¦ã‚‚ã„ã„ã‚“ã ã‘ã©ã€å¤–éƒ¨ãƒ„ãƒ¼ãƒ«ä½¿ãˆã°ä¸€çž¬ã¿ãŸã„ãªã‚‚ã®ã‚‚ã‚ã‚‹ã®ã§ã€ãã†è¨€ã†ã‚‚ã®ã¯ãªã‚‹ã¹ããã£ã¡ã§ã‚„ã£ã¦ã—ã¾ã„ãŸã„ã§ã™ã€‚ç‰¹ã« zip é–¢é€£ã®å‡¦ç†ã€‚ ã‚·ã‚§ãƒ«ã£ã¦ãã‚‰ã„ãªã‚“ã ã‹ã‚‰ãã‚Œãã‚‰ã„ç°¡å˜ã«ã§ãã‚‹ã§ã—ã‚‡ãƒ¼ï¼Ÿã¨æ€ã£ã¦ã„ãŸã‚‰å¤§åˆ†ãƒãƒžã£ãŸã®ã§è‰²ã€…ã¨ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã™ã€‚ å®Ÿè¡Œä¾‹ å¼•æ•°ã§å—ã‘å–ã£ãŸãƒ•ã‚©ãƒ«ãƒ€ã®ã‚µãƒ–ãƒ•ã‚©ãƒ«ãƒ€å†…ã«ã‚ã‚‹ zip ãƒ•ã‚¡ã‚¤ãƒ«ã‚’C:\Program Files\7-Zip\7z.exeã§è§£å‡ã™ã‚‹ã€ã¿ãŸã„ãªãƒ‘ã‚¿ãƒ¼ãƒ³
yassan0627 2015/07/13
ã‚ã¨ã§èªã‚€

PowerShell
ãƒªãƒ³ã‚¯
PowerShellã§æ–‡å—åˆ—ã®æ¯”è¼ƒã‚’ã™ã‚‹éš›ã®Tips - tech.guitarrapc.cÃ³m
ä½™ã‚Šæœ¬ä»¶ã«é–¢ã—ã¦æ›¸ãã“ã¨ãŒç„¡ã„ã®ã§ã™ãŒâ€¦ä¸€å¿œç°¡å˜ãªã‚µãƒ³ãƒ—ãƒ«ã‚’ã€‚ ä»Šå›žã¯ã€æ™‚ã€…ã‚¢ãƒ¬ã£ï¼Ÿã£ã¦è‡ªåˆ†ã§æ€ã†ãŸã‚ã€ãƒ†ã‚ã‚¹ãƒˆã«å«ã¾ã‚Œã‚‹ã‹ã©ã†ã‹/æ¯”è¼ƒã‚’è¦‹ã‚‹æ–¹æ³•ã®ãƒ¡ãƒ¢ã§ã™ã€‚ ==== ã‚µãƒ³ãƒ—ãƒ« ä»Šå›žã€ã“ã‚Œã‚‰ã‚’è©¦ã—ã¦ã¿ã¾ã™ã€‚ "abc".Contains("a") "Abc".Contains("a") "" "abc" -contains "a" @("abc","bc","c") -contains "a" @("abc","bc","c") -contains "c" @("abc","bc","C") -contains "c" "" "abc" -ccontains "a" @("abc","bc","c") -ccontains "a" @("abc","bc","c") -ccontains "c" @("abc","bc","C") -ccontains "c" "" "a" -in "a
yassan0627 2015/06/09
PowerShell

tips
ãƒªãƒ³ã‚¯
PowerShell ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«è©³è§£ã¨ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¸ã®ã‚³ãƒžãƒ³ãƒ‰ãƒ¬ãƒƒãƒˆé…ç½®æ‰‹æ³•ã‚’è€ƒãˆã‚‹ - tech.guitarrapc.cÃ³m
PowerShell Advent Calendar 2013 ã«å‚åŠ ã•ã›ã¦ã„ãŸã ã„ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¯2æ—¥ç›®ã®è¨˜äº‹ã¨ãªã‚Šã¾ã™ã€‚ ä»Šå›žã¯ã€Windows PowerShell ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«æ©Ÿæ§‹ã‚’åˆ©ç”¨ã™ã‚‹ã«ã‚ãŸã‚Šä»¥ä¸‹ã®2ã¤ã«é–¢ã—ã¦è€ƒãˆã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ 4ã¤ã‚ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«å„ç¨®ã®è©³è§£ ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¸ã®ã‚³ãƒžãƒ³ãƒ‰ãƒ¬ãƒƒãƒˆé…ç½®æ‰‹æ³• æ³¨æ„ : æœ¬è¨˜äº‹ã¯PowerShell 3.0ä»¥ä¸Š (ç§ã®ç’°å¢ƒã¯ PowerShell 4.0)ã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã„ã¾ã™ã€‚PowerShell 2.0 ã§ã¯ä¸€éƒ¨ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿åç§°ãŒç•°ãªã£ãŸã‚Šã—ã¾ã™ãŒã€ãã“ã¯å¯Ÿã—( æŽ¨å¥¨ : ä»¥å‰æ›¸ã„ãŸ Windows 8.1 ã‚„ Windows Server 2012 R2 ä»¥å¤–ã§ Windows PowerShell 4.0ã‚’åˆ©ç”¨ã™ã‚‹æ–¹æ³•ã‚’å‚è€ƒã«ã—ã¦ã„ãŸã ã‘ã‚Œã°å¹¸ã„ã§ã™ã€‚ ç›®æ¬¡ ç›®æ¬¡ ãªãœãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹ã®ã‹ ã¨ã‚ã‚‹PowerShellerã®æ€ã„
yassan0627 2015/04/19
PowerShell

module

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
IT Pro ã®ãŸã‚ã® PowerShell ã‚¹ã‚¯ãƒªãƒ—ãƒ†ã‚£ãƒ³ã‚°
2. è‡ªå·±ç´¹ä»‹ â€¢ é«˜äº• ä¸€è¼ (Takai Kazuki) â€¢ æŸ ISP å‹¤å‹™ â€¢ ã‚¯ãƒ©ã‚¦ãƒ‰ã¨ã‚ªãƒ³ãƒ—ãƒ¬ãƒŸã‚¹ã‚’çµ„ã¿åˆã‚ã›ãŸã‚¤ãƒ³ãƒ†ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ â€¢ è¦‹ç©ã‚Šã€ææ¡ˆæ›¸ã®ä½œæˆã‹ã‚‰è¨è¨ˆã€æ§‹ç¯‰ã€è©¦é¨“ã€é‹ç”¨ã¾ã§ â€¢ ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã€ã‚µãƒ¼ãƒ (Windowsã€Linux) â€¢ System Center User Group Japan (SCUGJ) â€¢ Twitter : @zhuky7 / Facebook : kazuki.takai â€¢ Blog : http://operationslab.wordpress.com/ 2
yassan0627 2015/04/19
PowerShell
ãƒªãƒ³ã‚¯
Browse code samples
yassan0627 2015/04/14
PowerShell

excel

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
More preview enhancements for Windows Azure AD Premium - Active Directory Blog - Site Home - TechNet Blogs
In Visual Studio 2022 17.10 Preview 2, weâ€™ve introduced some UX updates and usability improvements to the Connection Manager. With these updates we provide a more seamless experience when connecting to remote systems and/or debugging failed connections. Please install the latest Preview to try it out. Read on to learn what the Connection ...
yassan0627 2015/04/01
PowerShell

Profile
ãƒªãƒ³ã‚¯
PowerShell ã§ Profile ã‚’åˆ©ç”¨ã—ã¦ ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®è‡ªå‹•èªã¿è¾¼ã¿ã‚’ã—ã¦ã¿ã‚ˆã† - tech.guitarrapc.cÃ³m
PowerShellã‚’èµ·å‹•ã—ãŸã‚‰ã€ç‰¹å®šã®ã‚³ãƒžãƒ³ãƒ‰ã‚’è‡ªå‹•å®Ÿè¡Œã—ã¦ã»ã—ã„ã€‚ æ™‚ã«ã¯ã“ã®ã‚ˆã†ãªå¸Œæœ›ãŒã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ ã„ã‚ã‚†ã‚‹ã€bashãªã©ã§ã„ã† bash_profile çš„ãªãƒ¢ãƒŽã§ã™ãã€‚ PowerShell ã«ã‚‚ profile ãªè€ƒãˆã¯å˜åœ¨ã—ã¦ã„ã¾ã™ã®ã§ã€ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ ç›®æ¬¡ ç›®æ¬¡ å‚è€ƒ ç¾åœ¨ã®Profileç¢ºèª Profileã¨é©ç”¨å¯¾è±¡ ãƒ¦ãƒ¼ã‚¶ãƒ¼å˜ä½ ã‚·ã‚¹ãƒ†ãƒ å˜ä½ é©ç”¨å¯èƒ½ãªprofileãƒ‘ã‚¹ã®ç¢ºèª æ¨©é™ã«æ°—ã‚’ä»˜ã‘ã‚ˆã† profile ã®ä½œæˆ Profile ã§ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’èªã¾ã›ã‚‹ ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®çµ±åˆ Profile ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ã„ã‚Šã¾ã™ã‹ï¼Ÿ æœ€å¾Œã« å‚è€ƒ MSDNå…ˆç”Ÿã¯å‰å¤§ã§ã™ã€‚ Windows PowerShell Profiles ç¾åœ¨ã®Profileç¢ºèª powershell ã‚„ powershell_ise.exe ã‚’èµ·å‹•ã—ã¦ã€ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å…¥åŠ›ã™ã‚‹ã¨èªã¿è¾¼ã¾ã‚Œã¦ã„ã‚‹Pr
yassan0627 2015/04/01
PowerShell

Profile
ãƒªãƒ³ã‚¯
http://winscript.jp/powershell/292
yassan0627 2015/03/21
PowerShell
ãƒªãƒ³ã‚¯
powershell ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
yassan0627 2015/03/19
PowerShell

ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆ
ãƒªãƒ³ã‚¯
Copy Excel Worksheet from one Workbook to another with Powershell
yassan0627 2015/03/06
PowerShell

Excel
ãƒªãƒ³ã‚¯
Windows PowerShell Portal - TechNet Articles - United States (English) - TechNet Wiki
Introduction Windows PowerShell is the main component ofÂ the "Windows Management Framework" from Microsoft to automate task and to manage configurations. Windows PowerShell consist of a command-line shell and associated scripting language built on the .NET Framework. Windows PowerShell provides full access to the Component Object Model(COM), Windows Management Instrumentation (WMI)Â and Common In
yassan0627 2015/02/22
é–‹ç™º

ã‚¤ãƒ³ãƒ•ãƒ©

PowerShell

Windows
ãƒªãƒ³ã‚¯
PowerShell ã§ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã‚’ä¿ã£ãŸã¾ã¾ç‰¹å®šã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹(1) - tech.guitarrapc.cÃ³m
ä¹…ã€…ã®è¨˜äº‹ã§ã™ã€‚æ›´æ–°ãªãã¦ã”ã‚ã‚“ãªã•ã„ã€‚ ä»Šå›žã¯ã€PowerShell ã§ã‚ˆãå•é¡Œã«ãªã‚‹ã€ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã‚’ä¿ã£ãŸã¾ã¾ã®ç‰¹å®šãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚³ãƒ”ãƒ¼ã§ã™ã€‚ ç¶šç·¨ã«ã¤ã„ã¦ ã“ã®è¨˜äº‹ä¸ã®æ–¹æ³•ã¯åŠ¹çŽ‡é¢ã§ã‚ˆã‚ã—ããªã„ãŸã‚ã€äº‹å‰ã«ã‚³ãƒ”ãƒ¼å¯¾è±¡ã‚’ãƒ•ã‚£ãƒ«ã‚¿ã—ã¦ã‹ã‚‰å®Ÿè¡Œã™ã‚‹ã‚‚ã®ã‚’ç”¨æ„ã—ã¾ã—ãŸã€‚ã‚ˆã‚ã—ã‘ã‚Œã°ã“ã¡ã‚‰ã‚‚ã©ã†ãž tech.guitarrapc.com ç›®æ¬¡ ç¶šç·¨ã«ã¤ã„ã¦ ç›®æ¬¡ Copy-It em ã‚’ä½¿ã£ã¦ãƒ•ã‚©ãƒ«ãƒ€ã‚’ä¸¸ã”ã¨ã‚³ãƒ”ãƒ¼ã™ã‚‹ ç‰¹å®šã®ãƒ•ã‚¡ã‚¤ãƒ«ã ã‘ã‚³ãƒ”ãƒ¼ã™ã‚‹ è¤‡æ•°ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã‚’å¹³å¦åŒ–ã—ã¦ã‚³ãƒ”ãƒ¼ã™ã‚‹ ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã‚’ç¶æŒã—ã¦ç‰¹å®šã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ãŸã„ æŒ‡å®šã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã ã‘ã«ã—ãŸã‚‰ã©ã†ã‹ ä¸€å›žã‚³ãƒ”ãƒ¼ã—ã¦ã‹ã‚‰ã„ã‚‰ãªã„ã‚‚ã®ã‚’å‰Šé™¤ã—ã¦ã¯ã©ã†ã‹ å¿œç”¨ ã¾ã¨ã‚ Copy-It em ã‚’ä½¿ã£ã¦ãƒ•ã‚©ãƒ«ãƒ€ã‚’ä¸¸ã”ã¨ã‚³ãƒ”ãƒ¼ã™ã‚‹ PowerShell v3 ã«ãŠã„ã¦ã€Copy-It em ã‚’ä½¿ã†ã“ã¨ã§å®¹æ˜“ã«å¯èƒ½ã§ã™
yassan0627 2015/02/21
PowerShell
ãƒªãƒ³ã‚¯
Powershellã§Pesterã‚’ä½¿ã£ã¦ãƒ†ã‚¹ãƒˆã—ã¦ã¿ãŸ - ãªã‹æ—¥è¨˜
2013-12-26 Powershellã§Pesterã‚’ä½¿ã£ã¦ãƒ†ã‚¹ãƒˆã—ã¦ã¿ãŸ PowerShell Powershellã‚’ä¹…ã—ã¶ã‚Šã«ä½¿ã†æ©Ÿä¼šãŒã‚ã‚Šã€ãƒ†ã‚¹ãƒˆã—ãªãŒã‚‰ã‚¹ã‚¯ãƒªãƒ—ãƒˆæ›¸ããŸã„ãªï½žã¨èª¿ã¹ã¦ãŸã‚‰ã€Pesterã¨ã„ã†ã®ãŒãŠæ‰‹è»½ã§ã‚ã‹ã‚Šã‚„ã™ã‹ã£ãŸã®ã§ä½¿ã£ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ æ˜”ã€psexpectã‚’å°‘ã—ä½¿ã£ã¦ã¿ã¾ã—ãŸãŒã€Pesterã®æ–¹ãŒå€‹äººçš„ã«ã¯ã‚ã‹ã‚Šã‚„ã™ãã¦å¥½ãã ãªãã€‚ PSExpectã§TDDï¼ˆFizzBuzzã§ã„ã“ã†ï¼‰ - ãªã‹æ—¥è¨˜ æº–å‚™ ä½¿ã†ã«ã‚ãŸã£ã¦ã€ç°¡å˜ãªæº–å‚™ãŒå¿…è¦ã§ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ GitHubã®ãƒšãƒ¼ã‚¸pester/Pester Â· GitHubã‹ã‚‰ä¸€å¼ã‚’cloneã‚‚ã—ãã¯ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã™ã€‚ é©å½“ãªå ´æ‰€ã¸é…ç½® zipå½¢å¼ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸå ´åˆã«ã¯é©å½“ãªå ´æ‰€ã«å±•é–‹ã—ã¦ãŠãã¾ã™ã€‚ ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆ Powershellã®ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‚’èµ·å‹•ã—ã¦ã€Pesterã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’
yassan0627 2015/02/21
PowerShell

Pester

TDD
ãƒªãƒ³ã‚¯
PowerShellã§Excelã®èªã¿æ›¸ããƒ»ãƒ•ã‚¡ã‚¤ãƒ«ä½œæˆ : morituriã®ãƒ–ãƒã‚°
COMã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½¿ã£ã¦PowerShellã§Excelã‚’æ“ä½œã™ã‚‹ã€‚ ã¨ã‚Šã‚ãˆãšã€Excelã‚’é–‹ã„ã¦ã¿ã‚‹ã€‚ä»¥ä¸‹ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’å®Ÿè¡Œã™ã‚‹ã€‚ $excel = New-Object -ComObject Excel.Application $excel.Visible = $true COMã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã® Excel.Application ã‚’ New-Objectã‚³ãƒžãƒ³ãƒ‰ãƒ¬ãƒƒãƒˆ ã§ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹åŒ–ã€‚ COMã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¯ -ComObjectã‚ªãƒ—ã‚·ãƒ§ãƒ³ ã§æŒ‡å®šã™ã‚‹ã€‚ 2ã¤ç›®ã®ã‚³ãƒ¼ãƒ‰è¡Œã§ã€Visibleãƒ—ãƒãƒ‘ãƒ†ã‚£ ã‚’ $true ã«è¨å®šã—ã¦èµ·å‹•ã—ãŸExcelãŒè¦‹ãˆã‚‹ã‚ˆã†ã«ã—ã¦ã„ã‚‹ã€‚ æ“ä½œä¸ã®Excelã‚’éš ã—ã¦ãŠã„ã¦ã‚‚ã„ã„å ´åˆã¯ã€ã“ã®è¨å®šã¯ä¸è¦ã€‚ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®å®Ÿè¡Œãƒ†ã‚¹ãƒˆãªã©ã§ã€å‹•ä½œã‚’ç¢ºèªã™ã‚‹ãŸã‚ã«ã¯è¦‹ãˆã‚‹ã‚ˆã†ã«ã—ãŸæ–¹ãŒä¾¿åˆ©ã€‚ ç¶šã‘ã¦ã€ä»¥ä¸‹ã®ã‚³ãƒ¼ãƒ‰ã§ã€ãƒ¯ãƒ¼ã‚¯ãƒ–ãƒƒã‚¯ã‚’ä½œæˆã™ã‚‹ã€‚ $book = $exc
yassan0627 2015/02/19
PowerShell

excel
ãƒªãƒ³ã‚¯
Hey, Scripting Guy!: Learning to Excel
ã“ã®ãƒ–ãƒ©ã‚¦ã‚¶ãƒ¼ã¯ã‚µãƒãƒ¼ãƒˆã•ã‚Œãªããªã‚Šã¾ã—ãŸã€‚ Microsoft Edge ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã™ã‚‹ã¨ã€æœ€æ–°ã®æ©Ÿèƒ½ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ›´æ–°ãƒ—ãƒã‚°ãƒ©ãƒ ã€ãŠã‚ˆã³ãƒ†ã‚¯ãƒ‹ã‚«ãƒ« ã‚µãƒãƒ¼ãƒˆã‚’åˆ©ç”¨ã§ãã¾ã™ã€‚ Hey, Scripting Guy!Excel ã®æ´»ç”¨æ–¹æ³•ã‚’å¦ç¿’ã™ã‚‹ Microsoft Scripting Guys å…ˆæœˆã‹ã‚‰ã“ã® Scripting Guy ã¯ã€ã‚ªãƒ¼ã‚¹ãƒˆãƒ©ãƒªã‚¢ã§æš®ã‚‰ã—ãªãŒã‚‰ä»•äº‹ã‚’ã—ã¦ã„ã¾ã™ãŒã€ã‚ªãƒ¼ã‚¹ãƒˆãƒ©ãƒªã‚¢ã®åŒåƒšãŸã¡ã®å‰µé€ æ€§ã¨ã‚ã‚‰ã‚†ã‚‹é¢ã§ã®ãŸãã¾ã—ã•ã«å¸¸ã«é©šã‹ã•ã‚Œã¦ã„ã¾ã™ã€‚æ•°æ—¥å‰ã®æ™©ã€ãã“ã«ä½ã‚“ã§ã„ã‚‹å‹äººãŒ Scripting Guy ã¨å½¼ã®å¥¥ã•ã‚“ã‚’å¤•é£Ÿã«èª˜ã£ã¦ãã‚Œã¾ã—ãŸã€‚å½¼ã¯ã€ãƒ¬ã‚¹ãƒˆãƒ©ãƒ³ã¯å®¿æ³Šå…ˆã®ãƒ›ãƒ†ãƒ«ã‹ã‚‰æ©ã„ã¦ã™ãã ã¨è¨€ã„ã¾ã—ãŸã€‚ 40 åˆ†å¾Œã€ç´ æ•µãªãƒ¬ã‚¹ãƒˆãƒ©ãƒ³ã«åˆ°ç€ã—ã¾ã—ãŸã€‚ãã®ãƒ¬ã‚¹ãƒˆãƒ©ãƒ³ã‹ã‚‰ã¯ã‚·ãƒ‰ãƒ‹ãƒ¼æ¹¾ã‚’ä¸€æœ›ã™ã‚‹ã“ã¨ãŒã§ãã€ã‚·ãƒ‰ãƒ‹ãƒ¼ ã‚ªãƒšãƒ© ãƒã‚¦ã‚¹ãŒã‚«ãƒ©ãƒ•ãƒ«ãªæµœã«æ‰“ã¡ä¸Šã’ã‚‰ã‚ŒãŸè²
yassan0627 2015/02/19
PowerShell

excel
ãƒªãƒ³ã‚¯
(powershell)Excelãƒžã‚¯ãƒã®å®šæ•°åˆ©ç”¨ã«ã¤ã„ã¦
è³ªå•ã‚’ã™ã‚‹ã“ã¨ã§ã—ã‹å¾—ã‚‰ã‚Œãªã„ã€å›žç”ã‚„ã‚¢ãƒ‰ãƒã‚¤ã‚¹ãŒã‚ã‚‹ã€‚15åˆ†èª¿ã¹ã¦ã‚‚ã‚ã‹ã‚‰ãªã„ã“ã¨ã¯ã€è³ªå•ã—ã‚ˆã†ï¼æ–°è¦ç™»éŒ²ã—ã¦è³ªå•ã—ã¦ã¿ã‚ˆã†
yassan0627 2015/02/19
PowerShell

excel
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸