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
215
Export grid style to specified worksheet.
posted

Hi.

 

If I export ultragrid to specified file it's no problem,

but I try to export to specified worksheet I have got a problem.

The other cell which outside of grid area is filled header color.

I want to export grid style to specified worksheet.

 

Looking forward to your advice.

Thanks.

 

Source code is here.

And I use ExcelExport version 10.1.20101.2105

 

UltraGridExcelExporter ultraGridExcelExporter = new UltraGridExcelExporter();

string excelFilePath1 = Application.StartupPath + "\\Export\\excel1.xlsx";

string excelFilePath2 = Application.StartupPath + "\\Export\\excel2.xlsx";

 

//something wrong

Infragistics.Excel.Workbook wb = Infragistics.Excel.Workbook.Load(excelFilePath1);

ultraGridExcelExporter.Export(ultraGrid1, wb.Worksheets[0], 1, 0);

wb.Save(excelFilePath1);

 

//it's perfect

ultraGridExcelExporter.Export(ultraGrid1, excelFilePath2);

 

 

Export to specified worksheet.

Export to specified file.