How to put image in Export to MS Excel

Posted by Vishnupavadi under ASP.NET on 8/11/2014 | Points: 10 | Views : 762 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Guys,
My requirement -
Once click on "Generate Report" button. In background work - it has to generate some data & according to the data we have to create Pie Chart (on graph or image).
We have to export those data and pie chart ( chart or graph or image) to Excel and have to send via email.

Currently -
I can only able to export data to excel sheet. But I want to put pie chart graph / image to excel along with data.

Here my request -
Please let me know how to create Pie Chart & put it into(export) Excel. I searched a lot, there is no way to put data or graph / image into excel.

I don't want to use any third party control or dll.

for the reference, please check the attached requirement, illustration included.

Please help me out...

Thanks in advance.

Attachment

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Yesi on: 12/26/2014 [Member] Starter | Points: 25

0	Solution1 : This article compares how to create a pie chart using Office Automation and VSTO to using Aspose.Cells for .NET. http://www.aspose.com/docs/display/cellsnet/Create+a+Pie+Chart The code samples in this article show how to add a pie chart with VSTO, using either C# or Visual Basic, compared to creating one with Aspose.Cells, again using either C# or Visual Basic. Solution 2: Use free interface software http://www.nuget.org/packages/Spire.BarCode/ for .NET. You can export any bar with it easily. Vishnupavadi, if this helps please login to Mark As Answer. \| Alert Moderator

Solution1 :
This article compares how to create a pie chart using Office Automation and VSTO to using Aspose.Cells for .NET.

http://www.aspose.com/docs/display/cellsnet/Create+a+Pie+Chart
The code samples in this article show how to add a pie chart with VSTO, using either C# or Visual Basic, compared to creating one with Aspose.Cells, again using either C# or Visual Basic.
Solution 2:
Use free interface software http://www.nuget.org/packages/Spire.BarCode/ for .NET.

You can export any bar with it easily.

Vishnupavadi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sheonarayan on: 12/26/2014 [Administrator] HonoraryPlatinum | Points: 25

0	Read this article http://www.dotnetfunda.com/articles/show/920/export-text-along-with-image-into-ms-excel-file that describe how to export text along with image to MS Excel. Before exporting the graph, you can create an image for that graph and export on the excel sheet. Hope this will give some clue. Regards, Sheo Narayan http://www.dotnetfunda.com Vishnupavadi, if this helps please login to Mark As Answer. \| Alert Moderator

Read this article http://www.dotnetfunda.com/articles/show/920/export-text-along-with-image-into-ms-excel-file that describe how to export text along with image to MS Excel. Before exporting the graph, you can create an image for that graph and export on the excel sheet.

Hope this will give some clue.

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Vishnupavadi, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts