关于输出Excel的一点小问题 style.Borders[Excel.XlBordersIndex.xlEdgeTop].Weight = 1;??? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 绘制区域边框这样是不是有点麻烦了亚 m_Excel = new Excel.Application(); m_Books = m_Excel.Workbooks; m_Book = m_Books.Add(System.Reflection.Missing.Value); m_Sheets = (Excel.Sheets)m_Book.Worksheets; m_Sheet = (Excel.Worksheet)m_Sheets.get_Item("sheet2"); int rowSum=10;//行colIndex=5;//列 mySheet.get_Range(mySheet.Cells[1, 1], mySheet.Cells[rowSum, colIndex]).Borders.LineStyle = 3; mySheet.get_Range(mySheet.Cells[1, 1], mySheet.Cells[rowSum, 1]).Borders[XlBordersIndex.xlEdgeLeft].Weight = XlBorderWeight.xlThin; mySheet.get_Range(mySheet.Cells[1, 1], mySheet.Cells[4, colIndex]).Borders[XlBordersIndex.xlEdgeTop].Weight = XlBorderWeight.xlThin; mySheet.get_Range(mySheet.Cells[rowSum, 1], mySheet.Cells[rowSum, colIndex]).Borders[XlBordersIndex.xlEdgeBottom].Weight = XlBorderWeight.xlThin; mySheet.get_Range(mySheet.Cells[1, colIndex], mySheet.Cells[rowSum, colIndex]).Borders[XlBordersIndex.xlEdgeRight].Weight = XlBorderWeight.xlThin; http://blog.csdn.net/lanwilliam/archive/2008/03/10/2163156.aspx试试这个类 讨论c# 调用doc命令问题 datagridview如何在最后加上统计 关于登录 FarPoint.Win.Spread加载excel模板如何设定行高、去掉表头的网格线 一个简单的问题,求教 StreamWriter写文件,Encoding必须ASCII,请教遇到中文该怎么办? 如何select的结果在文本框中显示出来? C#程序启动出错的问题,急!!! C#操作Excel的代码 关于限制网络访问的问题 请问一下大家腾讯QQ空间留言板的原理 登录窗口和主窗体设计的问题
m_Excel = new Excel.Application();
m_Books = m_Excel.Workbooks;
m_Book = m_Books.Add(System.Reflection.Missing.Value);
m_Sheets = (Excel.Sheets)m_Book.Worksheets;
m_Sheet = (Excel.Worksheet)m_Sheets.get_Item("sheet2");
int rowSum=10;//行
colIndex=5;//列
mySheet.get_Range(mySheet.Cells[1, 1], mySheet.Cells[rowSum, colIndex]).Borders.LineStyle = 3;
mySheet.get_Range(mySheet.Cells[1, 1], mySheet.Cells[rowSum, 1]).Borders[XlBordersIndex.xlEdgeLeft].Weight = XlBorderWeight.xlThin;
mySheet.get_Range(mySheet.Cells[1, 1], mySheet.Cells[4, colIndex]).Borders[XlBordersIndex.xlEdgeTop].Weight = XlBorderWeight.xlThin;
mySheet.get_Range(mySheet.Cells[rowSum, 1], mySheet.Cells[rowSum, colIndex]).Borders[XlBordersIndex.xlEdgeBottom].Weight = XlBorderWeight.xlThin;
mySheet.get_Range(mySheet.Cells[1, colIndex], mySheet.Cells[rowSum, colIndex]).Borders[XlBordersIndex.xlEdgeRight].Weight = XlBorderWeight.xlThin;
试试这个类