public static void Run() { // Instantiating a Workbook object Workbook workbook = new Workbook(); // Obtaining the reference of the newly added worksheet by passing its sheet index Worksheet worksheet = workbook.Worksheets[0]; // Adding sample values to cells worksheet.Cells["A1"].PutValue(50); worksheet.Cells["A2"].PutValue(100); worksheet.Cells["A3"].PutValue(150); worksheet.Cells["B1"].PutValue(4); worksheet.Cells["B2"].PutValue(20); worksheet.Cells["B3"].PutValue(50); // Adding a chart to the worksheet int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Line, 5, 0, 25, 10); // Accessing the instance of the newly added chart Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex]; // Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B3" chart.NSeries.Add("A1:B3", true); // Saving the Excel file workbook.Save(outputDir + "outputHowToCreateLineChart.xlsx"); Console.WriteLine("HowToCreateLineChart executed successfully."); }
public static void Run() { // Open the existing file. Workbook workbook = new Workbook(sourceDir + "sampleModifyLineChart.xlsx"); // Get the designer chart in the first worksheet. Aspose.Cells.Charts.Chart chart = workbook.Worksheets[0].Charts[0]; // Add the third data series to it. chart.NSeries.Add("{60, 80, 10}", true); // Add another data series (fourth) to it. chart.NSeries.Add("{0.3, 0.7, 1.2}", true); // Plot the fourth data series on the second axis. chart.NSeries[3].PlotOnSecondAxis = true; // Change the Border color of the second data series. chart.NSeries[1].Border.Color = Color.Green; // Change the Border color of the third data series. chart.NSeries[2].Border.Color = Color.Red; // Make the second value axis visible. chart.SecondValueAxis.IsVisible = true; // Save the excel file. workbook.Save(outputDir + "outputModifyLineChart.xlsx"); Console.WriteLine("ModifyLineChart executed successfully."); }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Open the existing file. Workbook workbook = new Workbook(dataDir + "Book1.xlsx"); // Get the designer chart in the first worksheet. Aspose.Cells.Charts.Chart chart = workbook.Worksheets[0].Charts[0]; // Add the third data series to it. chart.NSeries.Add("{60, 80, 10}", true); // Add another data series (fourth) to it. chart.NSeries.Add("{0.3, 0.7, 1.2}", true); // Plot the fourth data series on the second axis. chart.NSeries[3].PlotOnSecondAxis = true; // Change the Border color of the second data series. chart.NSeries[1].Border.Color = Color.Green; // Change the Border color of the third data series. chart.NSeries[2].Border.Color = Color.Red; // Make the second value axis visible. chart.SecondValueAxis.IsVisible = true; // Save the excel file. workbook.Save(dataDir + "output.xls"); // ExEnd:1 }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Instantiating a Workbook object Workbook workbook = new Workbook(); // Adding a new worksheet to the Workbook object int sheetIndex = workbook.Worksheets.Add(); // Obtaining the reference of the newly added worksheet by passing its sheet index Worksheet worksheet = workbook.Worksheets[sheetIndex]; // Adding a sample value to "A1" cell worksheet.Cells["A1"].PutValue(50); // Adding a sample value to "A2" cell worksheet.Cells["A2"].PutValue(100); // Adding a sample value to "A3" cell worksheet.Cells["A3"].PutValue(150); // Adding a sample value to "A4" cell worksheet.Cells["A4"].PutValue(110); // Adding a sample value to "B1" cell worksheet.Cells["B1"].PutValue(260); // Adding a sample value to "B2" cell worksheet.Cells["B2"].PutValue(12); // Adding a sample value to "B3" cell worksheet.Cells["B3"].PutValue(50); // Adding a sample value to "B4" cell worksheet.Cells["B4"].PutValue(100); // Adding a chart to the worksheet int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column, 5, 0, 15, 5); // Accessing the instance of the newly added chart Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex]; // Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B4" chart.NSeries.Add("A1:B4", true); // Setting the chart type of 2nd NSeries to display as line chart chart.NSeries[1].Type = Aspose.Cells.Charts.ChartType.Line; // Saving the Excel file workbook.Save(dataDir + "output.xls"); // ExEnd:1 }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Instantiating a Workbook object Workbook workbook = new Workbook(); // Obtaining the reference of the first worksheet by passing its index Worksheet worksheet = workbook.Worksheets[0]; // Fill in data for chart's series worksheet.Cells[0, 0].PutValue("Y Values"); worksheet.Cells[0, 1].PutValue(2); worksheet.Cells[0, 2].PutValue(4); worksheet.Cells[0, 3].PutValue(6); worksheet.Cells[1, 0].PutValue("Bubble Size"); worksheet.Cells[1, 1].PutValue(2); worksheet.Cells[1, 2].PutValue(3); worksheet.Cells[1, 3].PutValue(1); worksheet.Cells[2, 0].PutValue("X Values"); worksheet.Cells[2, 1].PutValue(1); worksheet.Cells[2, 2].PutValue(2); worksheet.Cells[2, 3].PutValue(3); // Adding a chart to the worksheet int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Bubble, 5, 0, 15, 5); // Accessing the instance of the newly added chart Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex]; // Adding SeriesCollection (chart data source) to the chart ranging chart.NSeries.Add("B1:D1", true); // Set bubble sizes chart.NSeries[0].BubbleSizes = "B2:D2"; // Set X axis values chart.NSeries[0].XValues = "B3:D3"; // Set Y axis values chart.NSeries[0].Values = "B1:D1"; // Saving the Excel file workbook.Save(dataDir + "output.xls"); // ExEnd:1 }
public static void Run() { // Instantiating a Workbook object Workbook workbook = new Workbook(); // Obtaining the reference of the first worksheet by passing its index Worksheet worksheet = workbook.Worksheets[0]; // Fill in data for chart's series worksheet.Cells[0, 0].PutValue("Y Values"); worksheet.Cells[0, 1].PutValue(2); worksheet.Cells[0, 2].PutValue(4); worksheet.Cells[0, 3].PutValue(6); worksheet.Cells[1, 0].PutValue("Bubble Size"); worksheet.Cells[1, 1].PutValue(2); worksheet.Cells[1, 2].PutValue(3); worksheet.Cells[1, 3].PutValue(1); worksheet.Cells[2, 0].PutValue("X Values"); worksheet.Cells[2, 1].PutValue(1); worksheet.Cells[2, 2].PutValue(2); worksheet.Cells[2, 3].PutValue(3); // Adding a chart to the worksheet int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Bubble, 5, 0, 25, 10); // Accessing the instance of the newly added chart Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex]; // Adding SeriesCollection (chart data source) to the chart ranging chart.NSeries.Add("B1:D1", true); // Set bubble sizes chart.NSeries[0].BubbleSizes = "B2:D2"; // Set X axis values chart.NSeries[0].XValues = "B3:D3"; // Set Y axis values chart.NSeries[0].Values = "B1:D1"; // Saving the Excel file workbook.Save(outputDir + "outputHowToCreateBubbleChart.xlsx"); Console.WriteLine("HowToCreateBubbleChart executed successfully."); }
public static void Run() { // Open the existing file. Workbook workbook = new Workbook(sourceDir + "sampleModifyPieChart.xlsx"); // Get the designer chart in the second sheet. Worksheet sheet = workbook.Worksheets[1]; Aspose.Cells.Charts.Chart chart = sheet.Charts[0]; // Get the data labels in the data series of the third data point. Aspose.Cells.Charts.DataLabels datalabels = chart.NSeries[0].Points[2].DataLabels; // Change the text of the label. datalabels.Text = "Unided Kingdom, 400K "; // Save the excel file. workbook.Save(outputDir + "outputModifyPieChart.xlsx"); Console.WriteLine("ModifyPieChart executed successfully."); }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Open the existing file. Workbook workbook = new Workbook(dataDir + "piechart.xls"); // Get the designer chart in the second sheet. Worksheet sheet = workbook.Worksheets[1]; Aspose.Cells.Charts.Chart chart = sheet.Charts[0]; // Get the data labels in the data series of the third data point. Aspose.Cells.Charts.DataLabels datalabels = chart.NSeries[0].Points[2].DataLabels; // Change the text of the label. datalabels.Text = "Unided Kingdom, 400K "; // Save the excel file. workbook.Save(dataDir + "output.xls"); // ExEnd:1 }
static int AddExcelChartInWorkbook(Workbook wb) { //Add a new worksheet to populate cells with data int dataSheetIdx = wb.Worksheets.Add(); Worksheet dataSheet = wb.Worksheets[dataSheetIdx]; string sheetName = "DataSheet"; dataSheet.Name = sheetName; //Populate DataSheet with data dataSheet.Cells["A2"].PutValue("N. America"); dataSheet.Cells["A3"].PutValue("S. America"); dataSheet.Cells["A4"].PutValue("Europe"); dataSheet.Cells["A5"].PutValue("Asia"); dataSheet.Cells["B1"].PutValue("Q1"); dataSheet.Cells["B2"].PutValue(1.5); dataSheet.Cells["B3"].PutValue(2); dataSheet.Cells["B4"].PutValue(2.25); dataSheet.Cells["B5"].PutValue(2.5); dataSheet.Cells["C1"].PutValue("Q2"); dataSheet.Cells["C2"].PutValue(2); dataSheet.Cells["C3"].PutValue(1.75); dataSheet.Cells["C4"].PutValue(2); dataSheet.Cells["C5"].PutValue(2.5); dataSheet.Cells["D1"].PutValue("Q3"); dataSheet.Cells["D2"].PutValue(1.5); dataSheet.Cells["D3"].PutValue(2); dataSheet.Cells["D4"].PutValue(2.5); dataSheet.Cells["D5"].PutValue(2); dataSheet.Cells["E1"].PutValue("Q4"); dataSheet.Cells["E2"].PutValue(2.5); dataSheet.Cells["E3"].PutValue(2); dataSheet.Cells["E4"].PutValue(2); dataSheet.Cells["E5"].PutValue(2.75); //Add a chart sheet int chartSheetIdx = wb.Worksheets.Add(SheetType.Chart); Worksheet chartSheet = wb.Worksheets[chartSheetIdx]; chartSheet.Name = "ChartSheet"; //Add a chart in ChartSheet with data series from DataSheet int chartIdx = chartSheet.Charts.Add(ChartType.Column3DClustered, 0, 5, 0, 5); Aspose.Cells.Charts.Chart chart = chartSheet.Charts[chartIdx]; chart.NSeries.Add(sheetName + "!A1:E5", false); //Setting Chart's Title chart.Title.Text = "Sales by Quarter"; //Setting the foreground color of the plot area chart.PlotArea.Area.ForegroundColor = Color.White; //Setting the background color of the plot area chart.PlotArea.Area.BackgroundColor = Color.White; //Setting the foreground color of the chart area chart.ChartArea.Area.BackgroundColor = Color.White; chart.Title.TextFont.Size = 16; //Setting the title of category axis of the chart chart.CategoryAxis.Title.Text = "Fiscal Quarter"; //Setting the title of value axis of the chart chart.ValueAxis.Title.Text = "Billions"; //Set ChartSheet an active sheet wb.Worksheets.ActiveSheetIndex = chartSheetIdx; return(chartSheetIdx); }
public static void Run() { // 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.Pie, 5, 0, 25, 10); Aspose.Cells.Charts.Chart chart = sheet.Charts[chartIndex]; // Set some properties of chart plot area. // To set the fill color and make the border invisible. chart.PlotArea.Area.ForegroundColor = Color.Coral; chart.PlotArea.Area.FillFormat.SetTwoColorGradient(Color.Yellow, Color.White, Aspose.Cells.Drawing.GradientStyleType.Vertical, 2); 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 DataLabels in the chart Aspose.Cells.Charts.DataLabels datalabels; for (int i = 0; i < chart.NSeries.Count; i++) { datalabels = chart.NSeries[i].DataLabels; datalabels.Position = Aspose.Cells.Charts.LabelPositionType.InsideBase; datalabels.ShowCategoryName = true; datalabels.ShowValue = true; datalabels.ShowPercentage = false; datalabels.ShowLegendKey = false; } // Set the ChartArea. Aspose.Cells.Charts.ChartArea chartarea = chart.ChartArea; chartarea.Area.Formatting = Aspose.Cells.Charts.FormattingType.Custom; chartarea.Area.FillFormat.Texture = Aspose.Cells.Drawing.TextureType.BlueTissuePaper; // Set the Legend. Aspose.Cells.Charts.Legend legend = chart.Legend; legend.Position = Aspose.Cells.Charts.LegendPositionType.Left; legend.Height = 100; legend.Width = 130; legend.Y = 1500; legend.Font.IsBold = true; legend.Border.Color = Color.Blue; legend.Area.Formatting = Aspose.Cells.Charts.FormattingType.Custom; // Set FillFormat. Aspose.Cells.Drawing.FillFormat fillformat = legend.Area.FillFormat; fillformat.Texture = Aspose.Cells.Drawing.TextureType.Bouquet; // Save the excel file workbook.Save(outputDir + "outputHowToCreatePieChart.xlsx"); Console.WriteLine("HowToCreatePieChart executed successfully."); }
public static void Main(string[] args) { //ExStart:1 // The path to the documents directory. string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Create directory if it is not already present. bool IsExists = System.IO.Directory.Exists(dataDir); if (!IsExists) { System.IO.Directory.CreateDirectory(dataDir); } //Instantiate a new Workbook Workbook book = new Workbook(); //Add a Data Worksheet Worksheet dataSheet = book.Worksheets.Add("DataSheet"); //Add Chart Worksheet Worksheet sheet = book.Worksheets.Add("MyChart"); //Put some values into the cells in the data worksheet dataSheet.Cells["B1"].PutValue(1); dataSheet.Cells["B2"].PutValue(2); dataSheet.Cells["B3"].PutValue(3); dataSheet.Cells["A1"].PutValue("A"); dataSheet.Cells["A2"].PutValue("B"); dataSheet.Cells["A3"].PutValue("C"); //Define the Chart Collection ChartCollection charts = sheet.Charts; //Add a Column chart to the Chart Worksheet int chartSheetIdx = charts.Add(ChartType.Column, 5, 0, 25, 15); //Get the newly added Chart Aspose.Cells.Charts.Chart chart = book.Worksheets[2].Charts[0]; //Set the background/foreground color for PlotArea/ChartArea chart.PlotArea.Area.BackgroundColor = Color.White; chart.ChartArea.Area.BackgroundColor = Color.White; chart.PlotArea.Area.ForegroundColor = Color.White; chart.ChartArea.Area.ForegroundColor = Color.White; //Hide the Legend chart.ShowLegend = false; //Add Data Series for the Chart chart.NSeries.Add("DataSheet!B1:B3", true); //Specify the Category Data chart.NSeries.CategoryData = "DataSheet!A1:A3"; //Get the Data Series Aspose.Cells.Charts.Series ser = chart.NSeries[0]; //Apply the 3-D formatting ShapePropertyCollection spPr = ser.ShapeProperties; Format3D fmt3d = spPr.Format3D; //Specify Bevel with its height/width Bevel bevel = fmt3d.TopBevel; bevel.Type = BevelPresetType.Circle; bevel.Height = 2; bevel.Width = 5; //Specify Surface material type fmt3d.SurfaceMaterialType = PresetMaterialType.WarmMatte; //Specify surface lighting type fmt3d.SurfaceLightingType = LightRigType.ThreePoint; //Specify lighting angle fmt3d.LightingAngle = 20; //Specify Series background/foreground and line color ser.Area.BackgroundColor = Color.Maroon; ser.Area.ForegroundColor = Color.Maroon; ser.Border.Color = Color.Maroon; //Save the Excel file book.Save(dataDir + "3d_format.out.xlsx"); //ExEnd:1 }
public static void Run() { // Instantiate a new Workbook Workbook book = new Workbook(); //Rename the first worksheet book.Worksheets[0].Name = "DataSheet"; // Add a Data Worksheet Worksheet dataSheet = book.Worksheets["DataSheet"]; // Add Chart Worksheet Worksheet sheet = book.Worksheets.Add("MyChart"); // Put some values into the cells in the data worksheet dataSheet.Cells["B1"].PutValue(1); dataSheet.Cells["B2"].PutValue(2); dataSheet.Cells["B3"].PutValue(3); dataSheet.Cells["A1"].PutValue("A"); dataSheet.Cells["A2"].PutValue("B"); dataSheet.Cells["A3"].PutValue("C"); // Define the Chart Collection ChartCollection charts = sheet.Charts; // Add a Column chart to the Chart Worksheet int chartSheetIdx = charts.Add(ChartType.Column, 5, 0, 25, 15); // Get the newly added Chart Aspose.Cells.Charts.Chart chart = book.Worksheets["MyChart"].Charts[0]; // Set the background/foreground color for PlotArea/ChartArea chart.PlotArea.Area.BackgroundColor = Color.White; chart.ChartArea.Area.BackgroundColor = Color.White; chart.PlotArea.Area.ForegroundColor = Color.White; chart.ChartArea.Area.ForegroundColor = Color.White; // Hide the Legend chart.ShowLegend = false; // Add Data Series for the Chart chart.NSeries.Add("DataSheet!B1:B3", true); // Specify the Category Data chart.NSeries.CategoryData = "DataSheet!A1:A3"; // Get the Data Series Aspose.Cells.Charts.Series ser = chart.NSeries[0]; // Apply the 3-D formatting ShapePropertyCollection spPr = ser.ShapeProperties; Format3D fmt3d = spPr.Format3D; // Specify Bevel with its height/width Bevel bevel = fmt3d.TopBevel; bevel.Type = BevelPresetType.Circle; bevel.Height = 2; bevel.Width = 5; // Specify Surface material type fmt3d.SurfaceMaterialType = PresetMaterialType.WarmMatte; // Specify surface lighting type fmt3d.SurfaceLightingType = LightRigType.ThreePoint; // Specify lighting angle fmt3d.LightingAngle = 20; // Specify Series background/foreground and line color ser.Area.BackgroundColor = Color.Maroon; ser.Area.ForegroundColor = Color.Maroon; ser.Border.Color = Color.Maroon; // Save the Excel file book.Save(outputDir + "outputApplying3DFormat.xlsx"); Console.WriteLine("Applying3DFormat executed successfully."); }