It is feasible to use excel to actually draw in Autocad for what you want its a bit lengthy, most people who have written this type of thing have spent years coding in excel so have macros etc built up..
If you break it down into steps there are just so many.
Draw plot title block
Draw chainages and lines
Draw inverts
Draw depth to invert
Draw ns level
Draw slope text
Draw verticals at correct chainage
Draw surface profile
Draw pipe profile
Phew out of breath and no where finished.
Lastly there is some lisp out there for "draw long section" do a search.