public static void Run() { //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Output directory string outputDir = RunExamples.Get_OutputDirectory(); // Open the template file Workbook workbook = new Workbook(sourceDir + "sampleCopyChart.xlsx"); Worksheet worksheet = workbook.Worksheets[0]; // Get the Chart from the "Chart" worksheet. Aspose.Cells.Charts.Chart source = worksheet.Charts[0]; Aspose.Cells.Drawing.ChartShape cshape = source.ChartObject; // Copy the Chart to the Result Worksheet worksheet.Shapes.AddCopy(cshape, 4, 0, 8, 0); // Save the Worksheet workbook.Save(outputDir + "outputCopyChart.xlsx"); Console.WriteLine("CopyChart executed successfully."); }
public static void Run() { //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Output directory string outputDir = RunExamples.Get_OutputDirectory(); // Open the template file Workbook workbook = new Workbook(sourceDir + "sampleCopyShapesBetweenWorksheets.xlsx"); // Get the Picture from the "Picture" worksheet. Aspose.Cells.Drawing.Picture picturesource = workbook.Worksheets["Picture"].Pictures[0]; // Save Picture to Memory Stream MemoryStream ms = new MemoryStream(picturesource.Data); // Copy the picture to the Result Worksheet workbook.Worksheets["Result"].Pictures.Add(picturesource.UpperLeftRow, picturesource.UpperLeftColumn, ms, picturesource.WidthScale, picturesource.HeightScale); // Save the Worksheet workbook.Save(outputDir + "outputCopyShapesBetweenWorksheets_Picture.xlsx"); //----------------------------------- //----------------------------------- // Open the template file workbook = new Workbook(sourceDir + "sampleCopyShapesBetweenWorksheets.xlsx"); // Get the Chart from the "Chart" worksheet. Aspose.Cells.Charts.Chart chartsource = workbook.Worksheets["Chart"].Charts[0]; Aspose.Cells.Drawing.ChartShape cshape = chartsource.ChartObject; // Copy the Chart to the Result Worksheet workbook.Worksheets["Result"].Shapes.AddCopy(cshape, 5, 0, 2, 0); // Save the Worksheet workbook.Save(outputDir + "outputCopyShapesBetweenWorksheets_Chart.xlsx"); //----------------------------------- //----------------------------------- // Open the template file workbook = new Workbook(sourceDir + "sampleCopyShapesBetweenWorksheets.xlsx"); // Get the Shapes from the "Control" worksheet. Aspose.Cells.Drawing.ShapeCollection shape = workbook.Worksheets["Control"].Shapes; // Copy the Textbox to the Result Worksheet workbook.Worksheets["Result"].Shapes.AddCopy(shape[0], 5, 0, 2, 0); // Save the Worksheet workbook.Save(outputDir + "outputCopyShapesBetweenWorksheets_Control.xlsx"); Console.WriteLine("CopyShapesBetweenWorksheets executed successfully."); }
public static void Run() { // ExStart:CopyPictureBetweenWorksheets // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Open the template file Workbook workbook = new Workbook(dataDir + "sample.xlsx"); // Get the Picture from the "Picture" worksheet. Aspose.Cells.Drawing.Picture picturesource = workbook.Worksheets["Picture"].Pictures[0]; // Save Picture to Memory Stream MemoryStream ms = new MemoryStream(picturesource.Data); // Copy the picture to the Result Worksheet workbook.Worksheets["Result"].Pictures.Add(picturesource.UpperLeftRow, picturesource.UpperLeftColumn, ms, picturesource.WidthScale, picturesource.HeightScale); // Save the Worksheet workbook.Save(dataDir + "PictureCopied_out.xlsx"); // ExEnd:CopyPictureBetweenWorksheets // ExStart:CopyChartBetweenWorksheets // Get the Chart from the "Chart" worksheet. Aspose.Cells.Charts.Chart chartsource = workbook.Worksheets["Chart"].Charts[0]; Aspose.Cells.Drawing.ChartShape cshape = chartsource.ChartObject; // Copy the Chart to the Result Worksheet workbook.Worksheets["Result"].Shapes.AddCopy(cshape, 20, 0, 2, 0); // Save the Worksheet workbook.Save(dataDir + "ChartCopied_out.xlsx"); // ExEnd:CopyChartBetweenWorksheets // ExStart:CopyControlsAndOtherDrawingObjects // Open the template file workbook = new Workbook(dataDir + "sample2.xlsx"); // Get the Shapes from the "Control" worksheet. Aspose.Cells.Drawing.ShapeCollection shape = workbook.Worksheets["Control"].Shapes; // Copy the Textbox to the Result Worksheet workbook.Worksheets["Result"].Shapes.AddCopy(shape[0], 5, 0, 2, 0); // Copy the Oval Shape to the Result Worksheet workbook.Worksheets["Result"].Shapes.AddCopy(shape[1], 10, 0, 2, 0); // Save the Worksheet workbook.Save(dataDir + "ControlsCopied_out.xlsx"); // ExEnd:CopyControlsAndOtherDrawingObjects }
static void Main(string[] args) { //Create a workbook object //Open the template file Workbook workbook = new Workbook("Shapes.xls"); //Get the Chart from the "Chart" worksheet. Aspose.Cells.Charts.Chart source = workbook.Worksheets["Chart"].Charts[0]; Aspose.Cells.Drawing.ChartShape cshape = source.ChartObject; //Copy the Chart to the Result Worksheet workbook.Worksheets["Result"].Shapes.AddCopy(cshape, 20, 0, 2, 0); //Save the Worksheet workbook.Save("Shapes.xls"); }
public static void Main() { // The path to the documents directory. string dataDir = Path.GetFullPath("../../../Data/"); //Create a workbook object //Open the template file Workbook workbook = new Workbook(dataDir + "aspose-sample.xlsx"); //Get the Chart from the "Chart" worksheet. Aspose.Cells.Charts.Chart source = workbook.Worksheets["Sheet2"].Charts[0]; Aspose.Cells.Drawing.ChartShape cshape = source.ChartObject; //Copy the Chart to the Result Worksheet workbook.Worksheets["Sheet3"].Shapes.AddCopy(cshape, 20, 0, 2, 0); //Save the Worksheet workbook.Save(dataDir + "Shapes.xlsx"); }
static void Main(string[] args) { string FilePath = @"..\..\..\Sample Files\"; string FileName = FilePath + "Copy Shapes between Worksheets.xlsx"; //Open the template file Workbook workbook = new Workbook(FileName); //Get the Chart from the "Chart" worksheet. Aspose.Cells.Charts.Chart source = workbook.Worksheets["Chart"].Charts[0]; Aspose.Cells.Drawing.ChartShape cshape = source.ChartObject; //Copy the Chart to the Result Worksheet workbook.Worksheets["Result"].Shapes.AddCopy(cshape, 20, 0, 2, 0); //Save the Worksheet workbook.Save(FileName); }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Create a workbook object // Open the template file Workbook workbook = new Workbook(dataDir + "aspose-sample.xlsx"); // Get the Chart from the "Chart" worksheet. Aspose.Cells.Charts.Chart source = workbook.Worksheets["Sheet2"].Charts[0]; Aspose.Cells.Drawing.ChartShape cshape = source.ChartObject; // Copy the Chart to the Result Worksheet workbook.Worksheets["Sheet3"].Shapes.AddCopy(cshape, 20, 0, 2, 0); // Save the Worksheet workbook.Save(dataDir + "Shapes.out.xlsx"); // ExEnd:1 }