Excel报表格式设置

   设置表格边框： ws.get_Range(ws.Cells[1, 1], ws.Cells[38, 4]).Borders.LineStyle = 1;

   设置单元格样式为文本型：  ws.get_Range(ws.Cells[1, 1], ws.Cells[38, 4]).NumberFormatLocal = "@";

   行格式设置：ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 4]).Font.Name = "宋体";  //设置字体
                     ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 4]).Font.Bold = true;    
                     ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 4]).Font.Size = 15;
                     ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 4]).ColumnWidth = 18;
                     ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 4]).RowHeight = 30;
                     ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 4]).HorizontalAlignment = Excel.Constants.xlCenter;
                     ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 2]).Merge(Type.Missing);  //合并单元格

 

    表格内容填充： //电能表信息
                if (ds1.Tables[0].Rows.Count == 0)
                {

                }
                else
                {

                    ws.Cells[10, 2] = ds1.Tables[0].Rows[0][0].ToString();
                    ws.Cells[10, 4] = ds1.Tables[0].Rows[0][1].ToString();
                    ws.Cells[11, 2] = ds1.Tables[0].Rows[0][2].ToString();
                    ws.Cells[11, 4] = ds1.Tables[0].Rows[0][3].ToString();
                }