Browse by Tags

Hi, Below is the function which reading my XLLX and write the data in it. It also protect it with password. Now here I want to lock perticular cell of this sheet. Please suggest me options for that. What I have tried: 1. CellFormat.ApplyProtection 2. Tried to remove "Locked" property of locked...

Hi, I'm a new bee to open XML . One of my projects include creating a spreadsheet from the database and apply formats, calculations etc to the spreadsheet. I successfully created one but applying formulas (subtotals and totals) is the part I need help with. How can I let Excel know (through sheet...

Most of InsertCellInWorksheet is a capture from the Productivity Tool so in the same vein I created a workbook with only one cell with bolded text and got this. Font font1 = new Font(); Bold bold1 = new Bold(); FontSize fontSize1 = new FontSize(){ Val = 11D }; Color color1 = new Color(){ Theme = (UInt32Value...

p>Hi, After several hours of testing I am stumped. Basically I have a NumberFormat <numFmt numFmtId="44" formatCode="_-&quot;$&quot;* #,##0.00_-;\-&quot;$&quot;* #,##0.00_-;_-&quot;$&quot;* &quot;-&quot;??_-;_-@_-"/> Which returns as "_...

I have the following code which successfully opens up an excel file and inserts a cell value. I am having a hard time though tweakingthe code so that it can make that cell bold. Any help would be appreciated. I have attempted to make the font bold as you can see below but have not been successful. using...