Applying Styles to the Worksheet

[rrdonnelleypa]

I have a query related to styling in Apose.Cells. Am using two methods, on one method creating one style ( HeaderStyle ) , and on another method am accessing the style . Style is not getting applied to my Worksheet.

Below is the code snippet i have used .

// Creating Style :

Style HeaderStyle = myWorkBook.Styles[myWorkBook.Styles.Add()];

HeaderStyle.Font.IsBold = true;

HeaderStyle.Font.Name = "Calibri";

HeaderStyle.Font.Size = 11;

HeaderStyle.IsTextWrapped = false;

//Applying Style

myWorksheet.Cells["A1"].SetStyle(workbook.Styles["HeaderStyle"]);

Please suggest on this .

Regards,

Nagalakshmi V

[Amjad_Sahi]

Hi,

Please try the following sample code, it works fine:

e.g

Sample code:

Workbook myWorkBook = new Workbook();

Worksheet myWorksheet = myWorkBook.Worksheets[0];

// Creating Style :

Style HeaderStyle = myWorkBook.Styles[myWorkBook.Styles.Add()];

HeaderStyle.Font.IsBold = true;

HeaderStyle.Font.Name = “Calibri”;

HeaderStyle.Font.Size = 11;

HeaderStyle.IsTextWrapped = false;

//Applying Style

myWorksheet.Cells[“A1”].SetStyle(HeaderStyle);

myWorkBook.Save(“e:\test2\out1applyingstyles1.xlsx”);

Let us know if you still have any issue.

Thank you.

[rrdonnelleypa]

Hi ,

Thanks for your response .

The piece of code which you have given will work , when am creating the style and accessing the style on same method and i used this on one of my requirement.

My case i have one generic(common) method for creating styles and i want to access the styles on 4 different methods.

How can we access the styles on another method ?

Regards

Nagalakshmi V

[babar.raza]

Hi Nagalakshmi,

Thank you for writing back.

If you wish to keep on using your logic of creating the Style objects and accessing them by their names then you need to assign a name to the Style object. Please check the following modified code.

C#

var myWorkBook = new Workbook();
var myWorksheet = myWorkBook.Worksheets[0];
// Creating Style :
Style HeaderStyle = myWorkBook.Styles[myWorkBook.Styles.Add()];
HeaderStyle.Name = “HeaderStyle”;
HeaderStyle.Font.IsBold = true;
HeaderStyle.Font.Name = “Calibri”;
HeaderStyle.Font.Size = 11;
HeaderStyle.IsTextWrapped = false;

//Applying Style
myWorksheet.Cells[“A1”].SetStyle(myWorkBook.Styles[“HeaderStyle”]);
myWorkBook.Save(“D:/output.xlsx”);