Export Data to Excel

Results 1 to 2 of 2

Thread: Export Data to Excel

  1. #1
    Join Date
    Dec 1969

    Default Export Data to Excel

    I created a Web App using vb.net and on one of my forms I show data from a SQL database. I am able to export the data to an Excel file on the server by using a line like:<BR><BR>xlApp.SaveAs("C:filename.xls")<BR><BR >But what I need to do is give the user the ability to export this data to an Excel file and save it on his computer. <BR>So when the user clicks on the "Export to Excel" button I added to the form, it should prompt for a file name and location (on the user&#039;s computer). <BR>I&#039;m new to programming and I have no idea how to do this. Any help will be greatly appreciated. <BR>

  2. #2
    Join Date
    Dec 1969

    Default You can't do it

    You have to save it on the server and let them download it to their computer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts