SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have custom application page. There are few datepickers, to filter custom list data. When user clicks on Export To Excel ( which is asp:Button ) I need to filter data based on datepickers value, and write it in Excel file, and return file to client. How can I achieve this ? I saw that one of the options is to export SPGridView data to excel, but when I'm using this approach, everytime I'm opening excel file I'm getting warning popup.

share|improve this question
did you find the answer to this question yet?? Let me know if you do.. Thanks – user8141 May 1 '12 at 20:01
I think Michael is referencing this link?… – Kit Menke May 1 '12 at 21:41
@Subbu Hi, yeah I found a workaround, as I did use EPPlus open source project to generate Excel files, the question ( maybe not well formed ) was about how this can be easily done via SP, couldn't find anything so far, that's why didn't update the post. – Michael May 2 '12 at 6:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.