KozMos OASis-XLS was designed to make link between AutoCAD and Excel so that we can make data
exchange between the two famous software. By doing so, we used the most latest AutoCAD ActiveX
The main design idea of KozMos OASis-XLS is to establish the linkage between AutoCAD and Excel
and provide users a group of useful functions to get access the control of Excel data.
KozMos OASis-XLS divide the utilities into three different parts. Each part contain functions
to operate certain objects in Microsoft Excel. The three group are: Application, Sheet and cell.
The Application part can establish the linking between AutoCAD and Excel, and provide the
functions to open and close Excel sessions within AutoCAD.
The Sheet part provide functions to operate Excel Sheet object such as Add new sheet, Rename
exisiting Sheet and Delete Sheet.
The Cell part is the most important and most complex part of OASis-XLS. The cell part will
provide more than 20 functions to control Excel Cell Object. By invoking these functions, we can
get/put value to cell; get/put cell background color; get/put cell content annotation color and
process one cell or a column/row of cells.Test and Sample codes.
The design project of KozMos OASis-XLS also contain one group beyond the three functions parts:
TEST Group. The TEST group provide users simple example codes based on OASis-XLS to do simple
purpose between AutoCAD and Excel.