InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services

This book is NOT suitable for absolute beginners!

InfoPath 2010 Cookbook 5 is for semi-technical to technical professionals who have already mastered the basics of designing form templates in InfoPath and who already know how to work with Excel 2010 and SharePoint 2010.

InfoPath 2010 Cookbook 5 extends skills acquired from all previous books in the InfoPath 2010 Cookbook series of books and is an InfoPath-centric book that teaches intermediate to advanced InfoPath users how to combine InfoPath 2010 with Excel 2010 and Excel Services in SharePoint 2010.

The solutions in InfoPath 2010 Cookbook 5 build basic knowledge before moving onto solutions that integrate InfoPath with Excel and Excel Services and that may or may not require writing code. Chapters 1 and 2 are for non-programmers, while Chapter 3 is for VBA, C#, or Visual Basic .NET programmers who want to combine InfoPath with Excel by writing code.

InfoPath 2010 Cookbook 5 consists of two-thirds codeless (=without code that requires compiling) solutions and one-third solutions that require writing code. InfoPath 2010 Cookbook 5 teaches how to:

• Access data in Excel workbooks that are stored locally or in SharePoint 2010 from within InfoPath forms.
• Connect InfoPath forms to Excel workbooks through Excel Web Access.
• Design InfoPath forms that can create, read, or update Excel workbooks that are stored in SharePoint 2010 using Excel Services.
• Use a large range of Excel functions in formulas to create codeless InfoPath solutions.
• Write VBA code to create, read, or update InfoPath forms.
• Write C# code to create, read, or update InfoPath forms.
• Write Visual Basic .NET code to create, read, or update InfoPath forms.
• Write code that uses the Excel Object Model and the Open XML SDK.