topic Re: Cross section data from excel to autocad in AutoCAD Forum

Cross section data from excel to autocad

omatdavid — Wed, 24 Aug 2022 21:03:36 GMT

I have a new challenge with cross section data for 4kmI road I was given it contains only chainages, offsets(left and right) and elevations for both before(binder coarse) and after(wearing coarse) please how can I arrange the data in excel and bring them to autocad. Thanks

Re: Cross section data from excel to autocad

TheCADnoob — Wed, 24 Aug 2022 21:24:34 GMT

Im not familiar with what you are describing.

Would you be able to provide some sample data?

What are you wanting the data to create in AutoCAD? Points, Lines, etc?

Re: Cross section data from excel to autocad

pendean — Wed, 24 Aug 2022 21:32:18 GMT

Can you share that XLS file here?
Are you using civil3D? Or just plain AutoCAD?

Re: Cross section data from excel to autocad

arshadmirza786 — Thu, 25 Aug 2022 07:02:29 GMT

Attached are my child hood 2 files ONE for centre line method other left to right (link DATA or copy past ) if any thing not clear let me know

Re: Cross section data from excel to autocad

arshadmirza786 — Thu, 25 Aug 2022 07:05:30 GMT

Sorry files were not attached

Re: Cross section data from excel to autocad

TheCADnoob — Thu, 25 Aug 2022 14:13:59 GMT

seems like you are most of the way there. I just changed some of the text formatting for the command and it looks like it will work. I separated the command that needed a carriage return onto a new line and included a "-" dash to use the command without calling up the dialog boxes. After that i just pasted it into the command line.

Re: Cross section data from excel to autocad

omatdavid — Thu, 25 Aug 2022 15:22:53 GMT

Here is a sample of the excel data file,I need to draw both binder and wearing in section show both at different chainages.Thanks

Re: Cross section data from excel to autocad

omatdavid — Thu, 25 Aug 2022 15:24:26 GMT

Data sample in excel

Re: Cross section data from excel to autocad

omatdavid — Thu, 25 Aug 2022 15:27:07 GMT

Any that can work either civil 3d or plan autocad.thanks

Re: Cross section data from excel to autocad

omatdavid — Thu, 25 Aug 2022 17:07:28 GMT

Same of data in excel

Re: Cross section data from excel to autocad

TheCADnoob — Thu, 25 Aug 2022 17:54:56 GMT

I think you have all the parts of the puzzle you need given the above.

Getting the excel data into a usable format is less an AutoCAD issue and feels more like something that some one in your office/industry would be able to help with more than I can. Per haps if you could explain how you would turn that data into a drawing manually I might understand what you are trying to do after that.