Asp.net mvc4 quick export of Excel documents using NPOI data processing, mvc4npoi

Asp.net mvc4 quick export of Excel documents using NPOI data processing, mvc4npoi

I. background

In the previous small project, a requirement is that the data entered for an activity should be calculated and exported in the form of an excel table, and the table format requirements are not high.

Ii. Problem Analysis

In view of the fact that the user only needs to export the data in the database to excel, the format is not high, so you only need to add a link on the page, read the data in the background action, and then export it through a third-party component, download it again to meet this simple requirement. First, bing finds the data export component. NPOI is the most frequently popped up component. Here we also need to talk about the method of crystal report used in winform form development, in fact, there are many implementation methods. Since I have never touched NPOI before, I plan to use this open source component in the project.

 

 

3. solution or process

 

 

 

Iv. Summary

I am also using NPOI for more specific operations recently. I will share some of my usage experiences with you later. The functions implemented today are simple. If my ideas and methods are incorrect, please correct me, humbly asking for advice.Reprinted, please indicate the source and source. Thank you for your cooperation.