Now Excel is available everywhere

By -

It is important to every business owner that their customers are able to get their Excel spreadsheets from anywhere on every device. Microsoft introduced a new feature 'Excel Interactive View' in Excel 2013 to solve this issue. Now we can say that Excel is available all over the web.

Here is the quick overview of this feature: 



When you find this Excel Button on the web, just click it and you’ll see the simple HTML table with filters, conditional formatting, sorting, and charts options. You can also download it to your desktop to open it in Excel.  You can also add this Excel Button on your website page by adding one line of HTML & a JavaScript tag to the bottom of the page to generate Excel table and chart views on your web page.

 Benefits of this feature:


  • Now we can use Excel online just like we used it offiline.
  • Even MS Excel is not installed on your system; users can use analytical power of Excel on any HTML table on any web page, in most the browsers. 
  • You can filter data like if you have a huge list of top companies & you want to sort it according to your needs then it can be easily done by using Excel Interactive View. 

How it works?

 When we add this button on the web site, it requires a small piece of HTML & a JavaScript tag to the bottom of the page. There are no additional resources required from the website owner to add this button to the table on their web site. The plain piece of HTML is defined that the table is sent to Excel servers in the cloud where it is parsed. After that it put into an automatically generated spreadsheet complete with a table that includes sorting and conditional formatting, the most relevant charts, and a set of filters based on the most relevant columns in the table.


How to add this button on the website: 


  • To add Excel Button on the website, you need to open this website ExcelMashup.com. In left pane, you will find “Add the button option”. On ExcelMashup, you can also check the demo of the Excel button. 
  • When you click on 'Add the Button' option, you will see this picture: 


  • Now choose all fields according to your need: Button Style, Title, Add Company Name.
  • Now Click on Generate Code option. This option will generate the Excel button code for your website. 
  • Now Copy and paste this code above the HTML table that you want to add the Excel Button to:

         <a href="#" name="MicrosoftExcelButton" data-xl-buttonStyle="Standard"></a>

  • Copy and paste this code (as a single line) right above the closing body tab (</body>):

        <script type="text/javascript" src="http://r.office.microsoft.com/r/rlidExcelButton?v=1&kip=1"></script>

When you click on Excel Interactive View button then the view displays on top of the web. Now you can see the options of filter the view, configure options for the view, and open the view in page, as shown in Figure:




You can also download it to your desktop to open it in Excel. You can also use this Excel button on O365 and SharePoint.

Comments

Post a Comment

Popular posts from this blog

Simple Tips to Fix Bookmark Not Defined Error

By -
Image
Bookmark not define error occurs in the large size word document. The main reason of this error is broken link to into the bookmark. It is also related to TOC (Table of Content) and some user complaint this error during updating of TOC. The complete error message is: “ Error! Bookmark Not Defined. ” or “ Error! Reference source not found. ” Important Tip: If you get the same error then press Ctrl+Z to undo action. It works instantly on the document but not worked when you perform any other operations and save the document. Let’s see some reliable solution to fix it! Solution 1: If you are trying to merge the content into a new document, then unlink them before doing it. This process converts TOC field to actual text and tries to prevent it from any update. If you want to update the TOC, you must reinsert it. Steps to unlink the table of contents: Place insertion point within the table of contents. Press ctrl+shift+f9 (for Windows), or the command key+shift+f9 (for
Read more

5 Powerful Solutions to Fix QuickBooks Error 6177

By -
Image
Error 6177 occurs when QuickBooks software does not recognise the path to open the company file. This is the primary reason but, other reasons can also be cause for this error. Let’s discuss some important solution to fix this error. Solution 1: Move your company file to hard-drive Change the location of your company file from a server or any other drive to C drive. Now open the file from there. Create a portable file and save the company file in local drive. Close the company file. Now, restore your portable file from C drive and save to server. Select company file and open it from server. 5-powerful-solutions-to-fix-quickbook Solution 2: Update the QuickBooks version Visit the product page of QuickBooks and update with the latest release. Always update all the updates: manual & automatic to protect the QuickBooks from unwanted error. Solution 3: Manually Fix Follow these steps to manually fix the QuickBooks error 6177 Open the folder that contains company
Read more

How to solve “This document may be damaged (the file may be truncated or incomplete)” JPEG image error

By -
Image
JPEG image or any file type images are very sophisticated, If one pixel of your image get damaged or corrupt then that portion of image will get change. If header part of your image gets damaged then your image will not open. There are several reasons for corruption of JPEG images like virus attack, improper system shutdown etc. In the case of JPEG file corruption you need to repair it with some good JPEG repair software to access your image properly. These are some error messages which you may get in the case of images corruption. Different image viewer will show different message. In Windows Explorer “No Preview Available”. Windows Picture & Fax Viewer will show “Drawing Failed” message. Adobe Photoshop will show “This document may be damaged (the file may be truncated or incomplete)” message. In IrfanView “Can't read file header! Unknown file format or file not found!”. Adobe Photoshop “Could not complete your request because an unkno
Read more