Release history

2024/06/13: Version 2.9.6

2024/03/12: Version 2.9.5

2023/07/17: Version 2.9.4

2023/03/20: Version 2.9.3

2022/12/21: Version 2.9.2

2022/04/14: Version 2.9.1

2021/12/19: Version 2.9.0

2021/08/20: Version 2.8.2

2021/07/22: Version 2.8.1

2021/06/27: Version 2.8.0

2021/02/27: Version 2.7.0

2021/01/06: Version 2.6.0

2020/07/24: Version 2.5.0

2020/06/09: Version 2.4.9

2020/03/08: Version 2.4.8

2019/11/03: Version 2.4.7

2019/10/12: Version 2.4.6

2019/08/13: Version 2.4.5

2019/06/08: Version 2.4.4

2018/12/27: Version 2.4.3

2018/04/26: Version 2.4.2

2017/12/30: Version 2.4.1

2017/06/18: Version 2.4.0

2016/12/10: Version 2.3.1

2016/08/16: Version 2.3.0

2015/12/12: Version 2.2.0

2015/11/10: Version 2.1.2

2015/10/31: Version 2.1.1

2015/09/01: Version 2.1.0

2015/03/31: Version 2.0.0

2014/12/14: Version 1.2.0

2014/08/30: Version 1.1.0

2014/06/14: Version 1.0.7

2014/04/21: Version 1.0.6

2014/01/26: Version 1.0.5

2013/11/23: Version 1.0.4

2013/08/30: Version 1.0.3

2013/07/28: Version 1.0.2

2013/04/28: Version 1.0.1

2012/12/23: Version 1.0.0

2011/08/28: Version 0.4.1

2011/07/17: Version 0.4.0

2011/04/05: Version 0.3.2

2011/01/13: Version 0.3.1

2010/10/29: Version 0.3.0

2009/09/19: Version 0.2.0

2008/09/11: Version 0.1.0

Maintenance release

All modules:

• Added support for Tcl 9.
• Added support for Twapi 5.

New procedures in CawtExcel:

• GetListItemSeparator, SetListItemSeparator

Maintenance release

CawtCore:

• Take care of changed Img behaviour in procedure ImgToClipboard:
  Img 2.0 returns image data as binary string.
  Img 1.4 returns image data as base64 encoded string.

CawtOutlook:

• Added new options -requiredattendees and -optionalattendees to procedures GetAppointmentProperties and AddAppointment.

Maintenance release

CawtWord:

• Extended validity detection of sub-addresses in procedure GetHyperlinksAsDict to include "<a id=XXX>" and "<a name=XXX>" addresses.

Maintenance release

CawtExcel:

• Corrected default value of parameter worksheetNameOrIndex from 0 to 1 in procedures ExcelFileToWikitFile and ExcelFileToMediaWikiFile.
• Added test script showing how to export an Excel workbook as Wikit tables with hyperlinks.

CawtWord:

• Extended validity detection of sub-addresses in procedure GetHyperlinksAsDict to include "<a id=XXX>" in addition to "<a name=XXX>" addresses.

New procedures in CawtPpt:

• GetCommentKeyLeftPosition, GetCommentKeyPosition

External packages:

• Updated Img to version 1.4.14.
• Updated Ruff! to version 2.3.0.
• Updated Tablelist to version 6.20.
• Updated tDOM to version 0.9.3.
• Updated Twapi to version 4.7.2.

Maintenance release

CawtWord:

• Extended SetTableName and GetTableName to specify or retrieve the descriptive table text.

Test programs and documentation:

• Corrected links due to new Ruff! version.

Maintenance release

CawtExcel:

• Added option -selection to procedure WorksheetToTablelist to transfer the selected Excel cell range.
• Corrected regexp in procedures GetRangeAsIndex and GetCellValueA1.

CawtOutlook:

• Improved GetFoldersRecursive.

CawtWord:

• New procedures:
  GetHeadingsAsDict, PrintHeadingDict

Added functionality for interpolation curves

CawtCore:

• Added oo:class to interpolate between control points.
• New procedures:
  IsValidUrlAddress, SetClipboardWaitTime, WaitClipboardReady

