Skip to main content

How to use Mobile Entree Excel Addin in SharePoint 2010

Description: In this article I will just explain how to use Mobile Entree Excel Addin (SharePoint BI)  in SharePoint 2010 with sample example.

Install Excel Add: To install the Excel AddIn go to the site, click on Mobile Entree Configuration->Global Config

MobileEntree1.gif

Excel Addin: After installation of Mobile Entree AddIn, we will get an option in Excel under "Insert" section named "Mobile View Configuration". This AddIn will help you to set a view when we open Excel in a mobile browser.

MobileEntree2.gif

Following are the steps for creating Mobile view in Excel:

Step 1. Create New DashBoard. Give it a name such as "My Dashboard".

MobileEntree3.gif

Step 2: Create "New Mobile Cell Range" for displaying the Excel selected column in Tabular format. Drag Cell to select Range.

MobileEntree4.gif

It will come automatically on popup window.

MobileEntree5.gif

Give some title name like "Content Approval".

MobileEntree6.gif

Step 3: Create Chart to see the data in a graphical View. Before using the mobile entree tool, first create Excel chart and then click on "New Mobile Chart". From the popup window, select the chart. Here I have "chart1". Give some title name like "Graphical representation.

MobileEntree7.gif

Step 4: Final Chart will look like below.

MobileEntree8.gif

After the Mobile View Configuration, upload the Excel file to the sharepoint library so that you can access that library inside the sharepoint site. I uploaded my "approval.xls" as a Shared Document.

Follow the steps below for Configuring Excel in Mobile browser:

Step 1: Create  MDS viewer application

MobileEntree9.gif

After saving, the application will be ready and will be available for Application configuration.

MobileEntree10.gif

Step 2: Click on Custom MDS View Configuration settings; select the Excel file that we have already uploaded to the document library. Set the view like "My Dashboard".

MobileEntree11.gif

Step 3: Save the settings. Now everything is now ready.

Step 4: Open the mobile browser; click "Custom MDS Viewer" under "Application1" section.

MobileEntree12.gif

Step 5: The final Output will look like below.

MobileEntree13.gif

Very few articles are available in the web on this subject so I hope it will help you. Like this article if you found it helpful.

Comments

Popular posts from this blog

SharePoint Branding Solution Pack using VS2010

Introduction Today, in this blog I am trying to provide you the Custom Branding solution Pack. This solution pack will save time and effort while developing the custom sharepoint with publishing sites in sharepoint. It works great. So, we all are good to go and use this re-usable solution pack. Description The source code shows how to prepare a structure for Sharepoint Branding solution. This pack contains : Master Page Gallery structure Page Layout Gallery structure Image Gallery Styles Library gallery Event Receiver

Consistent SharePoint 2010 branding for Mobile browsers

Through this article I am going demonstrate you how to make consistent UI in sharepoint2010 in different mobile browsers. My mates every time asking me why we need to involve mobile device with SharePoint. Through this article I am just giving the sample where I am showing why we are slowly moving to mobiles from PC. While giving demo on "SharePoint on mobile" to client I found below things: Client want everything on their hand, means on mobile (Bcoz of busy schedule no time to open laptop/system) Client doesn't want to compromise with UI. Application should as simple and easy to use. Application should be scalable and easy to extend in future. Out of all four, below three is already provided by SharePoint. SharePoint is lacking somewhat in First point.  But as I said we developer can do anything so here we can do the same "We will bind the SharePoint without breaking SharePoint Rules". I am using safari browser for the demonstration because thro

Create Custom hit counter in SharePoint2010 using Sandbox Solution

In this blog I am going to demonstrate how to create Hit counter for SharePoint site with user details using sandbox solution. I took reference from codeplex code( http://hitcounter.codeplex.com ) which is sharepoint2007. I modified his sample and tried make it simple and easy for you. Once you understand the way I created then its very simple for you to make any further modification depends on your requirement. This solution will be very useful when you need detail about the person who visit this page and also about the number of time page view with page detail. I created this solution that will make your work easy. It's very simple where you don't need to do anything except deploying the feature and adding the web part into you master page or layout page in sharepoint2010. Below is the screenshot that will display the how it looks like: