Here is a table create example, that has 1/2 solved you problem you then need a Autocad <-> excel lisp and there are lots of them out there. You then fill the correct table cell address much like excel.
Code:
; example of creating a table
; By Alan H July 2017
; sum of column row 10 column 1 ie 2nd column
; (vla-settext obj 10 1 "=sum(B2:B7)")
; get number of rows
; (vla-get-rows obj)
; get number of columns
; (vla-get-columns obj)
; insert a row add only 1 row newrownum +1 to number of columns
; (vla-InsertRows obj newrownum (vla-GetRowHeight obj rownum) 1)
(defun ex_table (/ colwidth numcolumns numrows objtable rowheight sp doc)
(vl-load-com)
(setq sp (vlax-3d-point '(0 0 0))) ; or use getpoint
(setq doc (vla-get-activedocument (vlax-get-acad-object) ))
(setq vgms (vla-get-paperspace doc))
(setq numrows 5)
(setq numcolumns 5)
(setq rowheight 0.5)
(setq colwidth 30)
(setq objtable (vla-addtable vgms sp numrows numcolumns rowheight colwidth))
(vla-settext objtable 0 0 "TABLE title")
(vla-settext objtable 1 0 "A")
(vla-settext objtable 1 1 "B")
(vla-settext objtable 1 2 "C")
(vla-settext objtable 1 3 "D")
(vla-settext objtable 1 4 "E")
(vla-settext objtable 2 0 "1")
(vla-settext objtable 3 0 "2")
(vla-settext objtable 4 0 "3")
(vla-setcolumnwidth objtable 0 15) ; 0 is first column
(vla-setcolumnwidth objtable 1 30)
(vla-setcolumnwidth objtable 2 60)
(command "_zoom" "e")
(princ)
)
(ex_table)