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
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
0
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
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
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
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
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 >>
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
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.
Thanks.
0
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
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 >>
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
Rank 1
answered on 16 Feb 2017, 02:37 PM
Please include the image insert feature plus Macro if possible.
0
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
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.