Open xml speadsheet border & bold problems

Question

I have been trying to work with Open XML in making a speadsheet.  I have attached the code that puts the data in the spreadsheet.  I let the productivity tool create the header and put it in a class.  I execute the class then open the speadsheet and then edit it..

I need a border around the data cells.  I get them for the strings, but everything is bold.  I need to do this without everything being bold.  The Charges field, the 11 column needs to handled differently with a deciamal in it.  I do not get the border around these cells.

Can anyone help or suggest somewhere to go?

I hope this is understandable.


Thanks,
arep

Answer 1

Please refer the link for more detailed explantion:http://developers.itextpdf.com/content/best-itext-questions-stackoverview/font-examples/itext7-how-use-system-font-itextsharp-vbnet

Answer 2

Dear Gokhul Sir, I have made this. Thank you. But I have another question. I have six buttons bearing same color. I want tab index position of button will show another color. Is it possible? Please help me.