Your extension will be available shortly on the Visual Studio Marketplace at this link.

Office Integration Pack


A LightSwitch Extension that provides integration capabilities with Microsoft Office 2010.

4 Star
Visual Studio
2012, 2010
Download (25,695)
E-mail Twitter Digg Facebook
Add to favorites
Sign in to write a review
Sort by:

3 Star
by Exp3rt | December 28 2015

It's not support with VS 2013

4 Star
by Xpert360 | October 11 2012

Really good start. We are offering some time and resource to help with enhancements over on codeplex. We have enhanced the area of Excel export significantly.

5 Star
by Bart Doise | July 22 2012

4 Star
by Kostas Kolotouros | February 15 2012

What I'm missing is an Excel.Export(string fields) overload that creates a new workbook and exports only the selected fields. With the existing overloads an Excel workbook must pre-exist in order to extract some of the fields.

4 Star
by Eng. 3oon | January 13 2012

is there any way to map multiple Entities into one word document ??

how can i do that ??

1 Star
by KeithSware | November 20 2011

I have vs2010 ultimate SP1rel on an windows 7 SP1 box, the install error was "This extension is not installable on any currently installed products". The supports section in the web description page said 2010 was supported but this was not true in my case for my varient of visual studio. Suggest you download and test a trial version of VS2010 ultimate. I dont have any varient of VS11 preview installed. I also have a varianet of VS2008 installed called 'SQL Server Business Intel DevStudio'. I have office 2007 and also office 2010 that were installed onto the box in that order. All office products are fully patched and service packed.

Steve Hansen November 29 2011
| Edit |

Hi Keith - sorry this didn't work for you. Did you install Visual Studio LightSwitch? It isn't included by default on versions of Visual Studio.

5 Star
by Jamil MilheM | October 10 2011


5 Star
by Jan Van der Haegen | September 16 2011

My Vote of 5, only just had the time to check it out and already using it in a presentation in two hours! Thank you!

5 Star
by PowerBala | September 13 2011

Sign in to start a discussion

  • Size limitations to excel data
    1 Posts | Last post January 04, 2012
    • First of all, well done!  I think that this extension is useful beyond measure!  My question is with regards to the size limitations on the excel file.  Is there limitations to the number of columns that can be effectively processed.  My data file is only 400 kb large but runs from 'A' to 'DL' and i am having troubles mapping the columns.
      Any help would be great!
  • Using Office Integration in Web Apps
    1 Posts | Last post December 27, 2011
    • I would like to use the integration pack for my web based app, but it doesn't seem to work. Is it limited to desktop apps only?
  • Exporting to Excel - all rows from all pages
    1 Posts | Last post December 15, 2011
    • I only seem to be able to export the current page to excel. Is there a way to export all pages at once to excel? I'm using:  OfficeIntegration.Excel.Export(Me.Authors, ExcelFile, "Sheet1", "A1", fields), this just exports the current page.
  • MS Outlook must be open?
    4 Posts | Last post December 06, 2011
    • Steve.
      First off, thanks so much for this extension.  It's great.  I have a slight problem with Outlook.  When using in development everything works fine, but when I release my app into production my users have to close Outlook (2010) before it will create the email.  Of course, it re-opens Outlook and works fine after that.  Is there a way to use it when Outlook is already opened?  Thanks again.
    • My application has the same issue, any suggestions?
    • Me too, has anybody got any suggestions on this, I'm having to disable email creation in my App because of this.
      Meantime I'll dig around the source code.
    • No solution yet.  I've deployed it in an app at my company, but also noticed that it won't handle the "&" sign.  We're looking for another solution now.
  • CC Recipient
    2 Posts | Last post December 05, 2011
    • Hi Steve,
      Should I assume that the pack does not include the facility to CC someone else when creating an e-mail?
    • Hi Steve. Correct - it doesn't support it directly in the call to CreateEmail. However, this method returns an Outlook MailItem object representing the email so you can manipulate it further. See for information on how to add a CC recipient to a MailItem.
  • Does it work with earlier versions of Office?
    7 Posts | Last post November 29, 2011
    • You mention Office 2010 in the description. Does that mean it won't work with earlier versions?
    • Before I answer, let me just say I haven't done any formal testing with previous versions which is why I'm not officially supporting them. That said, I have used it with a little bit with Office 2007 and it seems to work fine. I haven't tried it with Office 2003 but in theory much (but not all) of the functionality should work too.
    • Hi Steve,
      Haven't had time to try it properly, but Office 2003 doesn't support controls (they were introduced in 2007), so I don't know if I'll be able to use the extension anyway, unless there's another way of doing it.
    • Yes - if the functionality that appeals to you is the Word functionality using content controls, you are definitely out of luck using Office 2003.
    • Hi Steve. I would like to use Word, but am not particular about how I use it. Can your extension use Word by some other method, such as bookmarks? If so, how? Do you have any documentation on this? Thanks
    • OK, Ignore my last question! Just noticed that the sample application includes an example of using bookmarks.
      However, I can't get the sample solution to open. I get an error loading and the following message in the output window... "D:\Office Integration Pack Extension\LightSwitch Office Integration Pack Extension - Sample Application\C#\BooksStoreApp\BooksStoreApp.lsproj : error  : Unable to read the project file 'ClientGenerated.csproj'. 
      C:\Windows\Microsoft.NET\Framework\v4.0.30319\Microsoft.Common.targets(4040,43): Cannot evaluate the item metadata "%(FullPath)". The item metadata "%(FullPath)" cannot be applied to the path "obj\Debug\BooksStoreApp.ClientGenerated.dll". D:\Office Integration Pack Extension\LightSwitch Office Integration Pack Extension - Sample Application\C#\BooksStoreApp\ClientGenerated\obj\Debug\BooksStoreApp.ClientGenerated.dll"
      Any idea what went wrong? Thanks
    • Any idea about this error? Thanks
  • Two features
    2 Posts | Last post November 29, 2011
    • Hi Steve. Installed today.
      Couple ideas that would seem to help
      1) Allow passing an IEnumerable instead of IVisualCollection. That way, we could pass any list instead of a just a LS collection.
      2) Allow a format Lamba to be added to each Mapping. That way, you have an excape hatch for formatting. For example I could format a phone field to (###)###-#### or other instead of just sending LS string to excel. 
      mappings.Add(new OfficeIntegration.ColumnMapping("", "Phone", (string f)=>{return f.ToPhone("###-####");}));
    • Great ideas William. Thanks for the feedback!
  • CreateEmail - CC another recipient
    1 Posts | Last post November 18, 2011
    • Hi Steve,
      This pack should be very useful.
      Can you explain how to cc another mail recipient when creating an email.
  • Export photo format to MS Word
    1 Posts | Last post November 08, 2011
    • Is it possible to export photo format to MS Word?
  • Bulleted List
    1 Posts | Last post October 12, 2011
    • Hey Steve, do you know if there's anyway to get a bulleted list where the screen data would be in like a list/detail page? 
      We're trying to put together an Agenda generator and I need to output the Agenda items into a bullted list along with a column for Presenter and Time. Now I don't have to have the extra 2 columns, but I need to find a way to get a list with subitems on the list.
      Word does this so effortlessly by default, it's hard to figure out how to reproduce that. 
11 - 20 of 20 Items