majimenezp / simpleexcelexport Goto Github PK

Hi Devs,

Thank you for this helper. But in your example you don't show how to save the output to the users computer.

I am using this in VB,net and there are not hints at how you would save this.
Can someone assist?

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?

Hello and thanks for sharing this! I pulled down your package and was just trying to write a simple integration test and I can't get it to compile using your example (see attached screenshot). Am I missing something?

In your project you've used NPOI 1.2.5, which seems to compile splendidly. But when downloading this from NuGet it installs the most recent NPOI 2.1.3, and that gives the error:
"Method not found: 'Void NPOI.HSSF.UserModel.HSSFCellStyle.set_FillPattern(NPOI.SS.UserModel.FillPatternType)'."

Do you have any ideas about workarounds or how to fix such a thing in your code? I'm working on a project where your code would save lots of time if I could get it working.