Limiting rows and cells when exporting to Excel?

[former_member393760]

Dear All,

I want to limit exporting to Excel but the advanced configuration only seems to effect csv file type(?).

export.csv.maxrows=50000

export.csv.maxcells=-1

Is there a parameter that works for Excel?

Best regards,

Marco Nieuwenhuis

Running 4.1 SP5

[former_member376301 · Accepted solution]

Hello,

Test with :

export.excel.maxrows=50000

export.excel.maxcells=-1

(Stop and restart yours Explorer servers)

xxx.csv.xxx is used to export to csv data.

If number of datas is larger than xxx.maxxxx then you should have a warning and you could not export....

I guess it is in 4.1 SP5....

[former_member393760 · Accepted solution]

Hello Arnaud,

It works. Thanks!

Regards, Marco

[Former Member]

Hello.

Check note

2178979 - Unable to limit the number of rows getting exported in excel from an information space

[former_member393760]

Thanks!