Hi,

I am using Infragistic excel(v6.2) for .Net3.5(VS2008) .I use to generate workbook(sheets) using

Infragistic excel with some color format.For generating sheets, I use

1.

Friend

WithEvents ExpToExcel As Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter

Friend WithEvents grdExcelReport As Infragistics.Win.UltraWinGrid.UltraGrid

2.

ExpToExcel.DefaultWorkbookPaletteMode = WorkbookPaletteMode.StandardPalette

ExpToExcel.Export(grdExcelReport, ws5, 0, 0)

and finally

3.

BIFF8Writer.WriteWorkbookToFile(wb, filePath)

It generates correctly but when I move the generated sheets to some other  excel sheet(A) manually,

its format(color) gets changed I mean it becomes black color around the text available in the

sheet(A).Here problem is ,I want to keep the same format as it is in generated sheet.

Please help me,

Thanks

Rajesh,India