Just me but exploding a table into text and lines I think is a backwards step.
In simple terms you can read a selected excel range and create a table, the dotsoft solution is obviously more involved matching the excel workbook.
This is select range for anyone.
(setq UR (vlax-get-property (vlax-get-property myxl "ActiveSheet") "UsedRange"))
(setq CR (vlax-get-property UR "CurrentRegion"))
(setq RADD (vlax-get-property CR "Address"))
(setq cnt (vlax-get-property CR "Count"))