Question about Styles in Workbooks

[Kalaora luc]

I transfert data in a Excel File.

I want that the border of the cell in Excel have only left and right
border.

if i do :
range.Columns.Borders.LineStyle=Excel.XlLineStyle.xlContinuous;

My cell have up, down, left ,right borders. How can have only left and
rigth border ?

Thanks for your answer

 

[Scott Glasgow]

You need to specify which border you're setting. Currently you're setting it
for all borders.
Change:
range.Columns.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
To:
range.Columns.Borders[Excel.XlBordersIndex.xlEdgeRight].LineStyle =
Excel.XlLineStyle.Continous;
range.Columns.Borders[Excel.XlBordersIndex.xlEdgeLeft].LineStyle =
Excel.XlLineStyle.Continous;

 

[Kalaora luc]

if i do
range.Columns.Borders[Excel.XlBordersIndex.xlEdgeRight].LineStyle =
Excel.XlLineStyle.Continous;
range.Columns.Borders[Excel.XlBordersIndex.xlEdgeLeft].LineStyle =
Excel.XlLineStyle.Continous;

there is no border in my Excel sheet. Have you test it?
Luc

 

[Scott Glasgow]

Yes, it's tested. Straight from an application we're working on that creates
and formats thousands of reports. Are you also setting the following?

range.Columns.Borders[Excel.XlBordersIndex.xlEdgeRight].Weight
and ColorIndex ?