Lansweeper Report Format/Filetype

[Rocketscience]

Hi,

Scenario:
we're running complex queries in a rather big environment resulting in large reports.
Since the file format of the report is XLS, we're close to hitting the XLS column limitation of 64K.

Question:
1 - is there a way to get around that limitation ?
2 - if not, anything planned for future releases ? xlsx ?

Seperating the data in smaller chunk reports is not really an option as we're working with the complex result data and filter that data later on per user request.

Thank you very much
Matthias

[Hemoco · Accepted solution]

We recommend either:
- Exporting to a different file format, as RC62N mentioned.
- Splitting your query into smaller reports.

There are no immediate plans for XLSX support.

[RCorbeil]

As a workaround, had you tried exporting to CSV instead of XLS? My copy of Excel 2010 doesn't seem swift enough to import it properly, but LibreOffice Calc appears to have no trouble. LANSweeper -> LOCalc, then either copy/paste or export to XLSX and you should have what you're looking for.

If you don't have it, LibreOffice is free.
https://www.libreoffice.org/

If you're not allowed to install applications, a portable release is available.
http://portableapps.com/apps/office/libreoffice_portable