Data Extraction (more than 65536 rows in XLS)

[j_masenaW7VJQ]

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,

[cadffm]

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

[j_masenaW7VJQ]

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

Regards, 

[j_masenaW7VJQ]

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

Regards, 

[cadffm]

---

@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.

[j_masenaW7VJQ]

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.

[cadffm]

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!

[j_masenaW7VJQ]

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

[cadffm]

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