public static void Run() { // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Create a new Workbook. Workbook workbook = new Workbook(); // Get the first worksheet. Worksheet sheet = workbook.Worksheets[0]; // Set the name of worksheet sheet.Name = "Data"; // Get the cells collection in the sheet. Cells cells = workbook.Worksheets[0].Cells; // Put some values into a cells of the Data sheet. cells["A1"].PutValue("Region"); cells["A2"].PutValue("France"); cells["A3"].PutValue("Germany"); cells["A4"].PutValue("England"); cells["A5"].PutValue("Sweden"); cells["A6"].PutValue("Italy"); cells["A7"].PutValue("Spain"); cells["A8"].PutValue("Portugal"); cells["B1"].PutValue("Sale"); cells["B2"].PutValue(70000); cells["B3"].PutValue(55000); cells["B4"].PutValue(30000); cells["B5"].PutValue(40000); cells["B6"].PutValue(35000); cells["B7"].PutValue(32000); cells["B8"].PutValue(10000); // Add a chart sheet. int sheetIndex = workbook.Worksheets.Add(SheetType.Chart); sheet = workbook.Worksheets[sheetIndex]; // Set the name of worksheet sheet.Name = "Chart"; // Create chart int chartIndex = 0; chartIndex = sheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column, 1, 1, 25, 10); Aspose.Cells.Charts.Chart chart = sheet.Charts[chartIndex]; // Set some properties of chart plot area. // To set a picture as fill format and make the border invisible. FileStream fs = File.OpenRead(dataDir + "aspose-logo.jpg"); byte[] data = new byte[fs.Length]; fs.Read(data, 0, data.Length); chart.PlotArea.Area.FillFormat.ImageData = data; chart.PlotArea.Border.IsVisible = false; // Set properties of chart title chart.Title.Text = "Sales By Region"; chart.Title.Font.Color = Color.Blue; chart.Title.Font.IsBold = true; chart.Title.Font.Size = 12; // Set properties of nseries chart.NSeries.Add("Data!B2:B8", true); chart.NSeries.CategoryData = "Data!A2:A8"; chart.NSeries.IsColorVaried = true; // Set the Legend. Aspose.Cells.Charts.Legend legend = chart.Legend; legend.Position = Aspose.Cells.Charts.LegendPositionType.Top; // Save the excel file workbook.Save(dataDir + "column_chart.out.xls"); }
public static void Run() { //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Output directory string outputDir = RunExamples.Get_OutputDirectory(); // Create a new Workbook. Workbook workbook = new Workbook(); // Get the first worksheet. Worksheet sheet = workbook.Worksheets[0]; // Set the name of worksheet sheet.Name = "Data"; // Get the cells collection in the sheet. Cells cells = workbook.Worksheets[0].Cells; // Put some values into a cells of the Data sheet. cells["A1"].PutValue("Region"); cells["A2"].PutValue("France"); cells["A3"].PutValue("Germany"); cells["A4"].PutValue("England"); cells["A5"].PutValue("Sweden"); cells["A6"].PutValue("Italy"); cells["A7"].PutValue("Spain"); cells["A8"].PutValue("Portugal"); cells["B1"].PutValue("Sale"); cells["B2"].PutValue(70000); cells["B3"].PutValue(55000); cells["B4"].PutValue(30000); cells["B5"].PutValue(40000); cells["B6"].PutValue(35000); cells["B7"].PutValue(32000); cells["B8"].PutValue(10000); // Add a chart sheet. int sheetIndex = workbook.Worksheets.Add(SheetType.Chart); sheet = workbook.Worksheets[sheetIndex]; // Set the name of worksheet sheet.Name = "Chart"; // Create chart int chartIndex = 0; chartIndex = sheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column, 1, 1, 25, 10); Aspose.Cells.Charts.Chart chart = sheet.Charts[chartIndex]; // Set some properties of chart plot area. // To set a picture as fill format and make the border invisible. FileStream fs = File.OpenRead(sourceDir + "sampleSetPictureBackGroundFillChart.png"); byte[] data = new byte[fs.Length]; fs.Read(data, 0, data.Length); chart.PlotArea.Area.FillFormat.ImageData = data; chart.PlotArea.Border.IsVisible = false; // Set properties of chart title chart.Title.Text = "Sales By Region"; chart.Title.Font.Color = Color.Blue; chart.Title.Font.IsBold = true; chart.Title.Font.Size = 12; // Set properties of nseries chart.NSeries.Add("Data!B2:B8", true); chart.NSeries.CategoryData = "Data!A2:A8"; chart.NSeries.IsColorVaried = true; // Set the Legend. Aspose.Cells.Charts.Legend legend = chart.Legend; legend.Position = Aspose.Cells.Charts.LegendPositionType.Top; // Save the excel file workbook.Save(outputDir + "outputSetPictureBackGroundFillChart.xlsx"); Console.WriteLine("SetPictureBackGroundFillChart executed successfully."); }