Powerpoint Interop C# Paste Keep Source Formatting

Question

Hi,

I am using PowerPoint Interop (C# language) to copy Excel content to PowerPoint. 

var resultRange = templateExcelWorksheet.UsedRange;

resultRange.Copy();

pptSlide.Shapes.Paste();

I want to keep Source Formatting (i.e. Excel format) in PowerPoint Slide as well. How can I do it through program in C#.

Answer 1

Have you tried using:

Globals.ThisAddIn.Application.CommandBars.ExecuteMso("PasteSourceFormatting");instead of:pptSlide.Shapes.Paste();

Answer 2

Don't use the clipboard then. Use the AddOLEObject method but this requires that the file  being embedded be present on disk.

Answer 3

Have you tried using:

Globals.ThisAddIn.Application.CommandBars.ExecuteMso("PasteSourceFormatting");instead of:pptSlide.Shapes.Paste();

I tried

pptApp.CommandBars.ExecuteMso("PasteSourceFormatting"); 

and it worked.

But only if PowerPoint is visible in window; open presentation with Window.

presentation = pptApp.Presentations.Open(reportFilePath, WithWindow: Microsoft.Office.Core.MsoTriState.msoTrue);

Is there a way, I can keep PowerPoint invisible and still perform similar action.