title: How to define the borders for an entire column with spreadsheetgear?
body: <p>I know how to define the style of the border for a Cell, like that for example:</p>
  
  <pre><code>Dim border As SpreadsheetGear.IBorder
  
  border = sheet.Cells(1, column).Borders(SpreadsheetGear.BordersIndex.EdgeRight)
  
  border.Color = System.Drawing.Color.Black
  border.LineStyle = SpreadsheetGear.LineStyle.Continuous
  border.Weight = SpreadsheetGear.BorderWeight.Medium
  </code></pre>
  
  <p>This is working.</p>
  
  <p>What I want to do now is to define the style of the border <strong><em>for an entire column</em></strong>. Exactly like what I would obtain if in Excel I <strong><em>select the column by clicking on the header and define the border attributes</em></strong>.</p>
  
  <p>I've tried to do it on this range:</p>
  
  <pre><code>border = sheet.Cells(1, column).Columns.Borders(SpreadsheetGear.BordersIndex.EdgeRight)
  </code></pre>
  
  <p>The code doen't crash, but it doesn't add a border.</p>
  
  <p>Anybody can help ?</p>