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.
Hello gussman,
I tried this and it always works fine for me so I attached my sample to this post for you. Please review it and feel free to let me know if I misunderstood you or if you have any other questions.