.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

ms excel in Web browser

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Windows Application

I used the following link for help in my windows 7 and use it manually 



eg the method given for "Let Me fix Myself"

Here is used for accessing the files



View Complete Post

More Related Resource Links

SharPoint 2010 : Open word and excel documents within Browser without installing office Web App on S

guys, SharePoint 2010 how can i have the word documents and excel sheets open up with in the browse windows without installing Office Web App on the server, all i want to give users is the read access. Also i did not install anyting on sharepoint server to have pdf open up in the browser and yet it does. thanks in advance. sameer   thanks sameer

How to open a word document,excel sheet in web browser?

I want to upload a word document and excel document and then i want to view that document on the browser itself using asp.net and c#. How i can do this. Please send me proper code and explanation if possible.

Excel does not open in the browser even after office web is installed and integrated with sharepoint


guys, i have installed and configured office web apps with sharepoint 2010 after which i

a.  i created SA instances for excel , word viewing and powerpoint,

b. activated office web feature and deactivated "opening in the client application" feature

now word opens up fine in the browser but excel still opens in the client application, any suggestions?




Named Set working in excel but not in Browser....



I have a problem in the named sets.

I have a dimension with 6 levels and I have to calculate the standard deviation for each level, only for the siblings. I used Siblings to calculate the stdevp but it was not working with the filter, So i had to use named sets.

The problem is, this calculation is working fine in the Excel, even with the filter, but in the SSAS browser, filter is not working. Could anyone please suggest me the solution for this, or to calculate stdevp for siblings with some other way, that should work for the filters also(Filter here should be on the same dimension for which the stdevp is being calculated)?.

here are my calculations:

Named Sets:


[LEVEL2] : [DIM_A].[A].[LEVEL2].

Excel "View in browser" or "Edit in browser": Unexcpected Exception


Hey everybody

We are using Sharepoint 2010 (Enterprise), Office web apps is installed.

Powerpoint & Word web apps work (view or edit in browser).
When we click on an excel 2003 file we recieve the open in excel dialog (read-only / edit).

Wen we click on an excel 2007 file we get an unexpected exception.

I used the ULS viewer and the correlation id to retrieve the stack trace below:
System.NullReferenceException: Object reference not set to an instance of an object.  
 at Microsoft.Office.Excel.WebUI.XlViewer.OnInit(EventArgs e)   
 at System.Web.UI.Control.InitRecursive(Control namingContainer)   
 at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Exception follows on the heels of:
