range.Interior.ColorIndex = 15;
range.Font.Bold = true;
range.BorderAround(Excel.XlLineStyle.xlContinuous,Excel.XlBorderWeight.xlThin,Excel.XlColorIndex.xlColorIndexAutomatic,null);
range.Borders[Excel.XlBordersIndex.xlInsideHorizontal].ColorIndex = Excel.XlColorIndex.xlColorIndexAutomatic;
range.Borders[Excel.XlBordersIndex.xlInsideHorizontal].LineStyle =Excel.XlLineStyle.xlContinuous;
range.Borders[Excel.XlBordersIndex.xlInsideHorizontal].Weight =Excel.XlBorderWeight.xlThin;
range.Borders.Weight = "xlThin";
range.Borders.LineStyle = 1;
newBook.Worksheets(1).Range("A1:B1000").NumberFormat = "0"
newBook.Worksheets(1).Range("A1:B1000").HorizontalAlignment = 1 '左对齐
newBook.Worksheets(1).Range("A1:D1").merge()
newBook.Worksheets(1).Range("A1:D1").value="test" '合并单元格
newBook.Worksheets(1).Range("A1:D1").HorizontalAlignment=3 '居中对齐
newBook.Worksheets(1).Columns("A").columnwidth=50 '设置列宽
newBook.Worksheets(1).Rows(2).RowHeight = 40 '设置行高
newBook.Worksheets(1).Columns("A").WrapText = True
newBook.Worksheets(1).Columns("B").columnwidth=50
newBook.Worksheets(1).Columns("B").WrapText = true
newBook.Worksheets(1).Cells(2,1).Interior.ColorIndex="15" '设置字的颜色
newBook.Worksheets(1).Cells(2,1).Borders.LineStyle=1 '设置边框 1为实线,2为虚线
newBook.Worksheets(1).Cells(3,2).Font.Name = "Verdana"
newBook.Worksheets(1).Cells(3,2).Font.Italic = true
newBook.Worksheets(1).Cells(3,2).HorizontalAlignment = 4 '右对齐
newBook.Worksheets(1).Cells(3,2).Font.Color = RGB(0,0,0)
range.Font.Bold = true;
range.BorderAround(Excel.XlLineStyle.xlContinuous,Excel.XlBorderWeight.xlThin,Excel.XlColorIndex.xlColorIndexAutomatic,null);
range.Borders[Excel.XlBordersIndex.xlInsideHorizontal].ColorIndex = Excel.XlColorIndex.xlColorIndexAutomatic;
range.Borders[Excel.XlBordersIndex.xlInsideHorizontal].LineStyle =Excel.XlLineStyle.xlContinuous;
range.Borders[Excel.XlBordersIndex.xlInsideHorizontal].Weight =Excel.XlBorderWeight.xlThin;
range.Borders.Weight = "xlThin";
range.Borders.LineStyle = 1;
newBook.Worksheets(1).Range("A1:B1000").NumberFormat = "0"
newBook.Worksheets(1).Range("A1:B1000").HorizontalAlignment = 1 '左对齐
newBook.Worksheets(1).Range("A1:D1").merge()
newBook.Worksheets(1).Range("A1:D1").value="test" '合并单元格
newBook.Worksheets(1).Range("A1:D1").HorizontalAlignment=3 '居中对齐
newBook.Worksheets(1).Columns("A").columnwidth=50 '设置列宽
newBook.Worksheets(1).Rows(2).RowHeight = 40 '设置行高
newBook.Worksheets(1).Columns("A").WrapText = True
newBook.Worksheets(1).Columns("B").columnwidth=50
newBook.Worksheets(1).Columns("B").WrapText = true
newBook.Worksheets(1).Cells(2,1).Interior.ColorIndex="15" '设置字的颜色
newBook.Worksheets(1).Cells(2,1).Borders.LineStyle=1 '设置边框 1为实线,2为虚线
newBook.Worksheets(1).Cells(3,2).Font.Name = "Verdana"
newBook.Worksheets(1).Cells(3,2).Font.Italic = true
newBook.Worksheets(1).Cells(3,2).HorizontalAlignment = 4 '右对齐
newBook.Worksheets(1).Cells(3,2).Font.Color = RGB(0,0,0)