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

May I ask how to create a button that function like the 'Export to Spreadsheet' (shown in the picture) on a ASPX file using SharePoint 2007 Designer?

enter image description here

share|improve this question

1 Answer 1

up vote 1 down vote accepted

The below link should help you. You just need to build the appropriate URL for the excel export.

http://www.sharepointkings.com/2009/12/creating-export-to-excel-link-in.html

share|improve this answer
    
I notice that it will come as a file - iqy format and not xls or xlsx file format. Is it possible to make it come as a xls or xlsx file format? –  Larry Morries Oct 14 '11 at 8:48
    
The reason is because iqy file contain some sensitive information that I do not want the user to know it. (Unless there is a way to hide those information) –  Larry Morries Oct 14 '11 at 9:03
    
That is how the export function works. The calls that it makes actually query SharePoint so that when saved it can always refresh later should the SharePoint data change. It is possible to write code that does similar stuff, but it can get complex depending on what you want. –  spevilgenius Oct 14 '11 at 10:14

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.