Download Cawt User Manual - poSoft

Transcript
CAWT - COM Automation With Tcl
GetVersion
GetWorkbookName
GetWorksheetAsMatrix
GetWorksheetIdByIndex
GetWorksheetIdByName
GetWorksheetIndexByName
GetWorksheetName
HideColumn
ImgToWorksheet
InsertImage
IsWorkbookProtected
IsWorksheetProtected
IsWorksheetVisible
ListToCsvRow
MatlabFileToExcelFile
MatlabFileToWorksheet
MatrixToClipboard
MatrixToCsvString
MediaWikiFileToExcelFile
MediaWikiFileToWorksheet
Open
OpenNew
OpenWorkbook
PlaceChart
Quit
RawImageFileToExcelFile
RawImageFileToWorksheet
ReadCsvFile
ReadMatlabFile
ReadMatlabHeader
ReadMediaWikiFile
ReadRawImageFile
ReadRawImageHeader
ReadWikitFile
ResizeChartObj
SaveAs
SaveAsCsv
SaveChartAsImage
SaveChartObjAsImage
ScaleImage
ScreenUpdate
Search
SelectAll
SelectCellByIndex
SelectRangeByIndex
SelectRangeByString
SetCellValue
SetChartMaxScale
SetChartMinScale
SetChartObjPosition
CAWT User Manual
Return the version of an Excel application.
Return the name of a workbook.
Return worksheet table as a matrix.
Find a worksheet by its index.
Find a worksheet by its name.
Find a worksheet index by its name.
Return the name of a worksheet.
Hide or unhide a column.
Put a photo image into a worksheet.
Insert an image into a worksheet.
Check, if a workbook is protected.
Check, if a worksheet is content protected.
Check, if a worksheet is visible.
Return a list of column values as a CSV encoded row
string.
Convert a Matlab table file to an Excel file.
Insert the data values of a Matlab file into a worksheet.
Copy a matrix into the clipboard.
Return a CSV encoded table string from a matrix list.
Convert a MediaWiki table file to an Excel file.
Insert the values of a MediaWiki table file into a worksheet.
Open an Excel instance. Use an already running instance,
if available.
Open a new Excel instance.
Open a workbook, i.e. load an Excel file.
Place an existing chart into a worksheet.
Quit an Excel instance.
Convert a raw photo image file to an Excel file.
Insert the pixel values of a raw photo image into a
worksheet.
Read a CSV table file into a matrix.
Read a Matlab file into a matrix.
Read the header of a Matlab file.
Read a MediaWiki table file into a matrix.
Read a raw photo image into a matrix.
Read the header of a raw photo image.
Read a Wikit table file into a matrix.
Set the position and size of a chart object.
Save a workbook to an Excel file.
Save a worksheet to file in CSV format.
Obsolete: Replaced with SaveChartObjAsImage in version
1.0.1
Save a chart as an image in a file.
Scale an image.
Toggle the screen updating of an Excel application window.
Find a string in a worksheet cell range.
Select all cells of a worksheet.
Select a cell by its row/column index.
Select a range by specifying a numeric cell range.
Select a range by specifying an Excel range string in A1
notation.
Set the value of a cell.
Set the maximum scale of an axis of a chart.
Set the minimum scale of an axis of a chart.
Set the position of a chart object.
Version 2.1.0, 2015-09-01
Copyright © 2008-2015 by Paul Obermeier. All rights reserved.
Page 12 of 32