Excel is well-known in the business world for spreadsheets and math, and did you know that Excel can even create a 3D Animated Coaster!Excel2016Graphic

This book “I Wish I Knew How to … Program Excel 2016 with Xojo in Windows” goes into the numerous options of programming Excel.

With the many great improvements and updates to both Xojo and Microsoft Excel, the 2016 version contains many code updates.

The ‘I Wish I Knew’ series contains technical data and advice that makes sense and contains practical and numerous examples with explanations to allow you to ease into the steep programming curve. You can create Microsoft Excel applications today!

Purchase the book!


Click to download the Excel 2016 Xojo Table of Contents.

There are 16 chapters with more than 320 pages with over 135 example programs. 

Examples include graphing, pivot tables, speaking in Excel, printing pages, sorting, saving Excel files to PDF, and more. Many screenshots have been added to show the results of the code with a full index to help find topics quickly.The book is in PDF format with example chapter folders containing Xojo source code and running examples.

This ebook is a pdf formatted document and all examples include Xojo code. This is one of many books which can be purchased at Xojo Library.

Note: Microsoft Office must be installed for this to work.

ISBN: 978-1-927924-15-0

New to Version 3.0 – March 2016

  1. Bring the Xojo application in front of the Excel program (Other-3)
  2. Count Total Rows with Data (Example 10-12)
  3. Count Individual Rows with Data (Example 10-13)
  4. Convert Serial Date:Time to Gregorian Calendar Format (Example 4-12)
  5. Select Rows and Columns at the same time (Example 10-14)
  6. Clear Column Cell Data (Example 3-20)
  7. Clear Row Cell Data (Example 3-21)
  8. Delete Column Cell Data (Example 3-22)
  9. Delete Row Cell Data (Example 3-23)
  10. Move Worksheet (Example 3-24)
  11. Updated Xojo projects to the new Xojo format
  12. Updated to 2016 Excel
  13. Rbp to xojo_binary_project files
  14. Tested all projects
  15. Updated screen grabs
  16. Application framework updates
  17. Update sheet activate (Example 3-15)
  18. Make book and supplied example match (Example 4-6 and 4-7)
  19. Updated Gantt Chart (Example 4-9)
  20. Updated Pie Chart (Example 4-11)
  21. Total editing time is not available in Excel but is in Word (Example 5-1)
  22. The Office arguement is now case sensitive for Example 5-3
  23. Added detection of Excel 2016 (Example 5-13)
  24. Updated and added vertical and horizontal print quality (Example 6-9)
  25. Get and Set paper size (Example 6-10)
  26. Added Office System Driver location for Example 11-1 – Access Database
  27. Added Speedometer Gauge example (Example 7-14)

Version 3.1 – September 2017

  1. Added Scattered Plot Line Thickness Change (Example 4-13)
  2. Added Print Selected Cells example (Example 6-15)
  3. Added PrintArea of cells to the printer (Example 6-16)
  4. Added Detect Excel file in Read-only mode (Example 5-14)
  5. Suppress Informative Message Box for Read-Only files (Example 5-15)
  6. Bring Excel Application window to the front (Example Other 5)
  7. Added the ability to copy and paste column data from one sheet to another (Example 13-1)
  8. Added an example for a vertical lookup (VLOOKUP) from one sheet to another (Example 13-2)
  9. Added an example to move data from a listbox to Excel (Example 3-25)

New to Version 3.2 – December 2017

  1. Added Form Checkbox Example (Example 14-1)
  2. Added Form DropDown Control (Example 14-2)
  3. Added Form Spinner Control (Example 14-3)
  4. Added Form Listbox Control (Example 14-4)
  5. Added Form OptionButtons Control (Example 14-5)
  6. Added Form Labels Control (Example 14-6)

Version 3.4 – April 2018

  1. Many thanks to Alberto De Poo for his editing suggestions
  2. Clarification: Examples will work with Office 365, and almost no examples will work in the reader (Chapter 5)
  3. Excel Viewer will be retired in April 2018
  4. Update code in Example 2-3 to include Add and Visible to match the book
  5. Changed Example 203 (Page 21) description where the only open sheet is Sheet1 and not Sheet3
  6. Page 22 has the text changed that data is added to the second sheet
  7. Page 53 (Example 3-15) change data that is added to the second sheet
  8. Changed Example 3-15 to allow the option of language-neutral selection of teh pages using an integer value. Caution - an integer value of 2 will select the second sheet, and "Sheet2" will select the correct sheet tab name, even if it is not the second sheet
  9. Added alphabetical Excel sheet ordering in Example 3-26
  10. Added example to place an Excel Addin at runtime (Example Other-6)
  11. Added change text colour (Example 3-27)

New to Version 3.4 – July 2019

  1. Added insertion of new row (Example 15-1)
  2. Added deletion of a row (Example 15-2)
  3. Added insertion of a column (Example 15-3)
  4. Added deletion of a column (Example 15-4)

New to Version 3.5 – April 2021

  1. Added copying a sheet (Example 16-1)
  2. Added counting workbook sheets (Example 3-28)

New to Version 3.6 – May 2021

  1. Added copying a sheet (Example 16-1)
  2. Added TextToColumns (Example 3-29)
  3. Added Dynamic Row and Formula (Example 3-30)
  4. Added RemoveDuplicates method (Example 16-2)
  5. Added PasteSpecial example with constants (Example 12-4)
  6. Added sorting of Alphabetical and numerical data (Example 3-31)
  7. Added row count of total data with UsedRange.Rows.count command (Example 3-31)
  8. Added copy and paste example from two different files (Example 12-05)
  9. Added deletion of blank rows of data (Example 15-5)
  10. Added counting rows of data in individual columns (Example 10-16)
  11. Added the deletion of rows with a value equal to zero (Example 15-6)
  12. Added counting workbook sheets (Example 3-28)