CawtPpt:

• New procedures:
  IsValidPresId, GetCurrentSlideIndex

CawtWord:

• GetHyperlinksAsDict:
  Improved speed of URL validity check.
  Added support for URL's with subaddress (ex. www.tcl3d.org/doc.html#Index).

External packages:

• Updated Ruff! to version 2.0.
• Updated Tablelist to version 6.16.
• Updated Twapi to version 4.6.0.

Maintenance release

CawtWord:

• Corrected behaviour of GetHyperlinksAsDict, if link points to an URL with spaces.
• Extended SetTableOptions with new option -width.
• Extended SetColumnWidth to specify width in percent.

Maintenance release

CawtExcel:

• Added automatic mapping of worksheet names to Excel constraints regarding invalid characters and maximum length.

CawtWord:

• Corrected behaviour of GetHyperlinksAsDict, if link points to an invalid domain.

Added functionality for embedding applications

CawtCore:

• New procedures:
  EmbedApp, SetEmbedTimeout

CawtExcel:

• Extended procedure OpenWorkbook to embed the application into a Tk frame.
• New procedures:
  GetNumStyles, GetStyleId

CawtPpt:

• Extended procedure OpenPres to embed the application into a Tk frame.

CawtReader:

• Extended procedure Open to embed the application into a Tk frame.

CawtWord:

• Extended procedure OpenDocument to embed the application into a Tk frame.
• New procedures:
  GetNumPages, SetViewParameters

External packages:

• Updated Tablelist to version 6.14.
• Updated Ruff! to version 1.2.

Enhanced functionality for handling Outlook contacts

CawtCore:

• Extended procedure CountWords to additionally sort by increasing or decreasing counts.

CawtExcel:

• Changes in procedure WorksheetToTablelist:
  Improved speed when handling worksheets with large number of columns.
  Tablelist column headers are labeled like in Excel: A, B, C, ...
  Added options -header, -rownumber, -maxrows, -maxcols.
  

CawtOutlook:

• New procedures:
  AddContact, AddContactFolder, DeleteContactByIndex, DeleteContactFolder, GetContactByIndex, GetContactFolderId, GetContactFolderNames, GetContactProperties, GetNumContactFolders, GetContactReadOnlyPropertyNames, GetContactReadWritePropertyNames, GetNumContacts, HaveContactFolder, SetContactProperties

CawtPpt:

• New procedures:
  GetNumSlideImages, GetNumSlideVideos, GetSlideIdByName, GetSlideImages, GetSlideName, GetSlideVideos, SetSlideName

CawtWord:

• Extended GetHyperlinksAsDict to be used as a coroutine.
• New procedures:
  GetBookmarkNames, GetHyperlinksAsDict, PrintHyperlinkDict, GetNumHyperlinks

External packages:

• Updated Tablelist to version 6.12.
• Updated Ruff! to version 1.1.

New module CawtSapi adding support for Microsoft Speech API

CawtSapi:

• Added basic functionality of Microsoft Speech API.

CawtCore:

• New procedure:
  SetEventCallback

External packages:

• Updated Twapi to version 4.5.2.
• Updated Tablelist to version 6.11.
• Updated tDOM to version 0.9.2.
• Updated Img to version 1.4.12.

Enhanced functionality for handling Office document properties

CawtOffice:

• Extended to support all types of document properties: bool, int, float, date and string.
• New procedures:
  AddProperty, DeleteProperty, GetProperty, GetPropertyName, GetPropertyType, GetPropertyValue, SetPropertyValue

Enhanced functionality in Excel module

CawtExcel:

• Fixed bug when reading CSV files with Unix line endings.
• New procedures:
  SetRangeFontAttributes, GetRangeFontAttributes

All modules:

• Compare procedure options with -nocase.

Support for Office macro execution

CawtCore:

• New procedure:
  GetTmpDir

CawtOffice:

• New procedures:
  AddMacro, RunMacro

CawtExcel:

• Fixed bugs in DiffExcelFiles.
• New procedures:
  GetCellValueA1

CawtWord:

• Fixed COM object leak in IsValidCell.
• New procedure:
  GetRangeScreenPos

