So long story short, I am creating an multiple applications that all link together to form a PowerPivot slide show. My first app is a Windows form application that takes any LOCALLY stored excel workbooks, iterates through each workbook (and its containing worksheets) and creates a .jpg image file from the PowerPivot graphs within.
I have a second, ASP.NET, program that then takes the newly saved pictures, and begins a slide show using a Java script. The images from the first program are saved into a predetermined folder that this finds and uses. Although both programs are separate entities, they come together to form what we need.
I am a COOP student doing this for my employer, they have Excel dashboards powered by PowerPivot for sales/statistical analysis that are powered by SQL databases.
For testing purposes, I simply saved a few workbooks into the local directory of the first program. But now comes the hard part...I need to retrieve these excel dashboards from a SharePoint 2010 server. This way the images that are created and saved are always recent and updated, versus saving them locally and hope they dont ever change... I have seen a few examples of people accessing sharepoint in an ASP.NET way, but each example looks DRASTICALLY different. Is it possible to create a windows form application that could reach into Sharepoint databases and save those excel files locally?
Im not sure how i am able, if at all, to combine these different programs into one. Both i have now are c# programs made in visual studio 2010. But if i am not able to connect these, then the flow would be:
Program #1: Save files FROM sharepoint (code/help needed)
Program #2: Iterate and create images from files
Program #3: Slideshow of images
Im not very familiar with sharepoint, maybe there is an easier non-programming way to have these excel files synced and saved into a local directory?
Any help would be greatly appreciated!
