PowerShell
DataPeak
不会做饭的程序员不是好的摄影师
展开
-
PowerShell连接查询Oracle数据库
PowerShell连接查询Oracle数据库$USER = 'USER'$PASSWD = 'PASSWD'$SERVER = 'SERVER'$DB = 'DB'# create connection objectAdd-Type -AssemblyName 'System.Data.OracleClient'$CONNECTION_STR = "User Id=$USE...原创 2018-06-11 14:37:35 · 3818 阅读 · 2 评论 -
PowerShell访问Oracle、SQL Server数据库,导出到CSV文件
PowerShell访问Oracle、SQL Server数据库,导出到CSV文件# query oracle# connect info# sql# parameters# scalar result# return an array of ordered HashTable or a scalar valuefunction Oracle-Query { param...原创 2018-06-21 12:14:16 · 2658 阅读 · 1 评论 -
PowerShell读取JSON配置文件
使用Get-Content和ConvertFrom-Json读取JSON配置文件,以下是示例代码:// settings.json{ "RUN_DATE": null, "xl": { "xlWBATWorksheet": -4167, "xlUp": -4162, "xlCellTypeVisible": 12, "xlPasteValuesAndN.原创 2018-06-07 16:27:59 · 8378 阅读 · 1 评论 -
PowerShell play with Outlook & Excel
PowerShell play with Outlook & ExcelSearch, download attachments in Outlook$outlook = New-Object -ComObject Outlook.Application$namespace = $Outlook.GetNameSpace("MAPI")$folders = $namespa...原创 2018-07-18 14:16:11 · 731 阅读 · 1 评论 -
PowerShell Module
PowerShell ModuleDefine PowerShell module:# comm_func.psm1$ORA_CONNECTION = $nullFunction FileExist { param ([String] $path) If($path -eq $null) { Return $False } Else { ...原创 2018-07-06 09:00:12 · 1286 阅读 · 1 评论