Actionsmenu export to excel feature not working in a toolbar added to dataformwebpart

Question

Hey all,
I'm stuck with a very annoying problem i hope you guys can help me with...

I've built a custom ASPX page with a DataFormWebPart that shows a sharepoint list as HTML table.

I wish to add to the top of it the default "actions" menu of sharepoint (export to excel etc)

I've added the menu using:

<SharePoint:ActionsMenu ID="aMenu1" runat="server" />

The menu seems to work ok but the export to Excel function fails, Excel just comes up with "unknown error".

I started to dig into the iqy file and saw where my problem is:
the View part of the iqy is all zeros... when i pasted from the original iqy file (the one i saved from using the list's regular view export to Excel feature) the numbers that represent the view my file worked fine.

How can i pass this information to my export to Excel feature of my dataformwebpart toolbar?

Thanks for any kind of help :)

Answer 1

I also faced this problem but no solution found for this yet. I know the reason for this failure.

Export to Spreadsheet action being on by taking ListID and ViewID values. But, from the DataView/DataForm webparts, "Export to Spreadsheet" is passing the list id but failing to pass viewid and passing id with ZEROS. You can see this information when you open owssvr.iqy file in notepage.