Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
185
Infragistic excel format problem
posted

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 

 

 

 

 

 

 

 

Sample Files.zip