This is a migrated thread and some comments may be shown as answers.

Add Image to Cell

7 Answers 91 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Peter
Top achievements
Rank 1
Peter asked on 13 Jun 2013, 02:55 PM
I am using the Workbook class from Telerik.Windows.Documents.Spreadsheet.Model to export a RadGridView to a XLSX file.

I need to be able to add an image to a cell in the exported XLSX file.

I have been able to add a new worksheet and even insert ICellValues as desired; however. the ICellValues interface and the defined CellValueTypes are all using string values for the data.  I tried using ToString() on the BitmapImage but as expected this simply displayed the class type string when exported.  I tried converting the BitmapImage to Base64 but just got the Base64 text.

Looking at a few of the other libraries that allow for XLSX file exporting, their WorkBook classes have a Pictures collection that can be used but that is not the case with your Workbook class at this time.  Do you have another method for adding a picture to a cell at this time?  If not, do you intend on adding that functionality in the not too distant future?

Peter

7 Answers, 1 is accepted

Sort by
0
Andrew
Telerik team
answered on 18 Jun 2013, 01:48 PM
Hello Peter,

For the time being RadSpradsheet does not support images. We realize it is an important feature and we have included it in our future plans. However, a specific time frame cannot be given of when that feature will be implemented.

Regards,
Andrew
Telerik

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

0
Charles Benoualid
Top achievements
Rank 1
answered on 27 Jun 2013, 01:04 PM
We also require this feature in our company. Without it, i will have to use another way to export... Image export is very important for products in any system...
0
Andrew
Telerik team
answered on 03 Jul 2013, 11:13 AM
Hi Charles,

Thank you for your feedback. However, as mentioned in the previous reply, currently this feature is not scheduled.

Our RadGridView control do support showing images, you can check our online demo and documentation. You could modify the built-in Export() and display them in browser, but not into excel. 

Regards,
Andrew
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>
0
Sergio
Top achievements
Rank 1
answered on 28 Nov 2013, 09:19 PM
For my company is very improtant this issue, we have implemented this control (Spreadsheet) and have noticed that the images (company images) do not appear in the reports, has already been allocated in the scheduler this issue?, Would be helpful for us.

Thanks.
0
Dimitrina
Telerik team
answered on 29 Nov 2013, 06:50 AM
Hello,

We have included the feature of exporting images in our future plans.

Currently I can suggest you to check the Telerik Reporting product.

Regards,
Didie
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>
0
Wei
Top achievements
Rank 1
answered on 16 Feb 2017, 02:37 PM
Please include the image insert feature plus Macro if possible.
0
Stefan Nenchev
Telerik team
answered on 21 Feb 2017, 09:13 AM
Hello Wei,

The RadSpreadProcessing library supports the export of images. The functionality, however, is not supported out of the box when exporting a RadGridView. You can utilize the ExportToWorkBook method and modify the WorkBook/Worksheet so that the functionality is achieved.

Regards,
Stefan Nenchev
Telerik by Progress
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Spreadsheet
Asked by
Peter
Top achievements
Rank 1
Answers by
Andrew
Telerik team
Charles Benoualid
Top achievements
Rank 1
Sergio
Top achievements
Rank 1
Dimitrina
Telerik team
Wei
Top achievements
Rank 1
Stefan Nenchev
Telerik team
Share this question
or