We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Copy table from Excel having conditional formatting to PowerPoint presentation

Thread ID:

Created:

Updated:

Platform:

Replies:

131341 Jul 5,2017 01:58 PM Jul 6,2017 12:45 PM ASP.NET MVC 4
loading
Tags: Presentation
Gustavo Leal
Asked On July 5, 2017 01:58 PM

Hello, I hope someone can help me. 

I have a request to copy and paste a table from Excel, the problem is that the table have a conditional formatting (icon sets) but when I copy the table the final result is that the icons are missing.

There is a way to copy the table without miss the icons?

Thanks in advance

Ramaraj Marimuthu [Syncfusion]
Replied On July 6, 2017 09:53 AM

Hi Gustavo,

Thanks for contacting Syncfusion support.

If your requirement is to copy and paste a table from excel file to the PowerPoint file using Microsoft Office application, you can use paste options as mentioned below.




 
Options 
Usages 
Use Destination Styles (S) 
Keep the destination style of the table 
Keep Source Formatting (K) 
Keep the source formatting of the table 
Embed (E) 
Embed the source excel sheet with the pasted table.  
Picture (U) 
Pasted a screenshot of the table 
Keep Text Only (T) 
Keeps the text with in the table 
 
By copying a table from excel and pasting to PowerPoint using paste option embed, the conditional formatting icon sets will be preserved in the PowerPoint file. You can also use paste option picture to preserve the table as screenshot.

If your requirement is to copy and paste a table from excel file to the PowerPoint file using Syncfusion XlsIO and Presentation libraries. Then kindly try the attached sample. This sample inserts the excel file as an Ole object to PowerPoint presentation using Syncfusion libraries.

Please let us know if you have any questions.

Regards,

Ramaraj Marimuthu.
 


Ramaraj Marimuthu [Syncfusion]
Replied On July 6, 2017 09:59 AM

Hi Gustavo,

Please find the sample from below link,

Sample
 

Please let us know if you have any questions.

Regards,

Ramaraj Marimuthu.
 


Gustavo Leal
Replied On July 6, 2017 10:20 AM

Hi Ramaraj, First of all thank you for your response.

Is not using Excel application is using Syncfusion XlsIO and Presentation libraries. I will give you my feedback regarding to the Sample project once check it.

Thank you again, Regards

Gustavo Leal


Gustavo Leal
Replied On July 6, 2017 12:45 PM

Hi Ramaraj,

It worked like a charm.

Thanks

Gustavo Leal


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;