Enhanced functionality in Ppt and Word modules

CawtPpt:

• Extended InsertImage to support both image file names as well as photo images.
  
• Corrected procedure ExportPptFile.
  
• Added additional -check option to proc CreateVideo to specify the check interval.
  
• New procedures:
  GetPptImageFormat, GetSupportedImageFormats, GetCreateVideoStatus, IsImageFormatSupported

CawtWord:

• New procedures:
  SetPageSetup, GetCrossReferenceItems, GetHeadingRanges, GetRangeText, SetRangeFontColor, GetRangeFont, SetRangeFont

Enhanced reference documentation

CawtCore:

• Extended test suite for complete test coverage. Fixed bug in procedure GetColorNames.

Office modules:

• Added procedures for each enumeration type.

CawtPpt:

• Added new option -fit to proc InsertImage.
• New procedures:
  CheckCreateVideoStatus, CreateVideo, SetSlideShowTransition, GetPresPageHeight, GetPresPageWidth

External packages:

• Updated Ruff! to version 1.0b3.

Enhanced functionality in Word module

CawtWord:

• Corrected procedures FindString and Search, when called with a docId.
• New procedures:
  GetFooterText, GetHeaderText, DeleteSubdocumentLinks, ExpandSubdocuments, GetNumSubdocuments, GetSubdocumentPath

External packages:

• Updated Tablelist to version 6.6.
• Updated Twapi to version 4.3.7.

Enhanced functionality in several modules

CawtCore:

• Added new utility procedures *OfficeDate*.
  
• Declared old *OutlookDate* procedures as obsolete.

CawtExcel:

• Extended procedure GetCellRange to allow specification of a cell range, not only a single cell.
  
• Extended procedure AddSeriesTrendLine with option keys -linewidth and -linecolor.
• New procedure:
  SetSeriesAttributes

CawtWord:

• New procedures:
  SetTableAlignment, SetTableOptions, SetTableVerticalAlignment

External packages:

• Updated Tablelist to version 6.5.
• Updated Img to version 1.4.9.

Support for Office 2019

Applications:

• Added script DocumentInfo.tcl to retrieve information about Office documents.

CawtExcel:

• New procedure:
  AddSeriesTrendLine

CawtOffice:

• New procedure:
  GetOfficeType

CawtPpt:

• New procedures:
  GetCommentKeyTopPosition, GetNumShapes, GetPresImages, GetPresVideos, GetShapeId, GetShapeMediaType, GetShapeName, GetShapeType, InsertVideo, SetShapeName, SetMediaPlaySettings

CawtWord:

• Extended procedure GetRowRange to use start and end rows.
  
• Extended procedure GetNumImages to consider both InlineShapes as well as Shapes.
• New procedures:
  CollapseRange, CopyRange, DeleteTable, GetImageList, GetPageSetup, GetRowId, GetTableIdByName, GetTableName, IsVisible, MergeCells, ScreenUpdate, SetCellVerticalAlignment, SetHeadingFormat, SetRowHeight, SetTableName

External packages:

• Updated Tablelist to version 6.3.
• Updated Img to version 1.4.8.
• Updated Twapi to version 4.3.5.
• Updated tDOM to version 0.9.1.

Enhanced functionality in several modules

CawtExcel:

• New procedures:
  Import, CopyColumn, SetChartSourceByIndex, SetChartTitle, GetChartNumSeries, GetChartSeries, SetSeriesLineWidth

CawtPpt:

• Added new configure options for shapes: -beginsite, -endsite
• Added new configure option for connectors: -weight
• New procedures:
  SetPresPageSetup, SetHyperlinkToSlide, GetNumSites

CawtWord:

• Corrected procedure SetDocumentProperty.
• New procedures:
  DeleteRow, SetRangeMergeCells

Enhanced functionality in Outlook module

CawtExcel:

• Added ability to save CSV files in UTF-8 format.
• New procedures:
  CreateRangeString SetChartTicks

CawtOutlook:

• Added handling of appointments, calendars and categories.
  
• Added ability to read and apply Outlook holiday files.

CawtWord:

• New procedures:
  AddImageTable GetImageId GetImageName GetNumImages ReplaceImage SetImageName CountWords

