Question

aspose.cells怎么在已有excel文档写入内容

Answer 1

　　需要使用Style象并设置边框颜色宽度并通 Column.ApplyStyle() Style象应用整列 Workbook workbook = new Workbook("K://ColorAdd.xls"); Worksheet worksheet = workbook.Worksheets[0]; Style style = new Style(); style.Borders.SetColor(Color.Red); style.Borders.SetStyle(CellBorderType.Thin); style.Borders.DiagonalStyle = CellBorderType.None; StyleFlag sf = new StyleFlag(); sf.All = true; worksheet.Cells.Columns[0].ApplyStyle(style, sf); workbook.Save("K://ComplexOutput.xls");