worksheet.Cells[1, 1].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
worksheet.Cells[1, 1].Style.VerticalAlignment = ExcelVerticalAlignment.Center;
worksheet.Cells[1, 4, 1, 5].Merge =
true
;
worksheet.Cells.Style.WrapText =
true
;
worksheet.Cells[1, 1].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.FromArgb(191, 191, 191));
worksheet.Cells[1, 1].Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
worksheet.Cells[1, 1].Style.Border.Bottom.Color.SetColor(Color.FromArgb(191, 191, 191));
worksheet.View.ShowGridLines =
false
;
worksheet.Cells.Style.Fill.PatternType = ExcelFillStyle.Solid;
worksheet.Cells.Style.Fill.BackgroundColor.SetColor(Color.LightGray);
worksheet.BackgroundImage.Image = Image.FromFile(
@"firstbg.jpg"
);
ExcelPicture picture = worksheet.Drawings.AddPicture(
"logo"
, Image.FromFile(
@"firstbg.jpg"
));
picture.SetPosition(100, 100);
picture.SetSize(100, 100);
worksheet.Cells[1, 1].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
worksheet.Cells[1, 1].Style.VerticalAlignment = ExcelVerticalAlignment.Center;
worksheet.Cells[1, 4, 1, 5].Merge =
true
;
worksheet.Cells.Style.WrapText =
true
;
worksheet.Cells[1, 1].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.FromArgb(191, 191, 191));
worksheet.Cells[1, 1].Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
worksheet.Cells[1, 1].Style.Border.Bottom.Color.SetColor(Color.FromArgb(191, 191, 191));
worksheet.View.ShowGridLines =
false
;
worksheet.Cells.Style.Fill.PatternType = ExcelFillStyle.Solid;
worksheet.Cells.Style.Fill.BackgroundColor.SetColor(Color.LightGray);
worksheet.BackgroundImage.Image = Image.FromFile(
@"firstbg.jpg"
);
ExcelPicture picture = worksheet.Drawings.AddPicture(
"logo"
, Image.FromFile(
@"firstbg.jpg"
));
picture.SetPosition(100, 100);
picture.SetSize(100, 100);
Python绘制相关性矩阵 python 相关矩阵
一、生成单位阵 numpy.identity(N) 和 numpy.eye(N) 都可以用来产生单位阵,且产生的单位阵都是 np.array() 类型,矩阵元素都是 float 型。import numpy as np
a = np.eye(4)
b = np.identity(4)
print(ty