External packages:

• Updated Tablelist to version 6.0.
• Updated Twapi to version 4.2.12.
• Updated tDOM to version 0.9.0.
• Updated Img to version 1.4.7.

New module CawtReader

CawtExcel:

• Compatibility issue ExcelFileToHtmlFile has changed signature. Now uses parameter args for extended options.
• Extended module excelHtml to convert Excel hyperlinks.

CawtReader:

• Added basic functionality for Acrobat Reader (not via COM).

CawtWord:

• New procedure:
  IsValidCell

External packages:

• Updated Tablelist to version 5.17.
  
• Updated Twapi to version 4.2a5.

Enhanced functionality in Core and Office modules.

CawtCore:

• New procedure:
  CheckBoolean

CawtExcel:

• Extended Excel module excelImgRaw to support 16-bit integer images.
• New procedure:
  GetCellComment

CawtWord:

• New procedures:
  Search SetRangeFontBackgroundColor

External packages:

• Updated Img (32 and 64 bit) to version 1.4.6.
• Updated Tablelist to version 5.16.

New module CawtOneNote

CawtExcel:

• Compatibility issue GetRangeAsIndex now returns a 2-element (cell) or 4-element (range) list. Previous behaviour was to always return a 4-element list.
• New procedures:
  DuplicateColumn, DuplicateRow, GetHiddenRows, HideRow, InsertColumn, InsertRow, GetColumnNumber, ShowWorksheet, IsWorksheetEmpty, GetRangeWrapText, SetRangeWrapText, SetRangeValues, GetRangeValues, IsWorkbookId, GetWorkbookIdByName, IsWorkbookOpen, SetNamedRange, GetNamedRange, GetNamedRangeNames

CawtOneNote:

• Added basic functionality for Microsoft OneNote.
  
• Added script OneNoteInfo.tcl to retrieve information from OneNote.

CawtOutlook:

• New procedure:
  CreateHtmlMail.

External packages:

• Updated Tablelist to version 5.15.
  
• Updated Twapi to version 4.2a3.
  
• New package tDOM 0.8.3 (needed for CawtOneNote).

Enhanced functionality in Core and Office modules

New module CawtOffice:

• Moved basic Office procedures into namespace Office.
  
• Added aliases in namespace Cawt for backwards compatibility.
  
• Added new enumeration constants file for basic Office types based on type library in mso.dll.

CawtCore:

• Colors can now be specified in hex notation, Tcl color names, RGB or as Office color numbers.
• New procedures:
  GetColor, GetColorNames, IsHexColor, IsNameColor, IsOfficeColor, IsRgbColor OfficeColorToRgb, RgbToOfficeColor

CawtExcel:

• Compatibility issue AddWorksheet now adds the new sheet at the end, as was already written in the documentation. Previous behaviour was to insert before active worksheet.
• Extended SetLinkToCell to copy number format when linking.
  
• Extended SetRangeFormat to accept Excel style number formats.
  
• Extended SetHyperlinkToFile to accept relative path names.
  
• Corrected hyperlinking to relative file names.
• New procedures:
  CopyRange, GetCurrencyFormat, GetRangeFormat

CawtPpt:

• New procedures:
  AddShape, ConfigureShape, ConnectShapes, ConfigureConnector

CawtWord:

• New procedure:
  SetHyperlinkToFile

Enhanced functionality and bug fixes

All Office modules:

• Changed all Office procedures with size parameters to accept inches, centimeters or points.

CawtExcel:

• Corrected SetWorksheetFitToPages to accept zero as values for wide and tall parameters. Zero indicates automatic determination of number of pages.
• Extended support for Excel page setup.
• New procedures:
  SetWorksheetPrintOptions, SetWorksheetPaperSize, SetWorksheetMargins, SetWorksheetFooter, SetWorksheetHeader

CawtCore:

• New procedures:
  SetPrinterCommunication, ValueToPoints, PointsToCentiMeters, PointsToInches

Support for Office 2016

Added support for Office 2016

• Updated enumerations.

External packages:

• Updated Tablelist to version 5.14.

Enhanced functionality and Starpack generation

CawtCore:

