Removed API1 MoveNext with API2 For Each Row as DatabaseRow in rs.Updated API1 ErrorMessage to API2 DatabaseException.Updated to Microsoft Access Database Engine 2010 Redistributable in Example 11-1.Example 4-10 (4-12) updated to API 2 code, except for Date – no TotalSeconds option available.
Removed extra and unused variables in Examples. Changed StrComp to String.Compare (Example 3-26). Changed Listbox ListIndex to SelectedRowIndex (Example 3-25). Changed Date to DateTime (Example 3-14)(Example 7-4). Changed GetFolderItem to FolderItem.Constructor. Changed API1 AbsolutePath to API2 NativePath function. Updated Example2-2 with multiple changes from API1 to API2. Added filename suffix -API2 to signify change in program. Changed API MsgBox to API2 MessageDialog.Show (Example 2-1). Update plugin installation instructions. Updated all project IDE minimum versions. General categories of changes are listed below New to Version 4.0 - June 2021 – Excel 2019 and Xojo API2 Added Tab Delimited File saving (Example 5-16). 
Added fast array reading with Excel (Example 17-2). 
Added simple Xojo array with Excel data (Example17-1). Added example code that contains parameters and return values. New to Version 4.1 – January 2022 – Excel 2019 Note: The single-purchase (Not 365) Excel 2019 version will need to be purchased and installed on your Windows computer for this to work. This ebook is a pdf formatted document and all examples include Xojo 2021 r1.1 API2 code. The book is a live document and will likely have updates in the future. There are 17 Chapters with more than 380 pages and more than 150 example programs. This book is a long-line of compiled information with over 10 years of questions, suggestions, tips, and tricks to create graphs, tables, analyze data, and more. If you are starting out with programming or are a professional in Excel and Xojo, the I Wish I Knew How to… Program Excel 2019 with Xojo API2 book is your guide to answer many of the questions and provides solutions to programming Excel 2019 with Xojo.
0 kommentar(er)
