Excel book 4.2 - API 2 - Updated Feb 2023

The book “I Wish I Knew How To…Program Excel 2019 with Xojo API2” has been updated to version 4.2. Focus of this update has been with pictures/images. The book can be purchased at: https://www.xdevlibrary.com/ or at my website: https://scispec.ca/index.php/books

This is a free update for those who have purchased previous 4.x version of this book. Here are a list of the updates:

New to Version 4.2 — February 2023

  • Add an object picture
  • Retrieve image name
  • Rename image
  • Retrieve picture dimensions
  • Delete an image
  • Make an image invisible
  • Loop through pictures
  • Link pictures to cells
  • Image placement and locking
  • Increment picture rotation
  • Total picture rotation
  • Centre image to cell
  • Image horizontally flipped
  • Image vertically flipped
  • Resize an Image
  • Stretch an image with cells
  • Crop an Image
  • Change Z-Order
  • Set Background Picture
  • Save Picture