Office Integration Pack

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.
Thanks

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.

Thanks

D

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.

Hi Steve,

Should I assume that the pack does not include the facility to CC someone else when creating an e-mail?

Thanks

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 http://msdn.microsoft.com/en-us/library/ff866751.aspx for information on how to add a CC recipient to a MailItem.

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.

Thanks

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

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. 

Example:
mappings.Add(new OfficeIntegration.ColumnMapping("", "Phone", (string f)=>{return f.ToPhone("###-####");}));

Great ideas William. Thanks for the feedback!

Hi Steve,

This pack should be very useful.

Can you explain how to cc another mail recipient when creating an email.

Thanks

Is it possible to export photo format to MS Word?

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.