CAWT

CAWT is a utility package based on TWAPI to script Microsoft Windows® applications with Tcl. It provides high level procedures for automation via the COM interface.

Currently packages for Excel, Word, PowerPoint, Outlook, OneNote, Internet Explorer, Matlab, and Google Earth are available.

This extension was formerly known as TcomExcel and TcomOffice, but has been renamed to the more general CAWT (COM Automation With Tcl).

Sources and distribution packages are available on SourceForge since 2014/04/06.

PO 2023/07/17 - Please note, that I do not develop CAWT anymore. I retired from work this year and thus have no need to use Microsoft Office anymore. If somebody is interested in further CAWT development, drop me a note, so I can add you to the SourceForge CAWT developer list.

Release history

TcomExcel

PO 2008/09/11 - TcomExcel version 0.1 released. It includes Excel constants and enumerations as symbolic names, utility functions as well as some test programs.

PO 2009/07/19 - A new version (0.2) of TcomExcel with support for Excel 2007 is now available. Thanks to Cary Campbell for supplying enhancements and fixes.

PO 2010/10/29 - A new version (0.3) of TcomExcel with enhanced test suite and bug fixes for Excel 2007 is now available.

PO 2011/01/13 - A new version (0.3.1) of TcomExcel with support for Excel 2010 is now available.

PO 2011/04/05 - A new version (0.3.2) of TcomExcel with support to copy and paste data between Tcl and Excel is now available. It uses Twapi for managing the clipboard and is substantially faster than setting/getting individual cells.

TcomOffice

PO 2011/07/17 - A new version (0.4.0) of TcomOffice with support to put table data from Excel into Word and vice versa.

PO 2011/08/28 - A new version (0.4.1) of TcomOffice with support to put table data from Excel into Mat-Files and 1-channel RAW image files and vice versa.

CAWT 1

PO 2012/12/23 - CAWT version 1.0.0 released. Extended functionality and renaming from TcomOffice to CAWT.

PO 2013/04/28 - CAWT version 1.0.1 released. Extended Excel chart generation. Starkit enabled.

PO 2013/07/28 - CAWT version 1.0.2 released. Added new package CawtOcr for automation of Office Document Imaging. Update of used Twapi and Img extensions.

PO 2013/08/30 - CAWT version 1.0.3 released. Added some utility procedures in module CawtExcel.

PO 2013/11/23 - CAWT version 1.0.4 released. Added support for Office 2013 and 64-bit Office. Several new procedures in CawtWord and CawtExcel. Update of used Img and Tablelist extensions.

PO 2014/01/26 - CAWT version 1.0.5 released. Added some utility procedures in module CawtExcel.

PO 2014/04/21 - CAWT version 1.0.6 released. Improved handling of sparse matrices in package CawtExcel.

PO 2014/06/14 - CAWT version 1.0.7 released. Added several utility procedures in packages CawtExcel and CawtPpt. Updated Twapi to official 4.0.61 version.

PO 2014/08/30 - CAWT version 1.1.0 released. Added new package CawtOutlook for automation of Outlook. Rework of CawtWord package (some incompatible changes).

PO 2014/12/14 - CAWT version 1.2.0 released. Several new CawtWord procedures.

CAWT 2

PO 2015/03/31 - CAWT version 2.0.0 released. Ensembled all CAWT namespaces. Store Office enumerations in hash tables. Several improvements and bug fixes.

PO 2015/09/01 - CAWT version 2.1.0 released. Enhanced functionality and bug fixes. Added support to generate a CAWT starpack.

PO 2015/10/31 - CAWT version 2.1.1 released. Added support for Office 2016.

PO 2015/11/10 - CAWT version 2.1.2 released. Enhanced functionality and bug fixes. Extended support for Excel page setup.

PO 2015/12/12 - CAWT version 2.2.0 released. Enhanced functionality in Core and Office modules. New module CawtOffice.

PO 2016/08/16 - CAWT version 2.3.0 released. New module CawtOneNote. Enhanced functionality in Excel module.

PO 2016/12/10 - CAWT version 2.3.1 released. Enhanced functionality in Core and Office modules.

PO 2017/06/18 - CAWT version 2.4.0 released. New module CawtReader. Updated external packages.

PO 2017/12/30 - CAWT version 2.4.1 released. Enhanced functionality in Outlook module. Updated external packages.

PO 2018/04/26 - CAWT version 2.4.2 released. Enhanced functionality in several modules.

PO 2018/12/27 - CAWT version 2.4.3 released. Support for Office 2019.

PO 2019/06/08 - CAWT version 2.4.4 released. Enhanced functionality in several modules.

PO 2019/08/13 - CAWT version 2.4.5 released. Enhanced functionality in Word module.

PO 2019/10/12 - CAWT version 2.4.6 released. Enhanced reference documentation.

PO 2019/11/03 - CAWT version 2.4.7 released. Enhanced functionality in Ppt and Word modules.

PO 2020/03/08 - CAWT version 2.4.8 released. Support for Office macro execution.

PO 2020/06/09 - CAWT version 2.4.9 released. Enhanced functionality in Excel module.

PO 2020/07/24 - CAWT version 2.5.0 released. Enhanced functionality for handling Office document properties.

PO 2021/01/06 - CAWT version 2.6.0 released. New module CawtSapi adding support for Microsoft Speech API. Updated external packages.

PO 2021/02/27 - CAWT version 2.7.0 released. Enhanced functionality for handling Outlook contacts. New procedures in Word and PowerPoint module.

PO 2021/06/27 - CAWT version 2.8.0 released. Added functionality for embedding applications. New procedures in Excel and Word module.

PO 2021/07/22 - CAWT version 2.8.1 released. Bug fixes in Excel and Word module.

PO 2021/08/20 - CAWT version 2.8.2 released. Bug fix and extensions in Word module.

PO 2021/12/19 - CAWT version 2.9.0 released. Added functionality for interpolation curves. New or improved procedures. Updated external packages.

PO 2022/04/14 - CAWT version 2.9.1 released. Bug fix and extensions in Excel, Outlook and Word module.

PO 2022/12/21 - CAWT version 2.9.2 released. Bug fixes and extensions in Word module.

PO 2023/03/20 - CAWT version 2.9.3 released. Bug fixes and extensions in Excel, PowerPoint and Word modules. Updated external packages.

PO 2023/07/17 - CAWT version 2.9.4 released. Bug fix in Word module.

PO 2024/03/12 - CAWT version 2.9.5 released. Bug fixes and extensions in Core and Outlook modules.

PO 2024/06/13 - CAWT version 2.9.6 released. Adaptions for Tcl 9 and Twapi 5.

Discussion

APN 2021/07/02 This is just awesome.

PO 2021/07/10 - Comment of APN seems to be related to embedding Office applications. Here is a screenshot of my Word document checker. More screenshots can be found here: [L1 ]