topic Table importing from excel in AutoCAD Forum

Table importing from excel

piotrekszczykutowicz17 — Tue, 14 Dec 2021 23:09:29 GMT

Hi,

I would like to knowe if there is a better way to import huge tables (5000x5000) from Excel to Autocad than data links while keeping Excel formatting and the view as if i were drawing everything in Autocad?

With a data link, it takes hours to import a table, and OLE is not accepted in the industry.

Re: Table importing from excel

Valentin_CAD — Wed, 15 Dec 2021 10:38:47 GMT

@piotrekszczykutowicz17 ,

Try this:

Importing Excel spreadsheet tables into AutoCAD-based products

Re: Table importing from excel

pendean — Wed, 15 Dec 2021 14:10:21 GMT

You will need to purchase a 3rd party add-on for the size of your Excel sheet: free-in-the-program has limits.

Re: Table importing from excel

TerryDotson — Fri, 17 Dec 2021 01:56:46 GMT

I would like to knowe if there is a better way to import huge tables (5000x5000) from Excel to Autocad than data links while keeping Excel formatting and the view as if i were drawing everything in Autocad?

With a data link, it takes hours to import a table, and OLE is not accepted in the industry.

Try the evaluation version of DotSoft's XL2CAD. Click here for a graphical example of AutoCAD Table attempts on a complex spreadsheet, it just can't accurately represent the spreadsheet. And I would NEVER use OLE in any form.