export to excel problem with IPAddress in URL but working with localhost url

[mustaque]

Hi All,

I am getting export to excel problem when I am giving IPAddress in URL, but it is working correct when am giving localhost and page name.

eg : when I am writing My machine IP address and aspx pagename like 192.xxx.xxx.xx/exporttoexcell.aspx then popup page is not working. the popup page is being closed automatically , and export to excel option is not comming.

for some reason when it opens within a scripted popup (js: window.open()), it flashes and then closes immediately without any excel trigger.


but when I am giving my machine name mustaque/exporttoexcell.aspx then popup page is working properly and export to excel is working . I am being unable to understand what may be the problem ,

I am writing here my code

// I am getting the value in sBody and exporting it to excel .

string sBody = cExcel.ExportToMSExcel(true, true, 2,false, false);
Response.Clear();

Response.Buffer = true; Response.Charset = "";
Response.AppendHeader("Content-Type", "application/vnd.ms-excel");

Response.AppendHeader("Content-disposition", "attachment; filename=AcHeadMaster.xls");
Response.Write(sBody);

Response.End();




please help me.

My OS is Vista . Dotnet vn 2.0

Thanks in Advance

Mustaque Ahmad

Software Engineer

[WingedPanther]

What browser are you using? What security settings have you set on the browser? Are you getting any messages about pages being blocked?

[mustaque]

Thanks for Reply

I am using IE6 , IE7 browser. and browser setting is default. and I am not getting any message for page being blocked .

My problem is , when I am running project throw machine name or local host and page name then popup is comming and export to excel option for save or open etc are comming

but when I am using IP Address like 192.xxx.xxx.xx then export to excel pop up just flash on the screen and automatically closed.

Please advice me .

Thanks & Regards
Mustaque

[WingedPanther]

I suspect your IE security settings are blocking it. Try the same experiment with a different browser (FireFox, Opera, etc). That will tell you if it's a problem with your code or your browser (IE definitely sucks).

[mustaque]

Thanks for Reply,

My aplication is only applycable for IE browser.

and the problem is comming from all IE .

Thanks & Regards
Mustaque

[rajniponugoti]

HI All
I am facing a similar problem i have a aspx page which consists an Ajax Tab control

i am just opening a pop up(which will Export data to Excel sheet) from the two tabs in two different work flows.
it is working in Dev environment in both the work flows for ie7 .


but in QA and other environments in one work flow it is working fine where as in the other work flow the pop opens and just disappears(both for ie6 and ie7)
for ie6 is in all the environments it is failing.
i tried with local host, ip address and server name in all the cases same result

this could not be a code issue when i debug the http response through fiddler in both the cases the http response content type every thing was same and perfect.

any help will be greatly appreciated
Regards,
Rajani kanth.