how to retrieve data from sql into the excel

Question

User-1634604574 posted

i want to retrieve data from sql into the excel how can i do it?

Answer 1

User269602965 posted

Prepare a query, connect to the database (Oracle, MSSQL, MySQL, others), open a data reader, then with the dataset you create, there are many ways to get the date moved to an Excel data grid window in a web page or WPF/WINFORM application, or into an Excel file.

If you are doing this regularly, you can use full featured licensed Excel libraries like Spreadsheet Gear or Progress (aka Telerik), or on budget get open source libraries (google there are many), or for just get it done … .NET OPEN XML SDK. 

Uses: quick reports like nightly audits and counts, user on screen reports of sales, generating portable datasets like customer contact lists, and many other uses.  Of course EXCEL has limitations in size of the data and rows exported.

There is a bit of a learning curve, some experimentation to get the right look in your XLS sheet.

Answer 2

User1520731567 posted

Hi [e-mail],

i want to retrieve data from sql into the excel how can i do it?

You could use plugins to export data to excel.

The DataTable is exported and downloaded as Microsoft Excel file using ClosedXML Excel Library which is a wrapper for OpenXml Excel library:

https://www.aspsnippets.com/Articles/ClosedXML-MVC-Example-Export-to-Excel-using-ClosedXML-in-ASPNet-MVC.aspx

https://www.codeproject.com/Tips/1107815/Export-an-Excel-File-using-ClosedXML

Export table to Excel file using Angularjs in asp.net MVC:

http://www.aspmantra.com/2017/03/export-table-to-excel-file-using.html

Best Regards.

Yuki Tao