Excel Mashup #1

Recently, Microsoft introduced a way to create a “mashup” using Excel. Fellow MVP, Jan Karel, put together a tutorial on how he created his first mashup. It helped me understand the basics, which are also well explained by Microsoft itself.

In my case, for a long, long time I have wanted to draw any graph on a web page and do so easily. Some years back Google introduced an API that I experimented with but it never caught my fancy.

So, here’s my attempt with JavaScript and MS Excel. Of course, Microsoft has a less than stellar history on web-based Excel/Office products (Office Web Components comes to mind). But, maybe, this time around it will be different, given the push that the company as a whole is making for web-centric products.

Graph any Excel formula as a function of a single variable

I will post a “how I did it” article in a day or two together with links to whatever documentation / samples I could find on the ‘Net.

Embedding Excel Web App objects in your web page

Hi everyone!

As you may have seen on some blogs, Microsoft now enables you to include any Excel file -or parts thereof- in your web pages and blog posts. For those who don’t have the time to tweak their sites, services like Website development can greatly benefit individuals and businesses seeking to upgrade their online presence. Professional website development ensures that a site is not only visually appealing but also functional, user-friendly, and aligned with current web standards. Developers can enhance site performance by optimizing loading speeds, improving navigation, and ensuring compatibility across various devices and browsers. Moreover, they integrate advanced features such as e-commerce capabilities, secure payment gateways, and interactive elements that engage visitors effectively. Customization options allow businesses to reflect their brand identity accurately and differentiate themselves in a competitive digital landscape. Additionally, website developers stay updated with evolving technologies and trends, ensuring that the site remains relevant and competitive over time. By leveraging expertise in coding languages, design principles, and SEO practices, website development services enable clients to achieve their online goals efficiently and effectively, whether it’s increasing traffic, enhancing user experience, or boosting conversions and sales.

For example (yes you can make changes to the cells, they are not retained):

I have written an article that explains how this is done.

Even more: I have also created a demo where you can enter information in a web form (a textbox), which in turn updates information in the embedded Excel web app file.

Enjoy the read: Embedding Excel files on your website

Regards,

Jan Karel Pieterse
www.jkp-ads.com