Last post Aug 13, 2017 02:52 PM by markfitzme
Aug 11, 2017 02:58 PM|Asp.net Learning|LINK
I want to excel export with asp.net webform. But I'm searching excel export. Result always with gridview to excel. But i dont want this. Because each report each page and gridview .
Which one ı need to use? Openxml, Crystal Report. Asp.net report wizard,Interop Excel 16 etc. I dont understand.
I need this page. Select Report (Dropdownlist 1.All students, 2 all teachers,) and select year and create report. and report preparing save the server. not waiting button click finish event . report preparing background. and finish user select listview last
report and download. So, how to desing on the report? Example add the company logo or 1.header company name etc. ?
I hope your understand.
Thanks in advance
Aug 11, 2017 08:16 PM|jzero|LINK
Suggest you try ClosedXML https://github.com/ClosedXML/ClosedXML,
It just simplify the use of Openxml, so it is Openxml dependent.
On the other hand, how to format your report, you have to construct everything on code.
Aug 12, 2017 06:11 AM|Eric Du|LINK
Hi Asp.net learning,
After read your description of your issue, I'm not too clear about your meaning. What control need to export? which one need to use that depend on your needs or if you don't know how to design your report? Hope you could describe your issue in detail.
Here are some tutorials about how to export the crystal export and how to design the SSRS, please check:
Export Crystal Report on Button Click to Word Excel PDF and CSV in ASP.Net:
Creating a Custom Report Template in SSRS:
Aug 13, 2017 02:52 PM|markfitzme|LINK
OpenXML is supported by Microsoft and is a good option if you need Office 2007 and alter support. It does not support earlier versions.
Interop is a bad idea as it requires a licensed copy of MS Excel to be installed on the server. Office products were never designed to be used in this way so it's also a bad idea, and many web hosts won't even allow this on a server.
Crystal Report has it's own licensing and can also be a pain
Using a component like OpenXML is a good choice since it provides the ability to create a file. You have a lot of control over the process, but it can be rather tedious since you are handling all aspects of file creation.