Can I export a SharePoint 2007 list to an Excel file subdivided into separate worksheets?

Grace Note
  • Can I export a SharePoint 2007 list to an Excel file subdivided into separate worksheets? Grace Note

    We have a SharePoint 2007 deployment which will have a substantially large document library. My client wants the ability to export this library to an Excel spreadsheet, but specifically wants the ability to divide the spreadsheet into several worksheets based on a specific field. Is this possible to accomplish in WSS 3.0, through the object model or otherwise?

    There is a out-of-the-box Export to Spreadsheet, but it does not appear to support automated subdivision of the list items into separate worksheets. I do not know if Excel Services that come with MOSS are capable of it, but we do not have MOSS so we cannot consider it an option for now.

    EDIT

    It seems that by mentioning "out-of-the-box", I am implying that I'd prefer something quick and simple. Let's dispel that. I do a lot of heavy work in the object model. I only mentioned the Export to Spreadsheet because that's the only available method I know of off-hand, and its options are limitted. So I am comfortable with all manner of work level that can be suggested.

    I should also note that keeping the list linked with the spreadsheet is undesired. We want to be able to download the spreadsheet as a reference. Because of the number of people who will be working on the list, it would be absolute chaos to try and synchronize all of the linked files. My client has agreed that it'll be easier to handle obsolete copies than to try some synchronized system.

    The solution also needs to be deployable. So things which do not tailor to an individual site are best.

  • In MOSS there is no out of the box feature that can accomplish this but using Excel Services it should be easy enough to do.

  • I would suggest that you create a couple of Views of the list resembling the Excel Sheets, then add a custom action that uses the Open XML SDK to create your Excel files.

Related questions and answers
  • . Note that this is just opening the Excel file without checking it out. Problem: Once in a while, and for no reason I can figure out, a user will click the button and the spreadsheet will be returned... is causing this behavior? I can change the code to avoid it if I can figure out why it is happening. Is there any way through the SharePoint UI or APIs to "release" the document so that the original...Scenario: We have an internal application that ties Excel spreadsheets stored in a SharePoint doc lib with specific Opportunities in CRM. The user clicks on a button in the Opportunity and a Web

  • I have a two machine set-up, with MOSS 2007 installed on one server (Machine A), and SQL Server 2008 installed on the other (Machine B). In order to run SS Reporting Services in SharePoint integration mode on Machine B, I've read that I need to perform a minimal install of SharePoint on Machine B, and am wondering why. From a couple of error messages I see that it seems like Reporting Services in integration mode makes use of the SharePoint Object Model, but I haven't explored any further. So, purely just out of interest, why is it that I need to have a minimal SP install if my report

  • and they do not work. I have found the code that I can place in the machine.config file that turns off the check, but I would like to figure out what is going on with this. I have ensured that debug is set to false in the web.config file as well. It is only my user controls that are causing the issue, but I do not know why. So it would be nice if there was a list of known .Net assembles that were not FIPS compliant or some way for me to determine what library is calling the offending code. Any ideas, thoughts, insights are welcome! Update: I wanted to point out that my controls are not used

  • with, my customer wants to allow her customers to log in to simply swap files with her. Of course each customer should only see their own files. Also, my customer wants SharePoint to be themed to match her website. Since we're starting off with the basic package I cannot install my own custom WSPs to handle this, instead I have to rely on SPD and out of the box SharePoint functionality. My issue... be overridden automatically (unless I can do it through SPD?). And my final option is to create a doc library for each customer. The issue here is when a customer logs in, how can I display a web part

  • any development experience in Sharepoint I can't really say which ones are going to be imperative for my application. I would like to do it on Foundation, because I can re-sell the app without...I'm about to start developing a custom business application on top of Sharepoint 2010. I haven't done anything on this product but client insists on it so I don't have a choice. Application info I... made, because they're not used in usual applications. Application should be client rich, so I would like to use client libraries like jQuery or even better ExtJS if at all possible. It should

  • This is a very strange issue I am having. My client is experiencing poor performance (20 sec per page load or so) when accessing their SharePoint 2007 site that is hosted somewhere externally... with IE6 from a machine that's not on the client's company network and it's performing well (both authenticated as well as unauthenticated). We have connected to an online WSS team site (out of the box... because these pages are just so tiny. I get the impression that is has something to do with the way IE6 handles Windows Authentication in combination with the proxy used in the client's company network

  • work either. I should be able to do it by more heavily customising the List Definition, but that seems a little over the top and I'm reluctant to do that before ruling out the other options. So...I've been hitting my head against a wall on this one for the last couple of days. I have a pretty simple requirement but I cant see how it can be achieved within a Sandboxed solution. I'm depressed...), then there doesn't seem to be a way to just get a reference to the page, it always wants to overwrite it with a new file. But I dont want to do that, I just want to add a Web Part to the existing page. See my

  • have list of sites and sub-sites with URL's. More details: Let me describe one solution I have now. I’ve found tool Data Juggler (http://www.djuggler.com/) which can automate repetitive web tasks. This means that I’ve prepared list of all sites/sub-sites in my scope. As a source I use spreadsheet with all details about sites/sub-sites input.xlsx this is only one part of process maintained... this database and get list of all users which have access to site mysubdomain.mydomain.com/sites/xyz where xyz is set of sites and to complicate it more, there is also abc which represents sub-sites

  • Using WSS 3.0 running on SBS2008. I have an Infopath form library, to which I have used SharePoint Designer 2007 to attach a custom workflow. It's a pretty normal workflow which updates a property in another list based on a lookup. I have two users, call them Jane and John. Jane is a member of several SP groups, one of which has Full Control permissions. John is a member of a couple of SP groups.../. I have contradictory observations: When John adds an item to the library while working from W2, the workflow is initiated but goes to Stopped status, and the other list is not updated. When John

Data information