• New procedure:
  TclString

CawtExcel:

• Take hidden flag of both Excel and tablelist columns into account in procedures TablelistToWorksheet and WorksheetToTablelist.
  
• Fixed SetCellValue and SetRangeFormat using new TclString procedure.
• New procedures:
  DeleteColumn, DeleteRow, HideColumn, GetHiddenColumns, GetDecimalSeparator (replacing GetFloatSeparator), GetThousandsSeparator, GetNumberFormat (replacing GetLangNumberFormat)

CawtPpt:

• Extended functionality of ExportPptFile and ExportSlides to take into account slide comments regarding export file names.
• New procedures:
  AddTextbox, AddTextboxText, SetTextboxFontSize, GetNumComments, GetComments, GetCommentKeyValue

CawtWord:

• New procedures:
  AddContentControl, SetContentControlDropdown, SetContentControlText, GetDocumentProperties, GetDocumentProperty, SetDocumentProperty

External packages:

• Updated Twapi to version 4.2.a1, because of new Twapi functionality tclcast bstr and bug fix to retrieve document properties.

Ensembled all CAWT namespaces

Overall changes:

• Ensembled all CAWT namespaces, ex. write Excel Open instead of ::Excel::Open"
• All Office enumerations are stored in module specific hash tables, ex. write xlThick instead of $::Excel::xlThick"
• Updated and extended user manual (automatic insertion of CAWT procedure reference list).
• Added new application EnumExplorer.tcl to display Office enumerations.

CawtCore:

• Replaced procedure IsValidId with IsComObject.
• New procedures:
  GetApplicationVersion, IsApplicationId, PushComObjects, PopComObjects, PrintNumComObjects, CheckComObjects, GetComObjects, GetNumComObjects
  

CawtExcel:

• New implementation of InsertImage based on Shapes.AddPicture instead of Pictures.Insert.
• New module excelHtml.tcl for HTML export of Excel tables.
• New procedures:
  GetRangeAsIndex, GetRangeAsString, GetRangeTextColor

CawtWord:

• Extended procedure UpdateFields to additionally update TablesOfContents and TablesOfFigures of a document.
• New procedures:
  ScaleImage, SetInternalHyperlink, InsertFile, DiffWordFile

External packages:

• Updated Twapi to version 4.1.27.
• Updated Img (32 and 64 bit) to version 1.4.3.
• Updated Tablelist to version 5.13.

New CawtWord procedures

CawtExcel:

• Added optional startRow parameter to TablelistToWorksheet.

CawtWord:

• Compatibility issue Removed parameter docId from all procedures, which had both docId and rangeId parameters:
  SetRangeStartIndex, SetRangeEndIndex, ExtendRange, AddText, SetHyperlink, AddTable.
• New procedures:
  GetDocumentId, SetRangeFontUnderline, CreateRangeAfter, InsertCaption, ConfigureCaption, AddBookmark, GetBookmarkName, SetLinkToBookmark, GetListGalleryId, GetListTemplateId, InsertList

New CawtOutlook package

New module CawtOutlook to control Microsoft Outlook applications:

• Currently only functionality for creating and sending mails is implemented.

CawtExcel:

• New procedures:
  FreezePanes, ScreenUpdate

CawtWord:

• Compatibility issue Unified signatures of AddText, AppendText and AddParagraph, AppendParagraph.
  Changed handling of text ranges.
• New procedures:
  SelectRange, GetRangeInformation, CreateRange, SetRangeFontName, SetRangeStyle, SetRangeFontSize, InsertText, AddText, GetNumCharacters, AddPageBreak, ToggleSpellCheck

New Excel and PowerPoint utility procedures

CawtCore:

• New procedure:
  ColorToRgb

CawtExcel:

• Added support for reading and writing CSV files with multi-line cells.
• New procedures:
  UseImgTransparency, WorksheetToImg, ImgToWorksheet, SetRowHeight, SetRowsHeight, GetRangeFillColor, SetHyperlinkToFile, SetHyperlinkToCell, SetLinkToCell, SetRangeTooltip

CawtPpt:

• Extended CopySlide to copy slides between presentations.
  
