Hello,

I recently upgraded from NetAdvantage for .NET 2008 Vol. 1 CLR 2.0  to NetAdvantage for .NET 2008 Vol. 2 CLR 2.0.  I am using Visual Studio 2005 with VB.

Before I upgraded, I was able to have a couple of merged regions along the top of my worksheets in Excel as report headers and then start the actual datagrid in the next row down.  Since I upgraded, the same code does merge the cells but puts the column headers for the grid in these merged cells so that the actual grid has no column headers.  If I remark out the merged cell regions, the grid comes across fine.  Is there any way to tell it which row to start the datagrid in?  Has there been a change in syntax between the versions that I need to know?  I am not getting any errors, it just doesn't look right when it exports.

 My code is below:

Dim ds11 As DataSet

Dim sheet1 As Worksheet

Dim sheet3 As Worksheet

Dim rgn As WorksheetMergedCellsRegion

'EE1 is the name of the Infragistics UltraGrid Excel Exporter.

'DG9 is the name of the datagrid 

Me.EE1.DownloadName = "SalesByPart_Quantity.xls"

rgn.Value = "Program Name"

rgn.CellFormat.Font.Name = "Verdana"

rgn.Value = "Date Report Generated -- " & FormatDateTime(Now(), DateFormat.ShortDate) & " " & "Year:" & " " & Me.cboOrderYear.SelectedItem.Value & " " & "Territory -- " & Me.cboTerritory.SelectedItem.Value

rgn.CellFormat.Font.Name = "Verdana"

rgn.Value = "Sales By Part - Quantity"

rgn.CellFormat.Font.Name = "Verdana"

wb.WindowOptions.SelectedWorksheet.Columns(6).CellFormat.FormatString = "###,###,##0"

wb.WindowOptions.SelectedWorksheet.Columns(7).CellFormat.FormatString = "###,###,##0"

wb.WindowOptions.SelectedWorksheet.Columns(8).CellFormat.FormatString = "###,###,##0"

wb.WindowOptions.SelectedWorksheet.Columns(9).CellFormat.FormatString = "###,###,##0"

wb.WindowOptions.SelectedWorksheet.Columns(10).CellFormat.FormatString = "###,###,##0"

wb.WindowOptions.SelectedWorksheet.Columns(11).CellFormat.FormatString = "###,###,##0"

wb.WindowOptions.SelectedWorksheet.Columns(12).CellFormat.FormatString = "###,###,##0"

wb.WindowOptions.SelectedWorksheet.Columns(13).CellFormat.FormatString = "###,###,##0"

wb.WindowOptions.SelectedWorksheet.Columns(14).CellFormat.FormatString = "###,###,##0"

wb.WindowOptions.SelectedWorksheet.Columns(15).CellFormat.FormatString = "###,###,##0"

wb.WindowOptions.SelectedWorksheet.Columns(16).CellFormat.FormatString = "###,###,##0"

wb.WindowOptions.SelectedWorksheet.Columns(17).CellFormat.FormatString = "###,###,##0"

wb.WindowOptions.SelectedWorksheet.Columns(18).CellFormat.FormatString = "###,###,##0"

If Me.cboTerritory.SelectedItem.Value <> "All" Then

Else

'Write the in memory object to our Custom Stream

'BIFF8Writer.WriteWorkbookToStream(wb, objStream)

'wb.Save(wb, System.IO.StreamWriter)

'Create a Byte Array to contain the stream

objStream.Position = 0 'Set Stream Starting point

objStream.Read(byteArr, 0, CType(objStream.Length, Integer)) 'Read Stream into Byte Array

objStream.Close() 'Close the stream

Response.Clear() 'Clear the response object

Response.AddHeader("content-disposition", "attachment; filename=SalesByPartQuantity.xls") 'Set the Content Header

Response.BinaryWrite(byteArr) 'Write the byte array to the output stream

Response.End() 'End the response

Any help would be greatly appreciated.

Thanks,

K