hi there,

I am trying to extract data from hive table to excel using generic dataflow . However, file gets created the name I gave in the dataflow with xlsx extension. But when i try to opening the file with excel then it is throwing the error.

then I changed the extension to xls  and run the dataflow again then also same error.  If you can let me how to extract the data into xlsx file and subsequently it can be open by excel then that would be great.

Thanks in advance for assisting me in this matter.

Praveen