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.

  • 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.