C产品在市场上有哪些独特优势？

本文共计220个文字，预计阅读时间需要1分钟。

设置列宽为15，自动调整行高和列宽，然后添加边框：vbaworksheet.Columns(1).ColumnWidth=15xlApp.Columns.AutoFitxlApp.Rows.AutoFitsheet.Range(A1:F & (c + 2)).Borders.LineStyle=1

设置固定值 worksheet.Columns[1].ColumnWidth = 15;

设置自动行高、列宽

xlApp.Columns.AutoFit();
xlApp.Rows.AutoFit();

其它

•sheet.Range["A1", "F" + (c + 2)].Borders.LineStyle = 1; // 边框粗细

•sheet.Range["A1", "F" + (c + 2)].HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter; // 对齐方式

•sheet.Range["A1", "F1"].MergeCells = true; // 合并单元格

•sheet.Range["A1", "F2"].Font.Bold = true; // 加粗

•sheet.Range["A1", "F1"].Font.Size = 13; // 字号

•sheet.Range["A1", "F" + (c + 2)].Font.Size = 11;

•sheet.Range["A1", "F" + (c + 2)].RowHeight = 21; // 行高

•sheet.Range["A1"].RowHeight = 35;

•sheet.Range["A1", "F1"].ColumnWidth = 17; // 列宽

•sheet.Range["B1"].ColumnWidth = 20;

•sheet.Range["A2", "F2"].Interior.Color = System.Drawing.ColorTranslator.ToOle(Color.FromArgb(197, 217, 241)); // 单元格背景颜色