locked
how to export data from datatable to Excel and save in solution explorer RRS feed

  • Question

  • Please provide solution to this how to export data from datatable to Excel and save in solution explorer
    Friday, October 31, 2014 12:03 PM

Answers

  • Solution Explorer?  So you're trying to get data from a database into Excel so you can save the generated XLSX file as part of your solution.  This one would be a one time thing so why don't you simply use Excel's ability to query data from a database to generate the XLSX file.  Then you save the resulting data. 

    This seems like it is more of an end user question for Office than a development question.

    Michael Taylor
    http://blogs.msmvps.com/p3net

    • Marked as answer by Fred Bao Monday, November 10, 2014 1:40 AM
    Friday, October 31, 2014 5:54 PM