I have a asp file whichm writes data to excel form. The following is my asp file skeleton:
<%
Response.ContentType = "application/vnd.ms-excel";
...
%>
<body>
<%
.....
Response.write(Output);
%>
</body>
this asp file is triggered by a button in my main page.
for first time i clicked the button , it worked fine. i can see the data inside the excel application. it didn't work for the second time, third ..... (the "output" is different each time) but i saw the same data (it's like no change was made to that window)
i found sth on the internet, like "excel can open only one read-only file"
does anyone know how to get around this problem?
appreciate
<%
Response.ContentType = "application/vnd.ms-excel";
...
%>
<body>
<%
.....
Response.write(Output);
%>
</body>
this asp file is triggered by a button in my main page.
for first time i clicked the button , it worked fine. i can see the data inside the excel application. it didn't work for the second time, third ..... (the "output" is different each time) but i saw the same data (it's like no change was made to that window)
i found sth on the internet, like "excel can open only one read-only file"
does anyone know how to get around this problem?
appreciate