InfoPath 2010 Cookbook 5

Integrating InfoPath with Excel and Excel Services


How to Purchase

Paperback Edition of InfoPath 2010 Cookbook 5 ($39.95)


Available on Amazon (also available on Amazon.co.uk and Amazon.de)

and

Available on CreateSpace

 

Who is this book for?

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 builds on the knowledge acquired from InfoPath 2010 Cookbook, InfoPath 2010 Cookbook 2, InfoPath 2010 Cookbook 3, and InfoPath 2010 Cookbook 4.

This book is NOT suitable for absolute beginners. The level of this book ranges between intermediate and advanced.

What is this book about?

InfoPath 2010 Cookbook 5 is an InfoPath-centric book that teaches intermediate to advanced InfoPath users how to combine InfoPath 2010 with Excel 2010 and Excel Services to create InfoPath solutions that do or do not require writing code by first providing basic knowledge for building form solutions that access data in Excel 2010 workbooks or that make use of Excel Services in SharePoint 2010, before providing step-by-step guidance for designing common and often-requested form solutions that integrate InfoPath with Excel and Excel Services.

The first two chapters 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 is comprised of:

  • 66% solutions for integrating InfoPath 2010 with Excel and Excel Services without writing code
  • 34% solutions for integrating InfoPath 2010 with Excel through code
  • 57 step-by-step tutorials or solutions that have a Problem-Solution-Discussion format

What will this book do for you?

InfoPath 2010 Cookbook 5 will teach you 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

Note: The last two recipes in Chapter 3 of InfoPath 2010 Cookbook 5 require you to have Visual Studio 2010 installed and to know how to use it.

See the titles of all 57 recipes in the full table of contents of the book.

What can you do next?

You can get InfoPath 2010 Cookbook 5 at Amazon or CreateSpace (an Amazon company)

OR

You can watch demo videos (one of which is shown below) of a few of the InfoPath form solutions that InfoPath 2010 Cookbook 5 teaches you how to create.

Recipe 25: Submit SharePoint List form values to a new Excel workbook




 

Full Table of Contents

Chapter 1: Import Excel Data in InfoPath
1. Create an InfoPath form template from an Excel workbook
2. Import Excel data as XML in InfoPath - method 1
3. Import Excel data as XML in InfoPath - method 2
4. Import Excel data in InfoPath via a SharePoint list - method 1
5. Import Excel data in InfoPath via a SharePoint list - method 2
6. Generate an InfoPath form from Excel data using XSLT

Chapter 2: Excel Services in SharePoint
7. Publish an Excel workbook to SharePoint
8. Send an InfoPath form value to an Excel workbook
9. Send repeating table data to an Excel workbook for display in an Excel chart
10. Get the value of an Excel cell in InfoPath
11. Set the value of an Excel cell in InfoPath
12. Display an Excel chart on an InfoPath form
13. Get the values of a range of Excel cells in InfoPath
14. Populate a drop-down list in InfoPath with data from an Excel workbook
15. Submit Excel data to a SharePoint list via a SharePoint List form - method 1
16. Submit Excel data to a SharePoint list via a SharePoint List form - method 2
17. Submit Excel data to a SharePoint list via a SharePoint List form - method 3
18. Get the value of an Excel cell in InfoPath
19. Set the value of an Excel cell in InfoPath
20. Update an Excel chart on an InfoPath form
21. Get the values of a range of Excel cells in InfoPath
22. Populate a drop-down list in InfoPath with data from an Excel workbook
23. Create a new Excel workbook in SharePoint from within an InfoPath form
24. Update an Excel workbook when submitting an InfoPath form to SharePoint
25. Submit SharePoint List form values to a new Excel workbook
26. Send a repeating table row to Excel - method 1
27. Send a repeating table row to Excel - method 2
28. Send an entire repeating table to Excel - method 1
29. Send an entire repeating table to Excel - method 2
30. Add the URL of a form as a link to an Excel workbook from within InfoPath
31. Validate that a date falls at least 7 business days before a due date
32. Calculate work days between two dates in InfoPath using Excel
33. Calculate remaining leave in InfoPath using Excel
34. Get the amount of records in an Excel table from within InfoPath
35. Sequentially navigate through rows of an Excel table - method 1
36. Sequentially navigate through rows of an Excel table - method 2
37. Add a new row to an Excel table from within InfoPath
38. Perform exact and wildcard searches in an Excel table from within InfoPath

Chapter 3: InfoPath with Excel Programming
39. Generate an InfoPath form from Excel data
40. Populate an InfoPath repeating table with Excel data
41. Populate Excel with InfoPath repeating table data
42. Link Excel cells to document library columns
43. Create a new Excel workbook through a SharePoint Designer workflow
44. Create a new Excel workbook from within InfoPath
45. Get the value of an Excel cell in InfoPath
46. Set the value of an Excel cell from within InfoPath
47. Populate a repeating table with Excel data
48. Populate an Excel workbook with InfoPath repeating table data
49. Create a new Excel workbook in SharePoint from within InfoPath
50. Get the value of a cell in an Excel workbook
51. Set the value of a cell in an Excel workbook
52. Populate a repeating table with Excel data
53. Populate an Excel workbook with InfoPath repeating table data
54. Create and attach a new Excel workbook to an InfoPath form
55. Get data from an Excel workbook attached to an InfoPath form
56. Populate an Excel cell with InfoPath form field data using a UDF
57. Populate an Excel workbook with InfoPath repeating table data using a UDF



Available on Amazon (also available on Amazon.co.uk and Amazon.de)

and

Available on CreateSpace

Disclosure: A few links on this page are Amazon affiliate links. To learn more, read our privacy policy.

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

PAPERBACK

ISBN: 978-1481962063
Publication Date: Jan 2013
Author: S.Y.M. Wong-A-Ton
Page Count: 362
Language: English