topic Re: Data Extraction (more than 65536 rows in XLS) in AutoCAD Forum

Data Extraction (more than 65536 rows in XLS)

j_masenaW7VJQ — Thu, 21 Dec 2023 11:14:14 GMT

Hello everyone,

I have an issue with DataExtraction and the limit of rows extracted (65536 rows), I am extracting different properties for a set of drawings and in some cases this limit force me to some errors or information not extracted.

I would like to know if it possible to increase the amount of lines in XLS, via variable or LSP.

Regards,

Re: Data Extraction (more than 65536 rows in XLS)

cadffm — Thu, 21 Dec 2023 11:44:22 GMT

Hi,

>>"DataExtraction and the limit of rows extracted (65536 rows),"

Dataextraction use the .xls format and microsofts .xls format is limited to 65536 Rows, right.

>>"I would like to know if it possible to increase the amount of lines in XLS, via variable or LSP."

No, it is a limitation of the (old) Excel file format .xls

Workaround1

Export less files in one step

Workaround2 (prefered)

- use another 3rd party tool to export +whatever you need+ to *.xlsx format

Re: Data Extraction (more than 65536 rows in XLS)

j_masenaW7VJQ — Thu, 21 Dec 2023 12:17:34 GMT

Thanks for your response, how can I extract the data in XLSX format? it is not an option in AutiCad 2024.

Regards,

Re: Data Extraction (more than 65536 rows in XLS)

j_masenaW7VJQ — Mon, 08 Jan 2024 08:27:36 GMT

Thanks for your response, how can I extract the data in XLSX format? it is not an option in AutiCad 2024.

Regards,

Re: Data Extraction (more than 65536 rows in XLS)

cadffm — Mon, 08 Jan 2024 09:37:19 GMT

@cadffm schrieb:

Hi,

>>"DataExtraction and the limit of rows extracted (65536 rows),"

Dataextraction use the .xls format and microsofts .xls format is limited to 65536 Rows, right.

>>"I would like to know if it possible to increase the amount of lines in XLS, via variable or LSP."

No, it is a limitation of the (old) Excel file format .xls

Workaround1

Export less files in one step

Workaround2 (prefered)

- use another 3rd party tool to export +whatever you need+ to *.xlsx format

>>"I am extracting different properties for a set of drawings"

What do you extract?

Which data, objecttypes properties.. tell us more about.

Re: Data Extraction (more than 65536 rows in XLS)

j_masenaW7VJQ — Mon, 08 Jan 2024 09:46:32 GMT

I am extracting different properties (Name, Length, Color, File Name, Layer, Linetype, Unit Factor, Visibility1, Area, Distance1 & Scale1) to use them in excel and quantify different components.

Re: Data Extraction (more than 65536 rows in XLS)

cadffm — Mon, 08 Jan 2024 09:51:10 GMT

Okay,

so why not export to .csv or .txt

and open the file in your Excel (and save to .xlsx then).

untested! IF it is still limited to 65536, it is a limitation inside dataextract function.

But test it first!

Re: Data Extraction (more than 65536 rows in XLS)

j_masenaW7VJQ — Mon, 08 Jan 2024 09:52:10 GMT

I will try, will this avoid the limit of rows extracted (65536 rows)?

Re: Data Extraction (more than 65536 rows in XLS)

cadffm — Mon, 08 Jan 2024 10:00:01 GMT

stop talking and writing (no offense)

TEST IT

and then, we know it

>>untested! IF it is still limited to 65536, it is a limitation inside dataextract function.

because the ascii/txt format is NOT limited to 65536

Re: Data Extraction (more than 65536 rows in XLS)

gene_t_coryell — Fri, 28 Nov 2025 16:49:41 GMT

I can confirm that if you select .txt file as your export file format, you can export more than the 65,536 limitation. I just exported 135, 583 rows.