How can I create a "global" style?

[scott.dubose@virtusllc.com]

I want to add a style to the workbook and then set it to a cell's style property. The style depends on a number of parameters at runtime so we need to set it like this.

Do you have any sample code for this?

thanks
scott

[scott.dubose@virtusllc.com]

I tried something like this

Code: Select all

StylesCollection sc = wb.Styles;

CellStyle cs;
cs = sc.Add("WorksheetTitle");
cs.WrapText = true;
cs.VerticalAlignment = VerticalAlignType.Top;
cs.HorizontalAlignment = HorizontalAlignType.Left;
cs.Font.FontName = "Trebuchet MS";
cs.Font.Size = 18;
cs.Font.IsItalic = true;
cs.Font.IsBold = true;

....

worksheet.Range[1, 1].Style = styles["WorksheetTitle"];

GIVES EXCEPTION
Style name cannot be found. Name: WorksheetTitle
Parameter name: value
   at Spire.Xls.Core.Spreadsheet.Collections.XlsStylesCollection.get_Item(String
 name)
   at Spire.Xls.Collections.StylesCollection.get_Item(String name)
   at CashFlowXmlBuilder.WorkbookBuilderSpire.addWorkSheet(DataTable table, Work
  ...


[amy.zhao]

Dear scott,

Thanks for your inquiry.
I checked your code. There is something wrong with the code worksheet.Range[1, 1].Style = styles["WorksheetTitle"];. It should be worksheet.Range[1, 1].Style = sc["WorksheetTitle"];. Please try the modification and run your code again.

Welcome to wirte to us again in case you have further problems.

Best regards,
Amy
E-iceblue support team

[scott.dubose@virtusllc.com]

thank you. it appears the styles was copied to function call parameter via value rather than reference so I was losing all of my additions.

[amy.zhao]

Dear scott,

Thanks for your reply.
Has this issue been solved? Did we miss something for your issue?

Best regards,
Amy
E-iceblue support team