Sharepoint - Display An Excel 2010 Document In A Web Application?
Jul 12, 2010
I am wanting to display an excel 2010 document in an asp.net web application. This document uses the new slicer functionality which I want to be available to the user.I know that excel 2010 docs can be used within sharepoint by inserting a web part which uses exceservices.But can it be achieved without sharepoint? Or can it be achieved using the the excelservices API to get the document from shreapoint and then somehow get it to the browser in .net?
Being new to integrating sharepoint documents into web applications I am struggling with the following task, so anyI have a page in my web application that needs to display a document from sharepoint.I use the appropiate sharepoint web service to get a list of all the documents in the sharepoint list, I then pick out the one I would like to retrieve and get the path to the document so i would end up with something like:
Company%20Hire/Hire%20Site%20Price%20Lists/0.pdf Within our network I can do following: iframePdf.Attributes[ "src"] = ConfigurationManager.AppSettings["SharepointUrl"] + _filePath;
This would display the document in iframe... problem I have is coming from outside the network the sharepoint site can't be accessed (due to firewalls etc). We do have a vpn back to our network on the external server our web application sits on. If i was to use the document url in a browser on the server I am prompted for credentials and then get to view the document.Is there a way for the web application to use the vpn, use credentials i give (e.g through impersonation) to access the document and display it to exernal clients?
Suppose I created a custom web application that consists of: several assembly DLLs: web app, business logic, data services multiple aspx pages and ascx custom controls that use them custom configuration section custom HTTP module. More or less the usual stuff. I would like to deploy it to a particular sharepoint site under a certain subfolder. So if I access my sharepoint site via [URL] (because I'm not using sites/some_site) I'd like my application to be available under [URL]
I could manually add a virtual folder (not application because I would need to access some Sharepoint site's data) to my sharepoint site in IIS and manually edit site's web.config file to register my HTTP module and add my custom configuration section as well either putting my DLLs into GAC or put them in the _app_bin (so I don't have problems with CAS), but I don't think that's a good thing to do, because this web application may get deployed in an environment where this shouldn't/couldn't be possible. So I figured I could build a WSP using Visual Studio 2010 and deploy it that way. But I don't have enough experience doing that.
I created a new sharepoint 2010 project. Is there a way I could add all non-executable application files (aspx, ascx) at once? I've seen the advanced tab of the WSP package where I can add my DLLs either to bin folder or GAC. I don't know whether I would also have to add any safe control and register certain classes?So I suppose I need some pretty detailed and explanatory guidance here.
I am working on a Custom WebPart, for which I need an application page to render a PDF file.
I am currently using following link [URL]
It works fine in ASP.NET, but gives a blank page in SharePoint.
Here's the code:
(PDF file is in same directory) Response.ClearContent(); Response.ClearHeaders(); //Set the appropriate ContentType. Response.ContentType = "Application/pdf"; //Get the physical path to the file. string FilePath = MapPath("Test.pdf"); //Write the file directly to the HTTP content output stream. Response.WriteFile(FilePath); Response.Flush(); Response.End();
In a VB.Net project I use the Adobe PDF Reader (AxAcriPDFLib) control to display a preview of a selected PDF document whereafter the user can double-click upon the selected listbox item to enjoy a full screen view of the relevant PDF document. see the attached sample in this regard. Is there any way to emulate this in ASP.Net?
Following error comes when creating a WebPart In sharePoint 2010 Server.
Web Part Error: Unhandled exception was thrown by the user code wrapper's Execute method in the partial trust app domain: System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.TypeLoadException: Could not load type 'Microsoft.SharePoint.WebControls.SPGridView' from assembly 'Microsoft.SharePoint, Version=14.900.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. at ListMenuSample.ListMenuSample.ListMenuSample.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at Microsoft.SharePoint.UserCode.SPUserCodeWebPartWrapper.ExecuteHttpRequest(SPUserCodeWebPartHttpRequestContext webPartExecutionContext, SPUserCodeWebPartHttpResponse httpRequestResponse) at Microsoft.SharePoint.UserCode.SPUserCodeWebPartWrapper.Execute(SPUserCodeExecutionContext executionContext) at Microsoft.SharePoint.UserCode.SPUserCodeApplicationHostAppDomainRef.Execute(Type userCodeWrapperType, SPUserCodeCachedAssemblyGroup userAssemblyGroup, Guid siteCollectionId, Byte[] binaryUserCodeToken, Byte[] proxyOperationToken, SPUserCodeExecutionContext executionContext)
how to adding a file to the sharepoint document library? I found some articles in net. but i didn't get the complete concept of the same. Now i uploaded a file without metadata by using this code.
[Code]....
This code is working as fine. But i need to upload file with meta data. I created 3 columns in my Document library..
I want to build a custom document management web application that ties in with sharepoint for the actual document versioning and storage. I'm hoping for something like a sharepoint widget that I can plug into my web application that would allow me to tie in with sharepoint and download documents, make edits to them, and upload them back to sharepoint, with sharepoint handling all of the versioning and storage. Basically I'm looking for a sharepoint API. If WSS is the answer to this, are there licensing issues that I need to consider?
I am creating one new silverlight webpart from VS Sharepoint 2010. If i am creating the silverlight application its asking for the sharepoint local site url, i gave the valid url but its showing the ["could not contact sharepoint server for list of document libraries. check your sharepoint URl"].
I am using webclient object to download a file to a windows folder from a sharepoint document library. The credentials I am passing to the webclient object are that of site collection administrator. everything works fine while i test it by uploading a file to the document library. But since the document library is email enabled; when an email is received the file is not transferred to the windows folder. i have put some workflow history events to see which user account is used when the email is received. the user account shown is the network service account. I have given write permissions on the folder to all the users; Everyone, Network service, the site collection administrator user etc. but still i cant figure out what is the problem.
We have created an ASP.NET web app that upload files to WSS Doc Libary. The files get added under 'SYSTEM ACCOUNT' in the library. The FullTextSqlQuery class is used to search the document libary items. But it only searches files that has been uploaded by a windows user account like 'Administrator' and ignores the ones uploaded by 'SYSTEM ACCOUNT'. As a result the search results are empty even though we have the necessary data in the document library. What could be the reason for this? The code is given below:
public static List GetListItemsFromFTSQuery(string searchText) { string docLibUrl = "http://localhost:6666/Articles%20Library/Forms/AllItems.aspx"; List items = new List(); DataTable retResults = new DataTable(); SPSecurity.RunWithElevatedPrivileges(delegate { using (SPSite site = new SPSite(docLibUrl)) { SPWeb CRsite = site.OpenWeb(); SPList ContRep = CRsite.GetListFromUrl(docLibUrl); FullTextSqlQuery fts = new FullTextSqlQuery(site); fts.QueryText = "SELECT Title,ContentType,Path FROM portal..scope() WHERE freetext('" + searchText + "') AND (CONTAINS(Path,'"" + ContRep.RootFolder.ServerRelativeUrl + ""'))"; fts.ResultTypes = ResultType.RelevantResults; fts.RowLimit = 300; if (SPSecurity.AuthenticationMode != System.Web.Configuration.AuthenticationMode.Windows) fts.AuthenticationType = QueryAuthenticationType.PluggableAuthenticatedQuery; else fts.AuthenticationType = QueryAuthenticationType.NtAuthenticatedQuery; ResultTableCollection rtc = fts.Execute(); if (rtc.Count > 0) { using ( ResultTable relevantResults = rtc[ResultType.RelevantResults]) retResults.Load(relevantResults, LoadOption.OverwriteChanges); foreach (DataRow row in retResults.Rows) { if (!row["Path"].ToString().EndsWith(".aspx")) //if (row["ContentType"].ToString() == "Item") { using ( SPSite lookupSite = new SPSite(row["Path"].ToString())) { using (SPWeb web = lookupSite.OpenWeb()) { SPFile file = web.GetFile(row["Path"].ToString()); items.Add(file.Item); } } } } } } //using ends here }); return items; }
I want to export sharepoint list to excel, I also posted question on another sharepoint forum(http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/f890abb6-5558-4e47-925e-e1a026804d58)
When I open an Excel file stored on Sharepoint, I have the option to open it Read Only or in Edit mode. If I open it Read Only, Excel opens up and I see "Server Workbook To modify this workbook, click Edit Workbook". I need to retrieve this Excel file through an ASP.NET application, yet still have this Server Workbook functionality.In fiddler, I see that when opening up in Sharepoint, a POST is made to SharepointSite/_vti_bin/_vti_aut/author.dll with method=getdocument as one of the parameters sent and the filename as another.Do I need to repeat that POST via an ajax call or is there an easier way (as I suspect there is)?
I've searched some FREE Controls, Templates, WebParts, Themes for SharePoint 2010, and its really hard to find good and free examples. Turned back into StackOverFlow and there is no Community Wiki for it. I want to open a Community Wiki about All Free SharePoint 2010 Controls, Templates, Themes, WebParts, etc... to collect them all in one topic.For example, there is a site about MOSS 2010 Free Controls in here. This site containt most MOSS versions controls, web parts. I want SO Users to add most usefull web sites for SharePoint 2010 Developers such as Free controls, themes, tools, etc.
I would like to create and deploy an ASP.NET web form on SharePoint server which can create document in SharePoint list (or library). Since I'm not experienced in both these technologies so would appreciate if someone guides me to the right tool. Should I use Visual Studio or SharePoint designer ? Also, I was reading an article on MSDN about "Deploying ASP.NET Web Applications in the Windows SharePoint Services 3.0 _layouts Folder". Is it the best practise or should I go with webpart/solution based deployment?
I've tried to use Ajax Control Tool Kits on SharePoint 2010 Web Site, but Im having some trouble with registration. I've searched a lot on google for a solution. I've found some ways, but my problem is not solved. When I open my web site, still getting registration error.The problem is registration of Ajax Tool Kit. Here is my steps.1 - Downloaded Ajax Control Tool Kit latest version.2 - Added following line to my page
I am having issues with the AjaxControlToolkit.I started with the 3.5 version and backed up hoping for some love but I am still stuck in quiet desperation trying to meet my impossible deadline.I have changed my masterpage to use the ControlToolkitScriptmanager.System.Web.Extensions references v3.5.0.0 throughout the config.Version of the toolkit referenced in the VS2010 webpart project verified as 3.0.30930.28736
The issue is that no matter what control or extender I try to use I receive the following error:
The base class includes the field '(control/extender name)', but its type (AjaxControlToolkit.(control/extender)) is not compatible with the type of control (AjaxControlToolkit.(control/extender)).
If it would help I would post the entire web.config.If anyone has a working setup with a version of the toolkit I would love to get a copy!I will have to get Silverlight going next.
GAC:Microsoft (R) .NET Global Assembly Cache Utility.Version 4.0.30319.1 Copyright (c) Microsoft Corporation.All rights reserved. The Global Assembly Cache contains the following assemblies: ajaxcontroltoolkit, Version=3.0.30930.28736, Culture=neutral, PublicKeyToken=28f01b0e84b6d53e, processorArchitecture=MSIL
Number of items = 1 -- MasterPage (excerpt): <%@ Register TagPrefix="asp" Namespace="AjaxControlToolkit" Assembly="AjaxControlToolkit, Version=3.0.30930.28736, Culture=neutral, PublicKeyToken=28f01b0e84b6d53e" %>
[code]...
Environment:Visual Studio 2010 SharePoint 2010 (clean install) Windows Server 2008R2
As part of our branding of Sharepoint 2010, we'll be modifying some custom HTML menu's based on database and user permissions.
To do this, we are looking at the use of code-behind in a custom Sharepoint 2010 master page.
The only reference I can find to creating a code-behind file for sharepoint 2010 is this blog post series. The issue I have with this is that it's using the Visual Studio 2010 Sharepoint integration, which has the genius feature of requiring a local instance of an entire Sharepoint site. This isn't something that I can do/get.
This is the MSDN for code-behind master pages in Sharepoint 2007. I'm assuming it's similar but I can't find anywhere that describes it as such.
Is deploying a code-behind for a custom master page the same as in Sharepoint 2007 or does anyone have any experience doing this?
I have the following code which works well on my local machine, but when I deploy it to Sharepoint 2010 the jquery doesnt work... the calender control doesnt pop up when the web page is added to Sharepoint.