How to export as CSV correctly?

[wengseng300]

Hello,

Thanks for this wonderful and simple plugin. I've been using this plugin to export excel as XLS in previous project and it's work perfectly.

But now I have a new requirement to export my data as CSV.

I'm using MVC. In my ActionResult, I have everything done and in the end, I return the file to browser with this:

return File(objData, "application/octet-stream", strExcelFullName);

I'm trying to export the file as CSV using the content type of "application/octet-stream" or "text/csv" (i don't think it will work but just trying). The file is sent to my browser and downloaded as CSV but I got a warning message as below when I open the CSV:

This seems to be an issue that the plugin is expecting to export as XLS instead of CSV.

I can open the content if I choose 'Yes' but it's not acceptable for my users that they have to select the option to view the excel every time they downloaded the file.

Is there any configuration that I can set to inform the function to export the file as CSV and stop showing the warning message?