static void Main(string[] args) { //Create a workbook Workbook wb = new Workbook(); //Add an excel chart int chartSheetIndex = AddExcelChartInWorkbook(wb); wb.Worksheets.SetOleSize(0, 5, 0, 5); Bitmap imgChart = wb.Worksheets[chartSheetIndex].Charts[0].ToImage(); //Save the workbook to stream MemoryStream wbStream = wb.SaveToStream(); //Create a presentation PresentationEx pres = new PresentationEx(); SlideEx sld = pres.Slides[0]; //Add the workbook on slide AddExcelChartInPresentation(pres, sld, wbStream, imgChart); //Write the output presentation on disk pres.Write("chart.pptx"); }
static void Main(string[] args) { //Instantiate a Presentation class that represents the presentation file string MyDir = @"Files\"; using (PresentationEx pres = new PresentationEx(MyDir + "Slides Test Presentation.pptx")) { //Access the second slide SlideEx sld = pres.Slides[1]; //Create a memory stream object MemoryStream SvgStream = new MemoryStream(); //Generate SVG image of slide and save in memory stream sld.WriteAsSvg(SvgStream); SvgStream.Position = 0; //Save memory stream to file using (Stream fileStream = System.IO.File.OpenWrite(MyDir + "PresentatoinTemplate.svg")) { byte[] buffer = new byte[8 * 1024]; int len; while ((len = SvgStream.Read(buffer, 0, buffer.Length)) > 0) { fileStream.Write(buffer, 0, len); } } SvgStream.Close(); } }
// Get all the text in a slide. public static List <string> GetAllTextInSlide(string presentationFile, int slideIndex) { // Create a new linked list of strings. List <string> texts = new List <string>(); //Instantiate PresentationEx class that represents PPTX using (PresentationEx pres = new PresentationEx(presentationFile)) { //Access the slide SlideEx sld = pres.Slides[slideIndex]; //Iterate through shapes to find the placeholder foreach (ShapeEx shp in sld.Shapes) { if (shp.Placeholder != null) { //get the text of each placeholder texts.Add(((AutoShapeEx)shp).TextFrame.Text); } } } // Return an array of strings. return(texts); }
static void Main(string[] args) { //Create empty presentation using (PresentationEx pres = new PresentationEx()) { //Accessing first slide SlideEx slide = pres.Slides[0]; //Addding default chart ChartEx ppChart = slide.Shapes.AddChart(ChartTypeEx.ClusteredColumn3D, 20F, 30F, 400F, 300F); //Getting Chart data ChartDataEx chartData = ppChart.ChartData; //Removing Extra default series chartData.Series.RemoveAt(1); chartData.Series.RemoveAt(1); //Modifying chart categories names chartData.Categories[0].ChartDataCell.Value = "Bikes"; chartData.Categories[1].ChartDataCell.Value = "Accessories"; chartData.Categories[2].ChartDataCell.Value = "Repairs"; chartData.Categories[3].ChartDataCell.Value = "Clothing"; //Modifying chart series values for first category chartData.Series[0].Values[0].Value = 1000; chartData.Series[0].Values[1].Value = 2500; chartData.Series[0].Values[2].Value = 4000; chartData.Series[0].Values[3].Value = 3000; //Setting Chart title ppChart.HasTitle = true; ppChart.ChartTitle.Text.Text = "2007 Sales"; PortionFormatEx format = ppChart.ChartTitle.Text.Paragraphs[0].Portions[0].PortionFormat; format.FontItalic = NullableBool.True; format.FontHeight = 18; format.FillFormat.FillType = FillTypeEx.Solid; format.FillFormat.SolidFillColor.Color = Color.Black; //Setting Axis values ppChart.ValueAxis.IsAutomaticMaxValue = false; ppChart.ValueAxis.IsAutomaticMinValue = false; ppChart.ValueAxis.IsAutomaticMajorUnit = false; ppChart.ValueAxis.IsAutomaticMinorUnit = false; ppChart.ValueAxis.MaxValue = 4000.0F; ppChart.ValueAxis.MinValue = 0.0F; ppChart.ValueAxis.MajorUnit = 2000.0F; ppChart.ValueAxis.MinorUnit = 1000.0F; ppChart.ValueAxis.TickLabelPosition = TickLabelPositionType.NextTo; //Setting Chart rotation ppChart.Rotation3D.RotationX = 15; ppChart.Rotation3D.RotationY = 20; //Saving Presentation pres.Write("AsposeSampleChart.pptx"); } }
static void Main(string[] args) { string MyDir = @"Files\"; //Instantiate a Presentation class that represents the presentation file using (PresentationEx pres = new PresentationEx(MyDir + "Slides Test Presentation.pptx")) { //Access the first slide SlideEx sld = pres.Slides[0]; //User defined dimension int desiredX = 1200; int desiredY = 800; //Getting scaled value of X and Y float ScaleX = (float)(1.0 / pres.SlideSize.Size.Width) * desiredX; float ScaleY = (float)(1.0 / pres.SlideSize.Size.Height) * desiredY; //Create a full scale image Bitmap bmp = sld.GetThumbnail(ScaleX, ScaleY); //Save the image to disk in JPEG format bmp.Save(MyDir + "Thumbnail2.jpg", System.Drawing.Imaging.ImageFormat.Jpeg); } }
public static void AccessingSlidesOfPresentation() { string MyDir = @"Files\"; //Instantiate a Presentation object that represents a presentation file PresentationEx pres = new PresentationEx(MyDir + "Slides Test Presentation.pptx"); //Accessing a slide using its slide index SlideEx slide = pres.Slides[0]; }
private static void AddExcelChartInPresentation(PresentationEx pres, SlideEx sld, Stream wbStream, Bitmap imgChart) { float oleWidth = pres.SlideSize.Size.Width; float oleHeight = pres.SlideSize.Size.Height; int x = 0; byte[] chartOleData = new byte[wbStream.Length]; wbStream.Position = 0; wbStream.Read(chartOleData, 0, chartOleData.Length); OleObjectFrameEx oof = null; oof = sld.Shapes.AddOleObjectFrame(x, 0, oleWidth, oleHeight, "Excel.Sheet.8", chartOleData); oof.Image = pres.Images.AddImage((System.Drawing.Image)imgChart); }
public static void ChangingPositionOfSlide() { string MyDir = @"Files\"; //Instantiate Presentation class to load the source presentation file PresentationEx pres = new PresentationEx(MyDir + "Slides Test Presentation.pptx"); { //Get the slide whose position is to be changed SlideEx sld = pres.Slides[0]; //Set the new position for the slide sld.SlideNumber = 2; //Write the presentation to disk pres.Save(MyDir + "Changed Slide Position Presentation.pptx", SaveFormat.Pptx); } }
public static void RemovingSlides() { string MyDir = @"Files\"; //Instantiate a Presentation object that represents a presentation file PresentationEx pres = new PresentationEx(MyDir + "Slides Test Presentation.pptx"); //Accessing a slide using its index in the slides collection SlideEx slide = pres.Slides[0]; //Removing a slide using its reference pres.Slides.Remove(slide); //Writing the presentation file pres.Write(MyDir + "modified.pptx"); }
public static void DeleteSlide(string presentationFile, int slideIndex) { //Instantiate a PresentationEx object that represents a PPTX file using (PresentationEx pres = new PresentationEx(presentationFile)) { //Accessing a slide using its index in the slides collection SlideEx slide = pres.Slides[slideIndex]; //Removing a slide using its reference pres.Slides.Remove(slide); //Writing the presentation as a PPTX file pres.Write(presentationFile); } }
static void Main(string[] args) { string MyDir = @"Files\"; //Instantiate a Presentation class that represents the presentation file using (PresentationEx pres = new PresentationEx(MyDir + "Slides Test Presentation.pptx")) { //Access the first slide SlideEx sld = pres.Slides[0]; //Create a full scale image Bitmap bmp = sld.GetThumbnail(1f, 1f); //Save the image to disk in JPEG format bmp.Save(MyDir + "Test Thumbnail.jpg", System.Drawing.Imaging.ImageFormat.Jpeg); } }
// Move a slide to a different position in the slide order in the presentation. public static void MoveSlide(string presentationFile, int from, int to) { //Instantiate PresentationEx class to load the source PPTX file using (PresentationEx pres = new PresentationEx(presentationFile)) { //Get the slide whose position is to be changed SlideEx sld = pres.Slides[from]; SlideEx sld2 = pres.Slides[to]; //Set the new position for the slide sld2.SlideNumber = from; sld.SlideNumber = to; //Write the PPTX to disk pres.Write(presentationFile); } }
public static string GetSlideText(string docName, int index) { string sldText = ""; //Instantiate PresentationEx class that represents PPTX using (PresentationEx pres = new PresentationEx(docName)) { //Access the slide SlideEx sld = pres.Slides[index]; //Iterate through shapes to find the placeholder foreach (ShapeEx shp in sld.Shapes) { if (shp.Placeholder != null) { //get the text of each placeholder sldText += ((AutoShapeEx)shp).TextFrame.Text; } } } return(sldText); }
static void Main(string[] args) { string path = @"Files\"; //Accessing the presentation PresentationEx pres = new PresentationEx(path + "RenderImageFromShape.pptx"); ImageEx img = null; int slideIndex = 0; String ImageType = ""; bool ifImageFound = false; for (int i = 0; i < pres.Slides.Count; i++) { slideIndex++; //Accessing the first slide SlideEx sl = pres.Slides[i]; System.Drawing.Imaging.ImageFormat Format = System.Drawing.Imaging.ImageFormat.Jpeg; for (int j = 0; j < sl.Shapes.Count; j++) { // Accessing the shape with picture ShapeEx sh = sl.Shapes[j]; if (sh is AutoShapeEx) { AutoShapeEx ashp = (AutoShapeEx)sh; if (ashp.FillFormat.FillType == FillTypeEx.Picture) { img = ashp.FillFormat.PictureFillFormat.Picture.Image; ImageType = img.ContentType; ImageType = ImageType.Remove(0, ImageType.IndexOf("/") + 1); ifImageFound = true; } } else if (sh is PictureFrameEx) { PictureFrameEx pf = (PictureFrameEx)sh; if (pf.FillFormat.FillType == FillTypeEx.Picture) { img = pf.PictureFormat.Picture.Image; ImageType = img.ContentType; ImageType = ImageType.Remove(0, ImageType.IndexOf("/") + 1); ifImageFound = true; } } // //Setting the desired picture format if (ifImageFound) { switch (ImageType) { case "jpeg": Format = System.Drawing.Imaging.ImageFormat.Jpeg; break; case "emf": Format = System.Drawing.Imaging.ImageFormat.Emf; break; case "bmp": Format = System.Drawing.Imaging.ImageFormat.Bmp; break; case "png": Format = System.Drawing.Imaging.ImageFormat.Png; break; case "wmf": Format = System.Drawing.Imaging.ImageFormat.Wmf; break; case "gif": Format = System.Drawing.Imaging.ImageFormat.Gif; break; } // img.Image.Save(path + "ResultedImage" + "." + ImageType, Format); } ifImageFound = false; } } }
static void RemovingProtection() { string MyDir = @"Files\"; //Open the desired presentation PresentationEx pTemplate = new PresentationEx(MyDir + "ProtectedSample.pptx"); //ISlide object for accessing the slides in the presentation SlideEx slide = pTemplate.Slides[0]; //IShape object for holding temporary shapes ShapeEx shape; //Traversing through all the slides in presentation for (int slideCount = 0; slideCount < pTemplate.Slides.Count; slideCount++) { slide = pTemplate.Slides[slideCount]; //Travesing through all the shapes in the slides for (int count = 0; count < slide.Shapes.Count; count++) { shape = slide.Shapes[count]; //if shape is autoshape if (shape is AutoShapeEx) { //Type casting to Auto shape and getting auto shape lock AutoShapeEx Ashp = shape as AutoShapeEx; AutoShapeLockEx AutoShapeLock = Ashp.ShapeLock; //Applying shapes locks AutoShapeLock.PositionLocked = false; AutoShapeLock.SelectLocked = false; AutoShapeLock.SizeLocked = false; } //if shape is group shape else if (shape is GroupShapeEx) { //Type casting to group shape and getting group shape lock GroupShapeEx Group = shape as GroupShapeEx; GroupShapeLockEx groupShapeLock = Group.ShapeLock; //Applying shapes locks groupShapeLock.GroupingLocked = false; groupShapeLock.PositionLocked = false; groupShapeLock.SelectLocked = false; groupShapeLock.SizeLocked = false; } //if shape is Connector shape else if (shape is ConnectorEx) { //Type casting to connector shape and getting connector shape lock ConnectorEx Conn = shape as ConnectorEx; ConnectorLockEx ConnLock = Conn.ShapeLock; //Applying shapes locks ConnLock.PositionMove = false; ConnLock.SelectLocked = false; ConnLock.SizeLocked = false; } //if shape is picture frame else if (shape is PictureFrameEx) { //Type casting to pitcture frame shape and getting picture frame shape lock PictureFrameEx Pic = shape as PictureFrameEx; PictureFrameLockEx PicLock = Pic.ShapeLock; //Applying shapes locks PicLock.PositionLocked = false; PicLock.SelectLocked = false; PicLock.SizeLocked = false; } } } //Saving the presentation file pTemplate.Save(MyDir + "RemoveProtectionSample.pptx", Aspose.Slides.Export.SaveFormat.Pptx); }