I found an example online from one of your articles here.http://help.infragistics.com/Help/NetAdvantage/NET/2008.2/CLR2.0/html/Infragistics2.Excel.v8.2~Infragistics.Excel.Workbook~CreateNewWorksheetCellFormat.html
I tried the same method to set the font from Segoe UI to Verdana, but it is not working. Does anyone know if this is a known issue or if I am missing something?
UltraGridExcelExporter exporter = new UltraGridExcelExporter();Workbook workbook = new Workbook();Worksheet worksheet;
IWorksheetCellFormat styleFormat = workbook.CreateNewWorksheetCellFormat();styleFormat.Font.Name = "Verdana";workbook.Styles.AddUserDefinedStyle(styleFormat, "Custom Cell Style");
foreach (UltraGrid grid in grids){ worksheet = workbook.Worksheets.Add(grid.Tag.ToString()); exporter.Export(grid, worksheet);}
I am adding the style here, workbook.Styles.AddUserDefinedStyle(styleFormat, "Custom Cell Style");.
Agan, I am following the link in my post which is an Infragistics example. If you see what I am doing wrong, by all means tell me.
What exactly are you trying to do here? You are creating a style and adding it to the workbook, but you are not actually using that style anywhere. At least, not in the code you have posted here.