在《二次开发》看到的《VL与电子表格》中的一段程序
(defun DSX-Excel-Put-ColumnList (lst startrow startcol) (foreach itm lst (msxl-put-value (DSX-Excel-Get-Cell range startrow startcol) itm ) (setq startrow (1+ startrow)) ); repeat )
1。上面代码中红色部分在哪里定义的?我加载了程序运行后出现
创建一个新的 Excel 电子表格文件...; 错误: no function definition: DSX-EXCEL-GET-CELL
2。如果是EXCEL2003那么下面的程序应该怎么写呢?
(defun DSX-Load-TypeLib-Excel ( / tlbfile tlbver out) (cond ( (null msxl-xl24HourClock) (if (setq tlbfile (DSX-TypeLib-Excel)) (progn (setq tlbver (substr (vl-filename-base tlbfile) 6)) (cond ( (= tlbver "9") (princ "\n初始化 Microsoft Excel 2000...") ) ( (= tlbver "8") (princ "\n初始化 Microsoft Excel 97...") ) ( (= (vl-filename-base tlbfile) "Excel.exe") (princ "\n初始化 Microsoft Excel XP...") ) ) (vlax-import-type-library :tlb-filename tlbfile :methods-prefix "msxl-" :properties-prefix "msxl-" :constants-prefix "msxl-" ) (if msxl-xl24HourClock (setq out T)) ) ) ) ( T (setq out T) ) ) out ) |