Question

如何用Aspose.BarCode创建Datamatrix

Answer 1

首先我们创建一个工作表 Workbook workbook = new Workbook(); 然后我们去生成第一张数据表格。 //Write data to first data sheet，将数据写到第一个sheet中 Worksheet sheet1 = workbook.Worksheets[0]; //给sheet起一个名字 sheet1.Name = Cost Data; //Write sheet1 cells data to cells object，创建单元格对象 Cells cells = sheet1.Cells; //Import data into cells，导入数据到单元格中 cells.ImportDataTable(ds.Tables[0], true, 0, 0, ds.Tables[0].Rows.Count, ds.Tables[0].Columns.Count); 这样就可以完成第一张sheet，另外我们还可以通过API对单元格，行，列和边框等等进行样式化。 下面我们生成第二张含有Chart的Sheet。 //Generate the second chart sheet int sheetIndex = workbook.Worksheets.Add(SheetType.Chart); Worksheet sheet2 = workbook.Worksheets[sheetIndex]; //Name the sheet sheet2.Name = "Pareto Chart"; //Set chart index int chartIndex = sheet2.Charts.Add(ChartType.Column, 0, 0, 0, 0); //Get chart type Chart chart = sheet2.Charts[chartIndex]; //Set chart title text chart.Title.Text = "Cost Center"; //Set chart title font chart.Title.TextFont.IsBold = true; chart.Title.TextFont.Size = 16; //Set series string series = "Cost Data!B2:B" + (ds.Tables[0].Rows.Count + 1); //Series add in chart chart.NSeries.Add(series, true); //Set series name chart.NSeries[0].Name = "Annual Cost"; //Set category chart.NSeries.CategoryData = "Cost Data!A2:A" + (ds.Tables[0].Rows.Count + 1); //Legend not shown chart.ShowLegend = false; //Set chart style workbook.ChangePalette(Color.FromArgb(255, 255, 200), 53); //Set plot area foreground color chart.PlotArea.Area.ForegroundColor = Color.FromArgb(255, 255, 200); //Set major grid line color workbook.ChangePalette(Color.FromArgb(121, 117, 200), 54); chart.CategoryAxis.MajorGridLines.Color = Color.FromArgb(121, 117, 200); 现在我们运行，就能生成如图所示的Excel文档了，这样对于需要做数据报表和分析的是非常方便的。