In this example, we will be exporting the list of the students in both " CSV" and Excel formats. The " GetStudents" method returns a " DataTable" containing a list of randomly generated students. ( new DataColumn( " Score", Type.GetType( " System.Int32"))) ĭata = " Student Name No." + i.ToString() ĭata = 60 + ( int)(rand.NextDouble() * 40) ( " Enrollment", Type.GetType( " System.DateTime"))) ( new DataColumn( " Name", Type.GetType( " System.String"))) ( new DataColumn( " ID", Type.GetType( " System.Int32"))) The application's data model is implemented in the " Models\StudentRepository.cs" file:
#Excel tabular form how to
At last, I will show you how to use the utility classes to expose "CSV" and Excel files to the web browsers.
In this article, I will first introduce the data model and then introduce the two utility classes. To create an excel " xlsx" file, this article uses the " OpenXML SDK 2.0". The " Default.htm" file is the web interface that triggers the download of the files generated by the utility classes.The data files are exported from the "MVC" controller implemented in the " Controllers\HomeController.cs" file.The " ExcelUtilities\ExcelUtility.cs" file implements an utility class to help exporting the data in excel format.The " ExcelUtilities\CSVUtility.cs" file implements an utility class to help exporting the data in "CSV" format.The " Models\StudentRepository.cs" file implements the application's data model.The attached Visual Studio 2010 solution is a simplified "MVC" web application. If you are new to "MVC", this is a good reference link. This example uses some " MVC" functions to expose the generated files to web browsers, I would assume the readers have some basic web application development experience using "MVC". This article is to present an example to export the data in both CSV and excel (xlsx) formats. BackgroundĪ common task when developing web applications is to export some tabular data to a file that can be opened by Microsoft Excel. This article presents an example to export tabular data through the web in " CSV" as well as " Excel" formats.
0 kommentar(er)
