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 + "chart.xls"); // Get an image file to the stream. FileStream stream = new FileStream(dataDir + "logo.jpg", FileMode.Open, FileAccess.Read); // Get the designer chart in the second sheet. Worksheet sheet = workbook.Worksheets[0]; Aspose.Cells.Charts.Chart chart = sheet.Charts[0]; // Add a new picture to the chart. Aspose.Cells.Drawing.Picture pic0 = chart.Shapes.AddPictureInChart(50, 50, stream, 40, 40); // Get the lineformat type of the picture. Aspose.Cells.Drawing.LineFormat lineformat = pic0.Line; // Set the dash style. lineformat.DashStyle = Aspose.Cells.Drawing.MsoLineDashStyle.Solid; // Set the line weight. lineformat.Weight = 4; // Save the excel file. workbook.Save(dataDir + "chart.out.xls"); // ExEnd:1 }
public static void Run() { // Open the existing file. Workbook workbook = new Workbook(sourceDir + "sampleAddingPictureInChart.xls"); // Get an image file to the stream. FileStream stream = new FileStream(sourceDir + "sampleAddingPictureInChart.png", FileMode.Open, FileAccess.Read); // Get the designer chart in the second sheet. Worksheet sheet = workbook.Worksheets[0]; Aspose.Cells.Charts.Chart chart = sheet.Charts[0]; // Add a new picture to the chart. Aspose.Cells.Drawing.Picture pic0 = chart.Shapes.AddPictureInChart(50, 50, stream, 200, 200); // Get the lineformat type of the picture. Aspose.Cells.Drawing.LineFormat lineformat = pic0.Line; // Set the dash style. lineformat.DashStyle = Aspose.Cells.Drawing.MsoLineDashStyle.Solid; // Set the line weight. lineformat.Weight = 4; // Save the excel file. workbook.Save(outputDir + "outputAddingPictureInChart.xls"); Console.WriteLine("AddingPictureInChart executed successfully."); }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Create a new Workbook. // Open the existing file. Workbook workbook = new Workbook(dataDir + "chart.xls"); // Get the designer chart in the second sheet. Worksheet sheet = workbook.Worksheets[1]; Aspose.Cells.Charts.Chart chart = sheet.Charts[0]; // Add a new textbox to the chart. Aspose.Cells.Drawing.TextBox textbox0 = chart.Shapes.AddTextBoxInChart(100, 1100, 350, 2550); // Fill the text. textbox0.Text = "Sales By Region"; // Get the textbox text frame. // Aspose.Cells.Drawing.MsoTextFrame textframe0 = textbox0.TextFrame; // Set the textbox to adjust it according to its contents. // textframe0.AutoSize = true; // Set the font color. textbox0.Font.Color = Color.Maroon; // Set the font to bold. textbox0.Font.IsBold = true; // Set the font size. textbox0.Font.Size = 14; // Set font attribute to italic. textbox0.Font.IsItalic = true; // Get the filformat of the textbox. Aspose.Cells.Drawing.FillFormat fillformat = textbox0.Fill; // Get the lineformat type of the textbox. Aspose.Cells.Drawing.LineFormat lineformat = textbox0.Line; // Set the line weight. lineformat.Weight = 2; // Set the dash style to solid. lineformat.DashStyle = Aspose.Cells.Drawing.MsoLineDashStyle.Solid; // Save the excel file. workbook.Save(dataDir + "chart.out.xls"); // ExEnd:1 }
public static void Run() { // Open the existing file. Workbook workbook = new Workbook(sourceDir + "sampleAddingTextBoxControlInChart.xls"); // Get the designer chart in the second sheet. Worksheet sheet = workbook.Worksheets[0]; Aspose.Cells.Charts.Chart chart = sheet.Charts[0]; // Add a new textbox to the chart. Aspose.Cells.Drawing.TextBox textbox0 = chart.Shapes.AddTextBoxInChart(400, 1100, 350, 2550); // Fill the text. textbox0.Text = "Sales By Region"; // Get the textbox text frame. // Aspose.Cells.Drawing.MsoTextFrame textframe0 = textbox0.TextFrame; // Set the textbox to adjust it according to its contents. // textframe0.AutoSize = true; // Set the font color. textbox0.Font.Color = Color.Maroon; // Set the font to bold. textbox0.Font.IsBold = true; // Set the font size. textbox0.Font.Size = 14; // Set font attribute to italic. textbox0.Font.IsItalic = true; // Get the filformat of the textbox. Aspose.Cells.Drawing.FillFormat fillformat = textbox0.Fill; // Get the lineformat type of the textbox. Aspose.Cells.Drawing.LineFormat lineformat = textbox0.Line; // Set the line weight. lineformat.Weight = 2; // Set the dash style to solid. lineformat.DashStyle = Aspose.Cells.Drawing.MsoLineDashStyle.Solid; // Save the excel file. workbook.Save(outputDir + "outputAddingTextBoxControlInChart.xls"); Console.WriteLine("AddingTextBoxControlInChart executed successfully."); }