Excel Services and Office "12" bloggers list

I have been playing around with Office "12" and SharePoint "v3" and I am quite surprised of how easy it is to view and interact with Excel Spreadsheets in a browser thanks to Excel Services. I needed to build a site and share with my team our content plans for Office "12." I had an Excel file that I wanted to share so I added an Excel Web Access web part that allows my peers to interact with an Excel 12 Workbook as a Web page. This is way much better than sending around my file by email!

If you have the time, you can build a Web site to display an Excel Spreadsheet. The following are six different approaches you could use to display an Excel Spreadsheet (or at least its contents) on a Web page:

  1. Web page 1: Save your Excel Spreadsheet as an html file and add an html IFrame to a Web page to embed your Spreadsheet. This option requires Office Web Components.
  2. Web page 2: Use ADO and the Microsoft Excel Driver.
  3. Web page 3: You could also databind your Excel Spreadsheet to an ASP.NET datagrid to display the content of your Spreadsheet as a table.
  4. Web page 4: Copy and paste your Excel Spreadsheet to Visual Studio and it will be rendered as an HTML table. To simple and you will lose functionality such as sorting and filtering).
  5. Web page 5: Buy a third-party component that will build web pages for you, such as SpreadsheetGear.
  6. Web page 6: Use an ActiveX control such as DSO Framer Control Object to host Excel inside your Web page.

If you were using a SharePoint site, you would also need to build a web part that displays any Web page 1, 2, 3, 4, 5 or 6 and this would take you longer. Using Excel Services, it took me less than a minute to add and configure a web part that displays an Excel Spreadsheet.

If you want to learn more about Excel Services, don't miss the opportunity to read David Gainer's blog. By the way, one of the Excel Spreadsheets that I wanted to share with my team is a growing list of Office "12" bloggers. I wish I could show you all a running Excel Services web part. I can't run Excel Services in my blog so I went for the Web page 1 approach to share with you my Office "12" bloggers list.



Comments (8)

  1. anon says:

    I can’t see the web part. It says "To use this Web page interactively, you must have Microsoft® Internet Explorer 5.01 Service Pack 2 (SP2) or later and the Microsoft Office 2003 Web Components.". I don’t think Microsoft understands what "web-based" means. Anyway.

  2. I am displaying an Office Web Component (OWC) (not a web part)to share a list of Office "12" bloggers. To see OWC you need Microsoft® Internet Explorer 5.01 Service Pack 2 (SP2) or later.

    For those of you who can’t see the OWC I will be happy to post the list of Office "12" bloggers later.

  3. Shahar Prish says:

    I am not sure why OWC is used here – with Office 2007, you can use an honest-to-god completely thin, no ActiveXs needed, no foot print, only HTML and Javascript Excel Viewer.

    The screen shot shown is NOT of EWA, but of the old Office Web Components.

  4. Shahar and everyone,

    It was not the best idea to place an OWC component in a blog entry. I did that just for fun because I wanted to display an Excel Services web part and couldn’t do it. Not the best idea, so I created a separate blog entry with a plain html list.

  5. jerry_yasir says:

    No Comments on Web part or Office Web Components.. But a nice list here.



  6. Erika Ehrli says:

    Office "12" bloggers list

  7. Mario says:

    Why do you favor SpreadsheetGear over other Spreadsheet components? You can work with .NET component that can <a href="http://www.gemboxsoftware.com/GBSpreadsheet.htm">Read/Write XLS/CSV/HTML/XLSX files</a>. This component has a <a href="http://www.gemboxsoftware.com/GBSpreadsheetFree.htm">free</a&gt; version that you can use in commercial applications.

  8. Bill says:

    nice article, but I use a excel component long, very good!!! so powerful, so easy.


Skip to main content