• Extended AddPres with optional parameter for template file.
  
• Extended AddSlide to supply a custom layout object as type parameter.
• New procedures:
  MoveSlide, GetTemplateExtString, GetNumCustomLayouts, GetCustomLayoutName, GetCustomLayoutId

External packages:

• Updated Twapi version to 4.0.61.

New Excel utility procedures

CawtExcel:

• Compatibility issue Procedures GetRowValues and GetColumnValues: Changed startRow resp. startCol to default value 0 instead of 1.
• Improved and corrected handling of sparse matrices.
• Bug fix in excelCsv module.
• New procedures:
  GetWorksheetAsMatrix, GetMaxRows, GetMaxColumns, GetFirstUsedRow, GetLastUsedRow, GetFirstUsedColumn, GetLastUsedColumn

External packages:

• Updated Twapi version to 4.0b53 to fix a bug with sparse matrices as well as core dumps with Word 2013.

New Excel utility procedures

CawtExcel:

• New procedures:
  SetCommentDisplayMode, SetRangeComment, SetRangeMergeCells, SetRangeFontSubscript, SetRangeFontSuperscript, GetRangeCharacters

Support for Office 2013 and 64-bit Office versions

Overall changes:

• Added support for Office 2013.
• Added support for 64-bit Office.
• Improved test suite.

CawtWord:

• New procedures:
  SaveAsPdf, UpdateFields, CropImage

CawtExcel:

• New procedures:
  CopyWorksheetBefore, CopyWorksheetAfter, GetWorksheetIndexByName, IsWorksheetProtected, IsWorksheetVisible, SetWorksheetTabColor, UnhideWorksheet, DiffExcelFiles

External packages:

• Updated Img extension to version 1.4.2 (32-bit and 64-bit).
• Updated Tablelist to version 5.10.

New Excel utility procedures

CawtExcel:

• New procedures:
  ExcelFileToMediaWikiFile, ExcelFileToWikitFile, ExcelFileToRawImageFile, RawImageFileToExcelFile, ExcelFileToMatlabFile, MatlabFileToExcelFile, GetTablelistValues, SetTablelistValues

New module CawtOcr

Overall changes:

• Added new module CawtOcr for automation of Office Document Imaging.

CawtCore:

• New procedures:
  Clipboard2Img, Img2Clipboard

CawtExcel:

• New procedure:
  SetRangeBorder

External packages:

• Update of Twapi version to 4.0b22.
• Update of Img version to 1.4.1.

Added CAWT starkits

Overall changes:

• Added support to create a CAWT Starkit.

CawtExcel:

• Extended Excel chart generation.

External packages:

• Update of Twapi version to 4.0a16 (binary starkit compatible version).

Extended functionality and renaming from TcomOffice to CAWT

• Replaced Tcom with Twapi for COM access.
• Added support for PowerPoint, Internet Explorer, Google Earth and Matlab.
• Added user and reference manual.
• Unification of procedure names.
• Supports Microsoft Office versions 2003, 2007, 2010.

Extended functionality

• New TcomExcel functionality:
  Support for Matlab MAT-Files (Level 4) and photo images (1-channel float RAW).

Extended functionality and renaming of extension

• Renamed package to TcomOffice.
• New module TcomWord for Word automation (rudimentary).
• New TcomExcel procedures: WordTableToWorksheet, WorksheetToWordTable.
• Miscellaneous code and documentation cleanup.

Extended functionality

• New procedures:
  SetMatrixValues, GetMatrixValues, TablelistToWorksheet, WorksheetToTablelist
• New module excelCsv.tcl for handling CSV data (used in clipboard copy and paste).
• Two new test programs for new procedures.
• Miscellaneous code and documentation cleanup.

Extended functionality

• Added support for Excel 2010.

Bug fixes and extended test programs

• Improved support for Excel 97 and 2007.
• Extended test suite.
• New generic AddLineChart procedure.
• Incompatibility: Renamed Add*Chart procedures to Add*ChartSimple.

Extended functionality and bug fixes

• Added support for Excel 2007 (Thanks to Cary Campbell).
• New functions for dealing with images.

Initial release

• Support for Excel 2000 and 2003.