private Excel.Application excel=null;private Excel.Worksheet m_Worksheet = null;public void SetCellBackColor(string cellIndex, Color c)
{
if (m_Worksheet != null){
object cell1 = cellIndex;
Excel.Range range = m_Worksheet.get_Range(cell1, missing);
if (range != null){
range.Cells.Interior.Color = c;
}
}
}
public void SetFont(string cell1, string cell2, float size)
{
m_Worksheet.get_Range(cell1, cell2).Font.Size = size;
m_Worksheet.get_Range(cell1, cell2).Font.Bold = true;
m_Worksheet.get_Range(cell1, cell2).VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
m_Worksheet.get_Range(cell1, cell2).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
}
{
if (m_Worksheet != null){
object cell1 = cellIndex;
Excel.Range range = m_Worksheet.get_Range(cell1, missing);
if (range != null){
range.Cells.Interior.Color = c;
}
}
}
public void SetFont(string cell1, string cell2, float size)
{
m_Worksheet.get_Range(cell1, cell2).Font.Size = size;
m_Worksheet.get_Range(cell1, cell2).Font.Bold = true;
m_Worksheet.get_Range(cell1, cell2).VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
m_Worksheet.get_Range(cell1, cell2).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货