Write XLSX Files XLS node

KNIME Analytics Platform
1

Hi there

I was trying to open an a XLSX after being written with the XLS node but I cannot open it on excel, please see the image with the error. 

I wonder if there is an alternative way to write such files directy as I have more than 60k records and I want to avoid converting the CSV on Excel manually? Maybe an R node?

Any help will be appreciated

Cheers

 

 

. 

 

 

2

I have no problem opening XLS file in Excel when I write 70K rows to it, because XLS Writer node actually splits ouput data to multiple Excel sheets if number of rows exceeds 65K rows.

But I think your problem might be that you used *.xlsx extension in XLS Writer instead of *.xls extension (eg. test.xlsx instead of test.xls).  Try outputing file to different format (xls).