• Home
  • SEM
    • PPC
    • SEO
    • How To
  • Bangladesh
  • School
    • HTTP
    • REP
    • Bots n’ htaccess
    • Source Code
    • Excel 2010
    • HTML XHTML Entities
    • Gmail Operators
    • HTML & ASCII
  • About
    • Privy
    • About This Blog
  • Contact
  • বাংলা

Saidul Hassan

Digital Marketing Evangelist

Home / How to / Present Value Calculator V1.0

Present Value Calculator V1.0

02 Feb, 2014 By Saidul Hassan · Filed Under: How to

How to embed Excel sheet, workbook in webpages, specially in wordpress?
Well, its dead simple! There are wordpress plugings for this, specially one that lets you host your files (PDF, PowerPoint, Excel, or MS Word etc) directly into your media by uploading it to your site or simply link to it from anywhere on the web and then show the contents using Google Drive’s document viewer. It doesn’t require you to have a Google account or host the file to Google Drive. If you are looking for a plain solution like this, you might check the plugin Google Doc Embedder on WordPress Plugin depository. Check the end of this post for a complete list of supported file types by Google Doc Embedder.

However, I am kind of against using another plugin for this. If you have been using wordpress for a while, you know what I mean. So I looked for a direct solution and a way to interact with the file, specially in Excel, sort of user input and then return the calculated results. Good news is, Microsoft itself provides the solution with the Microsoft Excel Web App and I am impressed which is rare about Microsoft. They provide a detail how-to with pictures on their Office support blog. The beauty of using the Microsoft Excel Web App is you can make it completely interactive as if you are using the workbook from your desktop. And no, it doesn’t change the cell values with the user input if you are concerned like I was when I first found out.

    Here is two posts on Microsoft Office site on this:

Embed an Excel spreadsheet on a web page
Share it: Embed an Excel workbook on your blog

Below is the example of embedding excel into wordpress website using SkyDrive’s Excel Web App. Turns out older version of excel format doesn’t support customized embedding features though it gives you the embed code on iframe. Forst O tried with Excel 2003 format .xls and it only showed the excel file thumbnail linking to the downloadable file. However it worked just fine with 2013 format .xlsx. With this format you can use custom parameter to enable/disable Interactivities like filtering, sorting etc. typing, default select cell, download button etc. I used the following parameters for the example below:

wdAllowInteractivity=False
AllowTyping=True
ActiveCell='TableName'!CellNum
Item='TableName'!CellRange
wdHideGridlines=True
wdDownloadButton=True

You can either customize your iframe after getting the basic embed code from SkyDrive or customize while generating the embedding code in the first place. Here is a good documentation on Customize how your Excel workbook is embedded from Microsoft Office Web Apps Support site.

PV Comparator

PV Calculator 1

PV Calculator 2

List of all the file types handled by Google Doc Embedder plugin for WordPress:

      Adobe PDF
      Word (DOC/DOCX)
      PowerPoint (PPT/PPTX)
      Excel (XLS/XLSX)
      TIFF Images
      Apple Pages (PAGES)
    Adobe Illustrator (AI)
      Adobe Photoshop (PSD)
      Autodesk AutoCad (DXF)
      Scalable Vector Graphics (SVG)
      PostScript (EPS/PS)
      TrueType (TTF)
      XML Paper Specification (XPS)
    Archive Files (ZIP/RAR)
The following two tabs change content below.
  • Bio
  • Latest Posts
My Twitter profileMy Facebook profileMy LinkedIn profileMy Instagram profileMy Pinterest profile

Saidul Hassan

Managing Partner at Up Arrow Consulting
COO at Up Arrow Consulting, MCC manager, & Technical SEO consultant. Certified Google Partners and Microsoft Bing Ads Accredited Professional, Python enthusiast, wannabe SysAdmin. Graduated from School of Management & Business Administration (SOMBA), Khulna University.
My Twitter profileMy Facebook profileMy LinkedIn profileMy Instagram profileMy Pinterest profile

Latest posts by Saidul Hassan (see all)

  • Batch script to create directories & moving fixed number of files to those directories - 30 Apr, 2021
  • How to use PrismJS syntax highlighter on WordPress without plugin - 30 Mar, 2020
  • Download an Entire Website for Offline Viewing - 26 Nov, 2019

Share:

  • Twitter
  • Facebook
  • LinkedIn
  • Pinterest
  • Pocket
  • Email
  • Print

First published on 01 Feb, 2014 · Last updated 02 Feb, 2014 · Tagged With: Excel, Microsoft Office, Present Value Calculator

Batch script to create directories & moving fixed number of files to those directories

30 Apr, 2021 By Saidul Hassan

How to use PrismJS syntax highlighter on WordPress without plugin

30 Mar, 2020 By Saidul Hassan

Download an Entire Website for Offline Viewing

26 Nov, 2019 By Saidul Hassan

How to color highlight .htaccess files in Xed/Gedit

20 Aug, 2018 By Saidul Hassan

HMA Pro VPN Setup for Multiple Locations without User/Password Every time in Linux CLI

14 May, 2018 By Saidul Hassan

  • ♥ Bangladesh ♥
    Log in · Privacy Policy · Contact
    Copyright © 2011 Saidul Hassan

  • DMCA