Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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? fivenumber.com/… –  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.