These are some helpful methods that may help you
private void setCellValue(ref Excel._Worksheet objSheet, int rowIndex,
int columnIndex,string cellValue)
{
Excel.Range objCells = objSheet.Cells;
Excel.Range objCell = (Excel.Range)objCells[rowIndex,columnIndex];
objCell.Value2 = cellValue;
releaseComObj(objCell);
releaseComObj(objCells);
}
private void setCellFontSize(ref Excel._Worksheet objSheet, int
rowIndex, int columnIndex,int fontSize)
{
Excel.Range objCells = objSheet.Cells;
Excel.Range objCell = (Excel.Range)objCells[rowIndex,columnIndex];
Excel.Font objFont = objCell.Font;
objFont.Size = fontSize;
releaseComObj(objFont);
releaseComObj(objCell);
releaseComObj(objCells);
}
private void setCellFontBold(ref Excel._Worksheet objSheet, int
rowIndex, int columnIndex,bool boldFont)
{
Excel.Range objCells = objSheet.Cells;
Excel.Range objCell = (Excel.Range)objCells[rowIndex,columnIndex];
Excel.Font objFont = objCell.Font;
objFont.Bold = true;
releaseComObj(objFont);
releaseComObj(objCell);
releaseComObj(objCells);
}
private void releaseComObj(object o)
{
try
{
System.Runtime.InteropServices.Marshal.ReleaseComO bject(o);
}
catch {}
finally
{
o = null;
}
}
*** Sent via Developersdex
http://www.developersdex.com ***