output to excel is cut off at row 65536

[clairesirett]

Im just looking at one workflow, im getting an output , however when I open it in excel its cutting off at 65536 lines- ive tried as a binery and a CSV- any advice on how to fix? 

[alexnajm]

It is hard for us to diagnose based on the information above - how many rows are you expecting? Can you show us that you have more than 65K records going into the Output Data tool?

There should be no issue outputting that many records 😊

[clairesirett]

im expecting around 450K rows which should be in excels line limits .

ive got 3 input files , i have uploaded a screen shot showing the number of records in one of the input files 

[alexnajm]

@clairesirett we'll need to see those amount of records going into your Output Data tool, and your Output Data tool configuration! Your message log will also tell you if it successfully wrote out 500K records, or if there was an issue that prevented it.

I tested this on my side and there are no issues writing out 500K records to Excel.

[apathetichell]

you are writing to .xls - not .xlsx. that is the max records in .xls

[alexnajm]

Nice catch @apathetichell !