CAWT 2.4.0

CAWT is a TWAPI-based TCL utility package to interact with COM interfaces on Windows systems. It provides specialised bindings for Word, Excel, PowerPoint, MSIE, Outlook, Matlab, and Google Earth.

Tags tcl c win32 com twapi word excel matlab
License BSDL
State stable

Recent Releases

2.4.020 Jun 2017 18:25 major feature: New module CawtReader. Compatibility : Excel::ExcelFileToHtmlFile has changed signature. Now uses parameter args for extended options. CawtReader: Added basic functionality for Acrobat Reader (not via COM). CawtExcel: Extended module excelHtml to convert Excel hyperlinks. New procedures in CawtWord: IsValidCell. External packages: Updated Tablelist to version 5.17. Updated Twapi to version 4.2a5.
2.3.112 Dec 2016 09:45 minor feature: Enhanced functionality in Core and Office modules. CawtExcel: Extended Excel module excelImgRaw to support 16-bit integer images. New procedures in CawtCore: CheckBoolean. New procedures in CawtExcel: GetCellComment. New procedures in CawtWord: Search SetRangeFontBackgroundColor. External packages: Updated Img (32 and 64 bit) to version 1.4.6. Updated Tablelist to version 5.16.
2.3.017 Aug 2016 03:18 major feature: New module CawtOneNote. Compatibility : Excel::GetRangeAsIndex now returns a 2-element (cell) or 4-element (range) list. Previous behaviour was to always return a 4 element list. CawtOneNote: Added basic functionality for Microsoft OneNote. Added script OneNoteInfo.tcl to retrieve information from OneNote. New procedures in CawtExcel: DuplicateColumn, DuplicateRow, GetHiddenRows, HideRow, InsertColumn, InsertRow, GetColumnNumber, ShowWorksheet, IsWorksheetEmpty, GetRangeWrapText, SetRangeWrapText, SetRangeValues, GetRangeValues, IsWorkbookId, GetWorkbookIdByName, IsWorkbookOpen, SetNamedRange, GetNamedRange, GetNamedRangeNames. New procedures in CawtOutlook: CreateHtmlMail. External packages: Updated Tablelist to version 5.15. Updated Twapi to version 4.2a3. New package tDOM 0.8.3 (needed for CawtOneNote).
2.2.013 Dec 2015 03:15 major feature: Enhanced functionality in Core and Office modules. Compatibility : AddWorksheet now adds the new sheet at the end, as was already written in the documentation. Previous behaviour was to insert before active worksheet. 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. CawtExcel: 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 in CawtCore: GetColor, GetColorNames, IsHexColor, IsNameColor, IsOfficeColor, IsRgbColor OfficeColorToRgb, RgbToOfficeColor. New procedures in CawtExcel: CopyRange, GetCurrencyFormat, GetRangeFormat. New procedures in CawtPpt: AddShape, ConfigureShape, ConnectShapes, ConfigureConnector. New procedures in CawtWord: SetHyperlinkToFile.
2.1.211 Nov 2015 06:45 minor feature: Extended support for Excel page setup. 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. New procedures in CawtCore: SetPrinterCommunication, ValueToPoints, PointsToCentiMeters, PointsToInches. New procedures in CawtExcel: SetWorksheetPrintOptions, SetWorksheetPaperSize, SetWorksheetMargins, SetWorksheetFooter, SetWorksheetHeader.
2.1.002 Sep 2015 10:25 major feature: Updated Twapi to version 4.2.a1, because of new Twapi functionality "tclcast bstr" and to retrieve document properties. Added support to generate a CAWT starpack. CawtExcel: Take hidden flag of both Excel and tablelist columns into account in procedures TablelistToWorksheet and WorksheetToTablelist. SetCellValue and SetRangeFormat using new TclString procedure. CawtPpt: Extended functionality of ExportPptFile and ExportSlides to take into account slide comments regarding export file names. New procedures in CawtCore: TclString. New procedures in CawtExcel: DeleteColumn, DeleteRow, HideColumn, GetHiddenColumns, GetDecimalSeparator (replacing GetFloatSeparator), GetThousandsSeparator, GetNumberFormat (replacing GetLangNumberFormat). New procedures in CawtPpt: AddTextbox, AddTextboxText, SetTextboxFontSize, GetNumComments, GetComments, GetCommentKeyValue. New procedures in CawtWord: AddContentControl, SetContentControlDropdown, SetContentControlText, GetDocumentProperties, GetDocumentProperty, SetDocumentProperty.
2.0.031 Mar 2015 12:45 minor feature: Ensembled all CAWT namespaces. All Office enumerations are stored in module specific hash tables. Updated and extended user manual. Added application EnumExplorer.tcl to display Office enumerations. New module excelHtml.tcl for HTML export of Excel tables. 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. CawtExcel: New implementation of InsertImage. CawtWord: Extended procedure UpdateFields to update TablesOfContents and TablesOfFigures of a document. New procedures in CawtCore: GetApplicationVersion, IsApplicationId, PushComObjects, PopComObjects, PrintNumComObjects, CheckComObjects, GetComObjects, GetNumComObjects Replaced procedure IsValidId with IsComObject New procedures in CawtExcel: GetRangeAsIndex, GetRangeAsString, GetRangeTextColor New procedures in CawtWord: ScaleImage, SetInternalHyperlink, InsertFile, DiffWordFile .
1.2.014 Dec 2014 14:45 major feature: Compatibility issue: Incompatible changes in module CawtWord. Removed parameter docId from all procedures, which had both docId and rangeId parameters: SetRangeStartIndex, SetRangeEndIndex, ExtendRange, AddText, SetHyperlink, AddTable. CawtExcel: Added optional startRow parameter to TablelistToWorksheet. Extended test suite for changed and new procedures. New procedures in CawtWord: GetDocumentId, SetRangeFontUnderline, CreateRangeAfter, InsertCaption, ConfigureCaption, AddBookmark, GetBookmarkName, SetLinkToBookmark, GetListGalleryId, GetListTemplateId, InsertList