MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

CrossList rollup content -> Excel ??

  Asked By: Jenny    Date: Mar 03    Category: MOSS    Views: 1244

Does anyone know how or have example of how to get the content rolled up by a
CrossList query into Excel (MOSS)? I've surfed for 2 days - no luck.

I've thought of
a) couple a CrossList query to a LVWP since the latter has an "export to Excel"
action button, or
b) push the CrossList content into a existing list, and then use LVWP, or
c) use owssvr to push to Excel, but I cannot control where owssvr gets its
d) other ???



2 Answers Found

Answer #1    Answered By: Araceli Eaton     Answered On: Mar 03

One possibility which I successfully tested recently is to use the Office Web
Components. I created a dataform web part in SharePoint Designer that got the
data I wanted. I added a spreadsheet control  to the page. I then hacked the xslt
of the dataform so that instead of outputting html, it output JavaScript that
pushed the data into the spreadsheet. This creates a spreadsheet embedded in the
page, and it has an "export to Excel" button  in the toolbar. (Note that it is
possible to make the dataform do a cross list query  by hacking the datasource

The office web components are no longer being updated, but the Office 2003 ones
are still supported with Office 2007. The main drawbacks are that they need to
be installed on the client desktop for this to work, and they will only work in
IE. However, you don't need the client to be licensed for Office if you set the
properties of the component to read-only.

An alternative I thought  of would be to hack the dataform to output XML
spreadsheet data into an iFrame on the page to load Excel, but my attempts to
get this to work failed, often crashing SharePoint Designer. I couldn't even get
it to work with simple hard coded data.

Answer #2    Answered By: Nisarg Kapadia     Answered On: Mar 03

if you are willing to spend, check the kwizcom product


Didn't find what you were looking for? Find more on CrossList rollup content -> Excel ?? Or get search suggestion and latest updates.