Format cell in an excel sheet using c#

Question

0.00/5 (No votes)

See more:

I need to add borders to excel cells in Automatic colour using xlWorkSheet.Cells.BorderAround() method. Given below is the coding that i use. But it doesn't add any borders to the cell. Can you please let me know what i have done wrong here:

Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlApp.Visible = false;
xlWorkBook = xlApp.Workbooks.Open(textBox1.Text, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

int i = 0;
int j = 0;

for (i = 0; i <= dataGridView1.RowCount - 1; i++)
{
for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)
{
DataGridViewCell cell = dataGridView1[j, i];
xlWorkSheet.Cells["19", "I"] = "Availablility";
xlWorkSheet.Cells[i + 20, j + 9] = cell.Value;
xlWorkSheet.Cells.BorderAround(Excel.XlLineStyle.xlContinuous, Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic, System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.FromArgb(79, 129, 189)));
}
}

Posted 18-Oct-12 22:04pm

hansikaat

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

VIPR@T · Answer 1 · 2012-10-18T22:13:00

Solution 1

Hi,

See the below links. It might be help you.

http://csharp.net-informations.com/excel/csharp-format-excel.htm[^]

http://p2p.wrox.com/c/40262-excel-cell-formating-using-c.html[^]

http://msdn.microsoft.com/en-us/library/bb404903.aspx[^]

Thanks,
Viprat

Posted 18-Oct-12 22:13pm

VIPR@T

Comments

hansikaat 19-Oct-12 6:25am

Thanks. I referred the links and updated my coding as shown below. But it doesn't add borders to the excel sheet
xlWorkSheet.Cells.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, Excel.XlColorIndex.xlColorIndexAutomatic);

hansikaat · Answer 2 · 2012-10-23T20:53:00

Solution:

C#

for (i = 0; i <= dataGridView1.RowCount - 4; i++)
               {
                   for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)
                   {
                       DataGridViewCell cell = dataGridView1[j, i];
                       xlWorkSheet.Cells["19", "I"] = "Availablility";
                       xlWorkSheet.Cells[i + 20, j + 9] = cell.Value;
                       xlRange = xlWorkSheet.get_Range("I19", xlWorkSheet.Cells[i + 20, j + 9]);
                       xlRange.Cells.Borders.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Black);
                   }
               }

Format cell in an excel sheet using c#

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Format cell in an excel sheet using c#

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us