I succesfuly generated an excel file and populated it with a table from an MySQL query (if anyone is interested in the code, just ask) but I'm having problems putting it for download. I can save the file to disk and the call it with response.WriteFile(), but I can't seem to find a way to have the excel file saved to memory (RAM, not the HDD) and call it for download from there.
I'm using VS 2005, C#, Excel Interop 11.0, and I have office 2003 installed.
Any suggestions?