Extract Oracle data to Excel without header

[steveKC]

Hi,

Anyone know how to extarct data from Oracle to excel without the header using vb.net?

Below is my coding:

Dim rst As ADODB.Recordset

cn = New ADODB.Connection

With cn
.ConnectionString = "Provider=MSDAORA.1; " & conn.getCsatConnection()
.CursorLocation = CursorLocationEnum.adUseClient
.Open()
End With

Dim a As String

a="Select * from Backlog"

rst = cn.Execute(a)
Dim oXL As _Application
Dim oWB As _Workbook
Dim oSheet As _Worksheet()
Dim obj As Object
Dim filename As String

ReDim oSheet(3)


oSheet(0) = oWB.Worksheets(1)
oSheet(0).Name = "Backlog Data"
obj = oSheet(0).QueryTables.Add(rst, oSheet(0).Range("A1"))
obj.BackgroundQuery = False
obj.Recordset = rst
obj.Refresh()

oXL.DisplayAlerts = False
filename = "C:\Backlog.xls"
oWB.SaveAs(filename)

The coding is workign fine, just that I want to exlude the header when extact to excel file.


Thanks in advance

Regards,
Steve

[kenobewan]

One way is to remove unwanted columns (header text listed in removeColumnList arraylist) before you write to the xml. Here is a portion of c# code used for that purpose:

            foreach (DataControlField field in grdView.Columns)
            {              
                if (excludedColumnList.Contains(field.HeaderText))
                {
                    field.Visible = false;
                }
            }