Cawt User Manual - poSoft
Contents
1. MatrixToCsvString CSV File SaveAsCsv Figure 2 Module excelCsv CAWT User Manual Version 1 2 0 December 2014 Page 6 of 18 Copyright 2008 2014 by Paul Obermeier All rights reserved CAWT COM Automation With Tcl 2 3 2 Module excelTablelist Module excelTablelist Procedure overview GetTablelistValues SetMatrixValues Matrix SetTablelistValues List of lists GetMatrixValues TablelistfoWorksheet WorksheetToTablelist Figure 3 Module excelTablelist 2 3 3 Module excelMatlabFile Module excelMatlabFile Procedure overview ReadMatlabFile SetMatrixValues OpenWorkbook Matrix WriteMatlabFile List of lists GetMatrixValues MatlabFileToWorksheet WorksheetToMatlabFile MatlabFileToExcelFile ExcelFileToMatlabFile Figure 4 Module excelMatlabFile 2 3 4 Module excelWord Module excelWord Procedure overview Word GetMatrix Values SetMatrixValues Matrix Word SetMatrix Values List of lists GetMatrixValues WordTableToWorksheet WorksheetToWordTable Figure 5 Module excelWord CAWT User Manual Version 1 2 0 December 2014 Page 7 of 18 Copyright 2008 2014 by Paul Obermeier All rights reserved CAWT COM Automation With Tcl 2 3 5 Module excellmgRaw Module excellmgRaw Procedure overview ReadRawlmageFile SetMatrixValues OpenWorkbook Matrix WriteRawlmageFile List of lists GetMatrixValues RawlmageFileToWorksheet2. WorksheetToRawimageFile RawlmageFileToExcelFile ExcelFileToRawimageFile Figure 6 Module excellmgRaw 2 3 6 Module excelMediaWiki Module excelMediaWiki Procedure overview ReadMediaWikiFile SetMatrixValues OpenWorkbook Matrix WriteMediaWikiFile List of lists GetMatrixValues WorksheetToMediaWikiFile MediaWikiFile ToExcelFile ExcelFileToMediaWikiFile Figure 7 Module excelMediaWiki 2 3 7 Module excelWikit Module excelWikit Procedure overview ReadWikitFile SetMatrixValues OpenWorkbook Matrix WriteWikitFile List of lists GetMatrixValues WikitFileToWorksheet WorksheetToWikitFile WikitFileToExcelFile ExcelFileToWikitFile Figure 8 Module excelWikit CAWT User Manual Version 1 2 0 December 2014 Page 8 of 18 Copyright 2008 2014 by Paul Obermeier All rights reserved CAWT COM Automation With Tcl 2 4 CawtExplorer Automation for Internet Explorer The procedures of package CawtExplorer are implemented in namespace Explorer The name of the controlled application is InternetExplorer Application They provide functionality for the following domains Domain Examples Application handling Open Quit URL navigation Navigate GoBack GoHome See the test programs Explorer tcl for examples on how to use the procedures of this package Note If running on Windows Vista or 7 you have to lower the securit
3. e Incompatible changes in module CawtWord Removed parameter docld from all procedures which had both docld and rangeld parameters e SetRangeStartindex SetRangeEndIndex ExtendRange e AddText SetHyperlink AddTable CawtExcel e Added optional startRow parameter to TablelistT oWorksheet Extended test suite for changed and new procedures New procedures in CawtWord e GetDocumentid SetRangeFontUnderline CreateRangeAfter InsertCaption ConfigureCaption AddBookmark GetBookmarkName SetLinkToBookmark GetListGalleryld GetListTemplateld InsertList CAWT User Manual Version 1 2 0 December 2014 Page 18 of 18 Copyright 2008 2014 by Paul Obermeier All rights reserved
4. that on Windows the path must be written with slashes not backslashes gt set TCLLIBPATH C myCawt If suitable versions of Twapi Tklmg Base64 or Tablelist are already available on your machine you may remove the appropriate folders from the Externals subfolder Otherwise you should move these packages into the same folder where you have copied Cawt to CAWT User Manual Version 1 2 0 December 2014 Page 4 of 18 Copyright 2008 2014 by Paul Obermeier All rights reserved CAWT COM Automation With Tcl 2 Packages in Detail This chapter explains the different packages of CAWT For a detailed description of the available procedures in the different sub packages see the CAWT reference manual available at the CAWT homepage or in the distribution 2 1 CawtCore Basic automation functionality The procedures of package CawtCore are implemented in namespace cawt They provide functionality for the following domains Domain Examples Package information HavePkg GetPkgVersion Conversion functionality CentiMetersToPoints RgbToColor TclBool COM access via Twapi GetOrCreateApp IsValidId Destroy Common Office functionality GetApplicationName Testing utilities CheckString CheckNumber CheckMatrix Image utilities ClipboardToImg ImgToClipboard 2 2 CawtEarth Automation for Google Earth The procedures of package CawtEarth are implemente
5. CAWT sub packages can be loaded with a single command package require cawt Note Package names are all lower case The next figure shows the architecture of the CAWT package CAWT User Manual Version 1 2 0 December 2014 Page 2 of 18 Copyright 2008 2014 by Paul Obermeier All rights reserved CAWT COM Automation With Tcl CAWT Overview of packages Microsoft Office packages CawtExcel CawtOutlook Microsoft Excel Microsoft Outlook CawtPpt CawtWord Microsoft PowerPoint Microsoft Word CawtEarth CawtExplorer CawtOcr Google Earth MS Internet Explorer MS Document Imaging CawtMatlab MathWorks Matlab CawtCore Basic Automation Figure 1 Overview of CAWT packages 1 2 Dependencies The following table shows a list of the external Tcl packages used in the CAWT infrastructure from Tellib textutil included in CAWT developer distribution Lib Version Comment URL Twapi gt 4 0 Mandatory Included in CAWT http twapi magicsplat com user distribution Tklmg gt 1 4 1 Optional Included in CAWT http sourceforge net projects tkimg user distribution http www poSoft de html extTklmg html Base64 Optional Included in CAWT http sourceforge net projects tcllib user distribution Tablelist gt 4 Optional Included in CAWT http www nemethi de user distribution Ruff 0 4 Included in CAWT developer http woof magicsplat com ruff_ho
6. User Manual Version 1 2 0 December 2014 Page 9 of 18 Copyright 2008 2014 by Paul Obermeier All rights reserved CAWT COM Automation With Tcl Domain Examples Application handling Open Quit GetVersion Mail handling CreateMail SendMail See the test programs Outlook tcl for examples on how to use the procedures of this package 2 8 CawtPpt Automation for Microsoft PowerPoint The procedures of package CawtPpt are implemented in namespace Ppt The name of the controlled application is PowerPoint Application They provide functionality for the following domains Domain Examples Application handling Open Quit GetVersion Presentation handling OpenPres AddPres SaveAs Close Slide handling AddSlide CopySlide ShowSlide ExportSlide SlideShow handling UseSlideShow SlideShowFirst SlideShowNext Custom layout handling GetNumCustomLayouts GetCustomLayoutName See the test programs Ppt tcl for examples on how to use the procedures of this package 2 9 CawtWord Automation for Microsoft Word The procedures of package CawtWord are implemented in namespace Word The name of the controlled application is Word Application They provide functionality for the following domains Domain Examples Application handling Open Quit GetVersion Document handling OpenDocument AddDocument SaveAs Close Table ha
7. 08 2014 by Paul Obermeier All rights reserved CAWT COM Automation With Tcl 5 Inside CAWT The information in this chapter is for programmers who want to extend and improve CAWT Download the developer distribution from the CAWT homepage This distribution contains in addition to the user distribution the documentation source files a Word and a PowerPoint file the Ruff and textutil packages for generating the reference documentation out of the Tcl sources as well as some additional utility scripts Create or update Office enumeration values The files containing the enumeration values of the Office applications Excel excelConst tcl PowerPoint pptConst tcl1 Word wordConst tc1 and Outlook outlookConst tcl are automatically generated with script createConstFile tcl The enumeration values of the current CAWT distribution are based on Microsoft Office 2013 If you have a newer Office version and want to update the enumeration files execute the batch program createConstFiles bat which is located at the root directory of CAWT Before calling the batch program you should edit it to fit the locations of your Office programs Note also that the enumeration files are created in the CAWT root directory so you have to copy them into the appropriate sub folders by hand but check and compare the differences to the existing files first Create or update CAWT documentation The CAWT documentation comes in 2 parts the use
8. CAWT COM Automation With Tcl CAWT COM Automation With Tcl T INTRODUCTION isc aada soraira aa ccm ededvatdasaudencceduetadssiaaaetdetwetadastidiceastucs 2 1 1 Architecture Oveni Wo indi a 2 1 2 DNS dos 3 1 3 Installation and A A eeae eca 4 2 PACKAGES IN DETA Escoria AA AA AR na 5 2 1 CawtCore Basic automation functionality ooooooccccnnnnccinncanoccccnnnnccnnnnnanannnnnnncnnnnnnnn nn 5 2 2 CawtEarth Automation for Google Earth oooooooooccccnnnccccnnccaocnccnnncncnnnnananoncnnnncnnnnnnnn nano 5 2 3 CawtExcel Automation for Microsoft Excel ccccccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeseeeeeeeeees 5 Del Module DAA cance Soot NS 6 2 322 Module exCellablelist initaneti Gen ec cst eee GG a beac Bhai bs Cen Rha na eh Gb 7 2 3 3 lt Mod le ex elMatlabF leinni a E EEE EAEE AE E ido 7 2 3 4 Module excel Word no eene ai EEEE E EEE AREAS T IEE EASAN Eaa Rari 7 2 3 3 Module excellmeRaW sii isaac Ben chguatenn sabi oeuatag ean csdesTorsgeatants amp 2 3 6 Module exceLMediawiki cccccccccccccccsssscecessceseeesscesecesssececesseesecssssesecsesseeecsessesecsesssseceesaeeeensaas 8 DIS Module excelWikit AAA ashe A A ti 8 2 4 CawtExplorer Automation for Internet Explorer ooooonnnnccnncccccnnccccnnncananccnnnncnnnnnnannnnnos 9 2 5 CawtMatlab Automation for MathWorks Matlab cccccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 9 2 6 CawtOcr Automation for Microsoft Document Imaging ooocccccccccinnccnanacininnncnananana
9. Img extension to version 1 4 2 32 bit and 64 bit Update Tablelist to version 5 10 New procedures in CawtWord e SaveAsPdf e UpdateFields e Croplmage New procedures in CawtExcel e CopyWorksheetBefore CopyWorksheetAfter GetWorksheetIndexByName IsWorksheetProtected IsWorksheetVisible SetWorksheetTabColor UnhideWorksheet CAWT User Manual Version 1 2 0 December 2014 Page 16 of 18 Copyright 2008 2014 by Paul Obermeier All rights reserved CAWT COM Automation With Tcl e DiffExcelFiles 1 0 5 2014 01 26 New procedures in CawtExcel e SetCommentDisplayMode SetRangeComment e SetRangeMergeCells GetRangeCharacters e SetRangeFontSubscript SetRangeFontSuperscript 1 0 6 2014 04 21 Improved and extended test suite Updated Twapi version to 4 0653 to fix a bug with sparse matrices as well as core dumps with Word 2013 Improved and corrected handling of sparse matrices in Excel Bug fix in excelCsv module Possible incompatibility in GetRowValues and GetColumnValues Changed startRow resp startCol to default value 0 instead of 1 New procedures in CawtExcel e GetWorksheetAsMatrix e GetMaxRows GetMaxColumns e GetFirstUsedRow GetLastUsedRow e GetFirstUsedColumn GetLastUsedColumn 1 0 7 2014 06 14 Updated Twapi version to official 4 0 61 CawtExcel e Added support for reading and writing CSV files with multi line cells CawtPpt e Extended CopySlide to copy slides between pres
10. Page 12 of 18 Copyright 2008 2014 by Paul Obermeier All rights reserved CAWT COM Automation With Tcl Matlab 02 MFile tcl Ocr 01 Basic tcl Test CawtMatlab procedures for executing Matlab commands Test basic functionality of the CawtOcr package Ocr 02 Misc tcl Test miscellaneous CawtOcr procedures Outlook 01 Basic tcl Test basic functionality of the CawtOutlook package Outlook 02 Mail tcl Test mail functionality of the CawtOutlook package Ppt 01 Basic tcl Test basic functionality of the CawtPpt package Ppt 02 Misc tcl Test miscellaneous CawtPpt procedures like adding slides inserting images and saving slides as image files Ppt 03 Add tcl Test CawtPpt procedures for adding and copying slides Ppt 04 __ Present tcl Test CawtPpt procedures for presenting a slide show Ppt 05 _Export tcl Test CawtPpt procedures for exporting a PowerPoint presentation as HTML slide show Ppt 06 CustomLayout tcl Test CawtPpt procedures for using PowerPoint custom layouts Word 01 Basic tcl Test basic functionality of the CawtWord package Word 02 Table tcl Test CawtWord procedures related to Word table management Word 03 Text tcl Test CawtWord procedures for handling text Word 04 Find tcl Test CawtWord procedures related to search and replace functionality Word 05 Report tcl Test CawtW
11. d in namespace Earth The name of the controlled application is GoogleEkarth ApplicationGE They provide functionality for the following domains Domain Examples Application handling Open Quit Camera positioning SetCamera See the test programs Earth tcl for examples on how to use the procedures of this package 2 3 CawtExcel Automation for Microsoft Excel The procedures of package CawtExcel are implemented in namespace Excel The name of the controlled application is Excel Application They provide functionality for the following domains Domain Examples Application handling Open Quit GetVersion Workbook handling OpenWorkbook AddWorkbook SaveAs Close Worksheet handling AddWorksheet DeleteWorksheet CopyWorksheet Chart handling ChartObjToClipboard CreateChart AddLineChart Insert values SetCellValue SetRowValues SetMatrixValues Retrieve values GetCellValue GetRowValues GetMatrixValues Formatting functionality SetColumnWidth SetHyperlink SetRangeTextColor Clipboard functionality ClipboardToMatrix ClipboardToWorksheet External file handling Csv Raw Images MediaWiki Wikit Matlab files CAWT User Manual Version 1 2 0 December 2014 Page 5 of 18 Copyright 2008 2014 by Paul Obermeier All rights reserved CAWT COM Automation With Tcl External table tools handling Tablelist Word tables The com
12. entations e Extended AddPres with optional parameter for template file e Extended AddSlide to supply a custom layout object as type parameter Extended test suite for changed and new procedures New procedures in CawtCore e ColorToRgb New procedures in CawtExcel e UselmgTransparency WorksheetTolmg ImgToWorksheet e SetRowHeight SetRowsHeight e GetRangeFillColor e SetHyperlinkToFile SetHyperlinkToCell SetLinkToCell e SetRangeTooltip New procedures in CawtPpt e MoveSlide e GetTemplateExtString e GetNumCustomLayouts e GetCustomLayoutName GetCustomLayoutld 1 1 0 2014 08 30 Compatibility issue e Incompatible changes in module CawtWord e Unified signatures of AddText AppendText and AddParagraph AppendParagraph e Changed handling of text ranges New module CawtOutlook to control Microsoft Outlook applications e Currently only functionality for creating and sending mails is implemented Extended test suite for changed and new procedures New procedures in CawtExcel e FreezePanes ScreenUpdate New procedures in CawtWord e SelectRange GetRangelnformation CreateRange e SetRangeFontName SetRangeStyle SetRangeFontSize e InsertText AddText GetNumCharacters CAWT User Manual Copyright 2008 2014 by Paul Obermeier All rights reserved Version 1 2 0 December 2014 Page 17 of 18 CAWT COM Automation With Tcl e AddPageBreak ToggleSpellCheck 1 2 0 2014 12 14 Compatibility issue
13. ice and TcomExcel Version Date Release notes 2008 09 11 Initial release Support for Excel 2000 and 2003 2009 09 19 Extended functionality Added support for Excel 2007 2010 10 29 Bug fixes and extended test programs 2011 01 13 Extended functionality Added support for Excel 2010 2011 04 05 Extended functionality 2011 07 17 New module TcomWord for Word automation 2011 08 28 Extended functionality 2012 12 23 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 1 0 1 2013 04 28 Extended Excel chart generation Updated Twapi version to 4 0a16 Added support to generate a CAWT starkit 1 0 2 2013 07 28 Updated Twapi version to 4 0b22 Updated Img version to 1 4 1 Added new module CawtOcr New procedures in CawtCore e Clipboard2Img Img2Clipboard New procedures in CawtExcel e SetRangeBorder 1 0 3 2013 08 30 New procedures in CawtExcel e ExcelFileToMediaWikiFile ExcelFile ToWikitFile e ExcelFileToRawlmageFile RawlmageFileToExcelFile e ExcelFileToMatlabFile MatlabFileToExcelFile e GetTablelistValues SetTablelistValues 1 0 4 2013 11 23 Improved test suite Added support for Office 2013 Added support for 64 bit Office Updated
14. l rights reserved Version 1 2 0 December 2014 Page 13 of 18 CAWT COM Automation With Tcl gt RunTests bat Each test program accepts an optional string parameter If this parameter is set to auto the test program closes and quits the controlled application If this parameter is not set the controlled application stays open so the results can be viewed directly in the application window The RunTest tcl1 utility script calls all test programs available for a sub package by specifying the corresponding namespace name The test programs are called with the above mentioned auto parameter Additionally the script can be supplied with optional parameters to switch off either the tests or to switch off the code coverage checks If called without any parameters the script issues a help message onto standard output Usage RunTest tcl Options Namespace Namespace Run the test programs and code coverage checks for specified namespace s Namespaces usable Excel Ppt Word Outlook Ocr Earth Matlab Explorer Use all as namespace name to run tests and checks for all namespaces Options help Display this usage message and exit verbose Show the detailed results of the tests Default No notests Do not run the tests Default Run tests nocover Do not run the coverage checks Default Run coverage CAWT User Manual Version 1 2 0 December 2014 Page 14 of 18 Copyright 20
15. mands are grouped and implemented in the following modules Implementation file Description excelConst tel All Excel enumeration types excelBasic tcl Basic Excel commands excelUtil tcl Higher level utility commands excelChart tcl Higher level commands for chart creation excelCsv tel Commands for reading writing CSV files excelTablelist tcl Exchange Excel data with Tablelist excelMatlabFile tcl Exchange Excel data with Matlab MAT Files Level 4 files only excelWord tcl Exchange Excel data with Word tables exceliImgRaw tcl Exchange Excel data with Tk photo images 1 channel floating point RAW files only excelMediaWiki tcl Exchange Excel data with MediaWiki tables excelWikit tcl Exchange Excel data with Wikit tables See the following URL s for details on table file formats Matlab http Awww mathworks com help pdf_doc matlab matfile format paf Raw images http docs activestate com activetcl 8 5 img doc img raw html MediaWiki https meta wikimedia org wiki Help Table Wikit http wiki tcl tk 14 See the test programs Excel tcl for examples on how to use the procedures of this package The next chapters explain the Excel modules dealing with data exchange 2 3 1 Module excelCsv Module excelCsv Procedure overview ReadCsvFile WriteCsvFile SetMatrixValues OpenWorkbook GetMatrixValues Matrix CsvStringToMatrix List of lists
16. me distribution Tcllib Ruff needs the textutil module http sourceforge net projects tcllib Twapi It is recommended to use the official Twapi version 4 0 61 TkImg Needed only for some functionalities see the CawtExcel package for further details Base64 Needed for photo image to clipboard functionality Tablelist Needed only for the excelTablelist module CAWT User Manual Copyright 2008 2014 by Paul Obermeier All rights reserved Version 1 2 0 December 2014 Page 3 of 18 CAWT COM Automation With Tcl 1 3 Installation and Usage Installation of CAWT is simple and fast If you just want to play with the test programs to get an impression on how CAWT works unzip the user distribution file in a folder of your choice Then open a shell window go to folder TestPrograms of the CAWT distribution and execute a test program with a line as follows gt tclsh Excel 01 Basic tcl See also chapter 4 for scripts to run all or groups of test programs in batch mode If you want to use CAWT as a package for your own applications the Cawt folder should be copied into the library section of your Tcl installation ex C Tc1 1ib If write access to this Tcl directory is not permitted you can copy the Cawt directory somewhere else eg C myCawt To have Tcl look for packages in this location you must set the TCLLIBPATH environment variable with the above specified directory name as value Note
17. ncnos 9 2 7 CawtOutlook Automation for Microsoft Outlook ccccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 9 2 8 CawtPpt Automation for Microsoft PowerPOiNt ooooccccnnncnncccccnnncccnnnanananccnnnnncnnnnnnns 10 2 9 CawtWord Automation for Microsoft Word cccccccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 10 3 MISCELLANEOUS CAWT INFORMATION cooonocccccccccnconccnnnncccccoconannnannnnnnnorrrrnnnnnnaancnnnnnnnos 11 3 1 License into cia 11 3 2 Known EIS as hoa a ae r che a twine scans 11 4 TESTPROGRAM Sirio did avin Sembee baer rari ECR Sonar 12 4 1 TeostoVervieW nasa da aaa 12 4 2 Test exeCcU ON a dir ii E bi sd 13 5 INSIDE CA WI ata os lidad 15 6 RELEASE HISTORY evans ea I aa e exces reao aiaa Paap A AACN ENERE Ae a Euas aa dki nite ted 16 CAWT User Manual Version 1 2 0 December 2014 Page 1 of 18 Copyright 2008 2014 by Paul Obermeier All rights reserved CAWT COM Automation With Tcl 1 Introduction CAWT is a high level Tcl interface for scripting Microsoft Windows applications having a COM interface It uses Twapi for automation via the COM interface Currently packages for Microsoft Excel Word PowerPoint Outlook and Internet Explorer MathWorks Matlab and Google Earth are available Note that only Microsoft Office packages Excel Word and PowerPoint are in active development The other packages are proof of concept examples only CAWT sources are available at https sourcef
18. ndling AddTable GetNumRows SetCellValue GetCellValue Text handling AddParagraph AppendText AddText Range handling GetStartRange GetRangeStartIndex ExtendRange Search Replace functionality FindString ReplaceString ReplaceByProc Formatting functionality SetRangeFontBold SetRangeBackgroundColor Caption handling InsertCaption ConfigureCaption Bookmark handling AddBookmark GetBookmarkName SetLinkToBookmark List handling GetListGalleryld GetListTemplateld InsertList See the test programs Word tcl for examples on how to use the procedures of this package CAWT User Manual Version 1 2 0 December 2014 Page 10 of 18 Copyright O 2008 2014 by Paul Obermeier All rights reserved CAWT COM Automation With Tcl 3 Miscellaneous CAWT information This chapter contains miscellaneous information about CAWT 3 1 License information The CAWT package is copyrighted by Paul Obermeier and distributed under the BSD license CAWT relies on several other Tcl packages See the table in chapter 1 2 for links to these packages to get their license information 3 2 Known bugs There is an issue in CawtExcel with the differing floating point separators used in languages like German where the comma is the character used as the decimal point CAWT User Manual Version 1 2 0 December 2014 Page 11 of 18 Copyright 2008 2014 by Paul Obermeier All rights reserved CAWT COM A
19. ord procedures needed for generating a test report It is assumed that the test data is read from an external data sink ex file there are images to be inserted that are in a format Word does not know about and a summary should be printed at the first page Table 1 Test Programs The CAWT sub packages have been tested successfully with the above mentioned programs on the following operating systems and COM application versions Package Operating system Application version CawtEarth Windows XP Windows 7 Windows 8 6 2 7 1 2 CawtExcel Windows XP Windows 7 Windows 8 2003 2007 2010 2013 CawtExplorer Windows XP Windows 7 Windows 8 IE 8 IE 9 IE 11 CawtMatlab Windows XP R2007b CawtOcr Windows XP Windows 7 Windows 8 2003 2007 2010 2013 CawtOutlook Windows 7 Windows 8 2010 2013 CawtPpt Windows XP Windows 7 Windows 8 2003 2007 2010 2013 CawtWord Windows XP Windows 7 Windows 8 2003 2007 2010 2013 See chapter 2 4 for known issues with Internet Explorer on Windows 7 and 8 4 2 Test execution To execute a single test program execute it with the Tcl shell gt tclsh Excel 02 Misc tcl To execute all test programs of a sub package use the utility script RunTest tcl gt tclsh RunTest tcl Excel To execute all test programs of CAWT use the batch program RunTests bat CAWT User Manual Copyright 2008 2014 by Paul Obermeier Al
20. orge net projects cawt The CAWT homepage is at http www poSoft de html extCawt html The CAWT user distribution contains the Tcl sources documentation this document and a reference manual several test programs showing the use of the CAWT functionality and the needed external libraries Twapi TkImg Base64 and Tablelist see chapter 1 2 for details The CAWT developer distribution additionally contains scripts for generating the documentation the distribution packages and the CAWT Starkit It also includes the external packages Ruff and textutil see chapter 1 2 for details The developer distribution is intended for programmers who want to extend the CAWT package 1 1 Architecture overview The CAWT package currently consists of the following sub packages CawtCore Basic automation functionality CawtEarth Automation functionality for Google Earth CawtExcel Automation functionality for Microsoft Excel CawtExplorer Automation functionality for Microsoft Internet Explorer CawtMatlab Automation functionality for MathWorks Matlab CawtOcr Automation functionality for Microsoft Document Imaging CawtOutlook Automation functionality for Microsoft Outlook CawtPpt Automation functionality for Microsoft PowerPoint CawtWord Automation functionality for Microsoft Word Each sub package is implemented as a separate Tcl package and can be loaded explicitly with the Tcl package command ex package require cawtexcel All available
21. r manual and a reference manual The reference manual is created with the help of the Ruff package from inline documentation So if adding new procedures to the CAWT files be sure to also update the inline documentation The sources of the user manual are a Word template document and a PowerPoint presentation located in folder Documents UserManual The final documentation is created by Tcl script genCawtDoc tc1 which creates the reference manual by calling Ruff and the user manual by exporting the slides of the presentation and inserting them into the Word template document The final documents are then written into folder Documents Final If specifying the strings ref or user as command line parameter for script genCawtDoc tcl only the reference manual resp the user manual is generated Create a CAWT distribution To create a distribution both user and developer call Tcl script makeDist tcl Note that you should have updated the documentation before creating a distribution The location of the distribution output files and the program to create ZIP files are listed at the top of file makeDist tc1 and must be adapted to your local situation CAWT User Manual Version 1 2 0 December 2014 Page 15 of 18 Copyright 2008 2014 by Paul Obermeier All rights reserved CAWT COM Automation With Tcl 6 Release history The following table gives an overview of the release history of CAWT and it s predecessors TcomOff
22. utomation With Tcl 4 Test programs 4 1 Test overview The following test and demonstration programs are currently available Test Program Description Earth 01 Basic tcl Test basic functionality of the CawtEarth package Earth 02 MunichTour tcl Load position information into an Excel sheet read back that information and create a Tk GUI with buttons corresponding to these positions Clicking onto one of these buttons triggers Google Earth to fly to that position Excel 01 Basic tcl Test basic functionality of the CawtExcel package Excel 02 Misc tcl Test miscellaneous CawtExcel procedures like setting colors fonts and column width inserting formulas and images searching and page setup Excel 03 Add tcl Test CawtExcel procedures for adding and deleting workbooks and worksheets Excel 04 Insert tcl Test CawtExcel procedures for inserting data as rows columns or matrices Excel 05 Ranges tcl Test CawtExcel procedures for retrieving the number of used rows and columns Excel 06 Chart tcl Test CawtExcel procedures for creating charts and exporting charts as Tk photo images Excel 07 Csv tcl Test CawtExcel procedures related to CSV files Excel 08 Tablelist tcl Test CawtExcel procedures to exchange data between Excel and Tablelist Excel 09 WordTable tcl Test CawtExcel procedures to exchange data between Excel and Word tables E
23. xcel 10 Matrix tcl Test CawtExcel procedures to read data into a matrix and write matrix data into Matlab or RAW image files Excel 11 RawImage tcl Test CawtExcel procedures to exchange data between Excel and RAW photo images Excel 12 MatlabFile tcl Test CawtExcel procedures to exchange data between Excel and Matlab files Excel 13 MediaWiki tcl Test CawtExcel procedures to exchange data between Excel and MediaWiki tables Excel 14 Wikit tcl Test CawtExcel procedures to exchange data between Excel and Wikit tables Excel 15 Clipboard tcl Test CawtExcel procedures to exchange data between Excel and the Windows clipboard Excel 16 SetGet tcl Test CawtExcel procedures for setting and getting cell values Excel 17 Diff tcl Test CawtExcel procedure for diff ing Excel files Excel 18 SparseMatrix tcl Test CawtExcel procedures for handling sparse matrices Excel 19 MarkLink tcl Test CawtExcel procedures related to marking and linking cells Excel 20 ImgUtil tcl Test CawtExcel procedures for dealing with images Explorer 01 Basic tcl Test basic functionality of the CawtExplorer package Explorer 02 Misc tcl Test miscellaneous CawtExplorer functions like navigating to an URL and using fillscreen mode Matlab 01 Basic tcl Test basic functionality of the CawtMatlab package CAWT User Manual Version 1 2 0 December 2014
24. y settings like follows Internet Options gt Security gt Trusted Sites Low Internet Options gt Security gt Internet Medium unchecked Enable Protected Mode Internet Options gt Security gt Restricted Sites unchecked Enable Protected Mode 2 5 CawtMatlab Automation for MathWorks Matlab The procedures of package CawtMatlab are implemented in namespace Matlab The name of the controlled application is Matlab Application They provide functionality for the following domains Domain Examples Application handling Open Quit Command execution ExecCmd See the test programs Matlab tcl for examples on how to use the procedures of this package 2 6 CawtOcr Automation for Microsoft Document Imaging The procedures of package CawtOcr are implemented in namespace ocr The name of the controlled application is MODI Document They provide functionality for the following domains Domain Examples Application handling Open Close Character recognition Scan GetFullText GetWord GetWordStatistics See the test programs Ocr tcl for examples on how to use the procedures of this package 2 7 CawtOutlook Automation for Microsoft Outlook The procedures of package CawtOutlook are implemented in namespace outlook The name of the controlled application is Out look Application They provide functionality for the following domains CAWT
Download Pdf Manuals
Related Search