Hello,
I'm trying to access pre-defined styles we've created in an existing Excel 2007 workbook. (Like BFS_Text_Locked, BFS_Currency_Edit).
I've created these styles and would like to set them to newly created cells.
I've tried the Workbook.Styles collection, but only the basic format styles (plus 'Normal') are there.
I've also opened the workbook using:
wb.Open(this._workbookFile, FileFormatType.Excel2007Xlsx);
I would like to do something like:
this.Sheet.Cells[0,0].Style = this.Sheet.Workbook.Styles["BFS_Text_Locked"];
Is this possible? or is there another way to do this?
(I'm using version 4.8.2.0).
Thanks
-frank