Exporting query result to the excel sheet using powershell

Question

I wrote a function Get-oracleresultDa which have oracle connection properties.Through which I can query my DB.

But,the problem is which I try to export the data to the excel sheet it only returns the result of the second query i.e)no status and not no type

$results = Get-OracleResultDa -conString $connectionString -sqlString $query 
-Verbose
$results | SELECT no, type| Export-CSV "H:\Book2.csv" -Force
$rows++
$results1 = Get-OracleResultDa -conString $connectionString -sqlString 
$created -Verbose
$results1 | SELECT no, status| Export-CSV "H:\Book2.csv" -
NoTypeInformation

The below mentioned block was in the first 10 linesof the script

$file="H:\Book2.csv"
$excel = New-Object -ComObject excel.application
#Makes Excel Visable
$excel.Application.Visible = $true
$excel.DisplayAlerts = $false
#Creates Excel workBook
$book = $excel.Workbooks.Add()
#Adds worksheets

#gets the work sheet and Names it
$sheet = $book.Worksheets.Item(1)
$sheet.name = 'Created'
#Select a worksheet
$sheet.Activate() | Out-Null

I have few more query's which also as to be exported

Mihail Kuznesov · Accepted Answer · 2017-05-28 19:06:14Z

1

If you use powershell 3.0 or better, you can use -Append modificator

$results = Get-OracleResultDa -conString $connectionString -sqlString $query 
-Verbose
$results | SELECT no, type| Export-CSV "H:\Book2.csv" -Force
$rows++



$results1 = Get-OracleResultDa -conString $connectionString -sqlString 
$created -Verbose
$results1 | SELECT no, status| Export-CSV "H:\Book2.csv" -
NoTypeInformation -Append

answered May 28, 2017 at 19:06

Mihail Kuznesov

5752 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Exporting query result to the excel sheet using powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related