Click here to Skip to main content
15,895,084 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hey i want to create a web page application where in I want to generate a graph in asp.net page using the data from excel sheet. The generated graph must then be exported to pdf and word.
Anyone plz share code and help.

Thanks
Posted
Comments
Sergey Alexandrovich Kryukov 23-Apr-13 0:11am    
There is nothing impossible in this problem, but it does not look like a question. Rather, this is the request to make some work for you. Which part if this brilliant plan presents some doubts?
—SA

You can implement both Excel and Word functionality using Open XML SDK:
http://www.microsoft.com/en-us/download/details.aspx?id=30425[^].

This way, you can support new XML-based Office formats (such as .DOCX, .XLSX), ECMA-376 standard:
http://en.wikipedia.org/wiki/Microsoft_Office_XML_formats[^],
http://en.wikipedia.org/wiki/Office_Open_XML[^].

This way, you can work without Office installed. Also, the documents are supported by 3rd-party software. Please see my past answers:
Convert Office-Documents to PDF without interop[^],
Need a rather unique WPF text editor control[^],
Hi how can i display word file in windows application using c#.net[^],
Read a word file without using Interop.word dll...Do not want to install word in IIS..[^].

This is another option: http://npoi.codeplex.com/[^].

Another option is to use Office Interop assemblies, but it will require installed Office components on the target computer.

And, finally, when you manage to get data from Office documents, you can map it onto PDF structure. To produce PDF itself, you can really use the .NET port of iText; this port is called iTextSharp:
http://en.wikipedia.org/wiki/IText[^],
http://itextpdf.com/[^],
http://sourceforge.net/projects/itextsharp/[^].

I provided links to iText, too, because nearly all documentation you need to work with iTextSharp is there, provided as Java documentation.

—SA
 
Share this answer
 
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900