我用C#语言.把数据库导出Excel文件时..
如果在导出Excel文件时.合并单元格
我的代码
Microsoft.Office.Interop.Excel.Application Excel = new Microsoft.Office.Interop.Excel.Application();
Workbooks Excel_WorkBooks = Excel.Workbooks;
Workbook Excel_WorkBook = Excel_WorkBooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Worksheet Excel_Sheet = (Worksheet)Excel_WorkBook.Worksheets[1];
for (int i = 0; i <10; i++)
{
Excel_Sheet.Cells[1, i + 1] = "列"+i;
}
假如我想把第一行的第一列和第二列合为一个单元格,代码该怎么写
如果在导出Excel文件时.合并单元格
我的代码
Microsoft.Office.Interop.Excel.Application Excel = new Microsoft.Office.Interop.Excel.Application();
Workbooks Excel_WorkBooks = Excel.Workbooks;
Workbook Excel_WorkBook = Excel_WorkBooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Worksheet Excel_Sheet = (Worksheet)Excel_WorkBook.Worksheets[1];
for (int i = 0; i <10; i++)
{
Excel_Sheet.Cells[1, i + 1] = "列"+i;
}
假如我想把第一行的第一列和第二列合为一个单元格,代码该怎么写
exc.Application.Workbooks.Add(true);
Excel._Worksheet ws=new Excel.WorksheetClass();
ws=(Excel._Worksheet)exc.ActiveSheet; //取得当前worksheet
Excel.Range r;
r=ws.get_Range(ws.Cells[1,1],ws.Cells[1,6]); //取得合并的区域
r.MergeCells=true;
Excel.Range r;
r=ws.get_Range(ws.Cells[1,1],ws.Cells[1,2]); //取得合并的区域
r.MergeCells=true;