Erika Ehrli - Adventures with Office Products & Technologies
MSDN & TechNet: Releasing Office, SharePoint, Exchange & Lync Centers and content for developers and IT professionals.

Excel Services and Office "12" bloggers list

Excel Services and Office "12" bloggers list

  • Comments 8
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.

 

Enjoy!

Leave a Comment
  • Please add 8 and 2 and type the answer here:
  • Post

  • 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.
  • 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.
  • 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.
  • 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.
  • No Comments on Web part or Office Web Components.. But a nice list here.

    thanks
    Jerry
  • Office "12" bloggers list
  • 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> version that you can use in commercial applications.

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

    www.e-iceblue.com/.../excel-for-net-introduce.html

Page 1 of 1 (8 items)