Toad World® Forums

RE: Export to xlsx because of Rows > 65k

Hi Torsten,

I am sorry to the late response. The answer is YES. We are planning to support exporting data to xlsx format and support more than 65535 rows in single worksheet. This will be in v7.1.

Thanks,

Vincent

It seems you split the results in n sheets with maximal 1000000 rows.

The specification of Excel takes a Limit of 1048576

see (support.office.com/…/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3)

For my actual requirement this is ok, for Excel programming maybe not.

Hi Torsten,

Thanks for your feedback.

we have create story SQLNAV-1900 for you.

Thanks,

Michael