Name=Request (GET:http://bekrbsv313:80/sites/medical/_layouts/xlviewer.aspx?id=/sites/medical/Scrum/Sprint.xlsx&Source=http%3A%2F%2Fbekrbsv313%2Fsites%2Fmedical%2FScrum%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1)

does anybody have a clue?

I'm getting desperate :-)

Client need to open auditing reports in excel application not in browser


Good day,
I encountered with this issue in MOSS 2007. Auditing reports was opened from common SharePoint auditing page.
This page contains hyperlinks to auditing reports.
When any user tries to open this hyperlink, "open file" dialog does not appear, instead of this a IE browser silently open in text XML format.
I suppose that common behaviour is when user open a hyperlink, report will open with excel application through "open file" dialog.
For example, hyperlink in SharePoint contains URL:

MDX Root()-function: different results in Cube Browser and Excel


I try to write a calculated member that returns the percentage of total (but independent from the chosen dimensions). So i started with the included template "Percentage of total".

When i use the measure in my cube browser, it works so far, but not when i use the measure in excel client.

The problem is the root-function. When i place my dimension in the rows-section and deselect some members in the filter-window, the root-function isn't influenced by the filter in excel. When i browse the cube in SSMS it gives the correct result, because the filter is applied to it.

You can reconstruct the problem very easily by adding this measure: "Root([Dimension Name]),[Measures].[Measure Name]"

This is a big problem in my case, because i absolutely need a grand total, that uses the filter-selections.

I already spent days to find a way, how to write e calculated measure, that just gives me the grand total according to the filter and which i can use with different dimensions. Or is there any way to access the calculated grand total cell in MDX? I can't believe that my problem is so difficult to solve.

Please help me out!


Cannot refresh OLAP-based data in Excel Services workbook in browser (SP 2010 / Project Server 2010)



In SharePoint 2010, Project Server 2010, Business Intelligence Center, upon attempting to refresh OLAP data in an Excel chart in the browser, the following error appears:

An error occurred during an attempt to establish a connection to the external data source.  The following connections failed to refresh:

My ODC Connection Name

We have loaded and configured Project Server 2010 according to spec (http://technet.microsoft.com/en-us/library/ee662109.aspx).  Excel Services is configured according to spec (global settings, trusted file locations, trusted data providers and trusted data connection libraries).  The Secure Store Service is configured with the ProjectServerApplication target application. 

Non-OLAP data refreshes of spreadsheet data work fine in the browser.  OLAP data refreshes in the Excel client itself work fine.  Only the OLAP refreshes in the browser fail.  The problem occurs whether using a Microsoft ODC or one that we created (saved in a trusted location).

The ULS log has only one error, which is:

06/21/2010 13:47:17.86  w3wp.exe (0x1238)               &

How to make Excel open in application not browser by default


I'm facing a problem here. I tried the to open an excel file (.xls) which was attached in a Calendar Item.

On 1 PC, it opens automatically with the Excel application and thus the user is able to edit and save.
On another PC, it opens in the browser and the user is unable to edit / save the file.

Initially, I tried and thought that it's user rights issue but apparantly, it is not.

How can I make the .xls to open in excel by default? Can someone help me?

Really appreciate the help and answers.


Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

Excel Automation in .Net

Excel Automation is a buzz word in both webapps and winapps. In the programming life (like Mr.Anderson neo) I guess almost every one could have come across this word. For others let me go further in detail. Excel Automation is automating some or all of the process involved in creating or updating excel worsheets.

display data into GridView from excel sheet

I have to display data from excel sheet into my gridview and also I need to figure out a way to store data into excel files from my web page. I am using C# 3.5, VS 2008.

Export SharePoint List to Excel Spreadsheet Programmatically using C#

In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.

Creating an Excel Spreadsheet programmatically using VB.NET

The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel. This article reveals using Excel from a managed application. Excel is the spreadsheet component of Microsoft Office 2000. The majority of Excel programmatic functionality is exposed through Automation via the type library Excel9.olb. The intention of this article is to express that a managed application can interrelate with Excel as a COM server.

Create And Run Excel Macro At Runtime in C#

You've been tasked with writing a Windows Form application using the .NET Framework that interacts with Microsoft Excel. If you are new to working with Excel in .NET and are having trouble learning how to format certain cells or cell ranges, then this little tip will come in handy. Rather than scour the internet hoping to find the correct set of constants or method syntax for formatting your spreadsheet, use the built in tools in Excel to write the familiar VBA code for you. Then, you can paste the VBA code generated by Excel into the sample C# code below and run it dynamically at runtime.

Creating an Excel Spreadsheet and Adding Data to It Programmatically

The Interoperability services make it veryeasy to work with COM Capable Applications such as Word and Excel. Thisarticle reveals using Excel from a managed application. Excel is thespreadsheet component of Microsoft Office 2000. The majority of Excelprogrammatic functionality is exposed through Automation via the typelibrary Excel9.olb. The intention of this article is to express that amanaged application can interrelate with Excel as a COM server.

Creating Excel file from C#

I used below coding for create a excel sheet.I got from on web site.
In below coding there is no problem.Its create the excel file.If i run second time,its ask to overwrite the current excel file.If I said "Yes" then it ok ,but If I select cancel button,its generate the Error message.The exception is
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend