I have an Excel file on the server that I need to pass to the client. I tried dynamically generating the excel file through response.write's, but I was unable to get a file/table type that would export from one page and import on the other.
Editing a master template Excel file is working fine, but now I don't know how to get it to the client. I can't write to the client machine (permissions issues, for one), and the client might not have access to the server location where the file is.
I tried using content-disposition to force an attachment, but the attachment contents are always corrupted (I get an excel file, but there's nothing in it except a white box with a red x through it, and that dissapears after about a second), even though the file on the server generates properly on each try.
I need to grab the file on the server, push it to the client, and prompt them to save it locally.
Does anyone have any ideas on this? Thanks!