Export to Excel From Browser Error

Posted on 2006-06-08
Last Modified: 2010-08-05
When exporting to Excel from browser, I get the following error in Excel: Unable to open http://.... The internet site reports that a connection was established but the data is not available.

Are there certain restrictions regarding types of tables or formatting of tables that Excel ignores?

This probably isn't a difficult question, I just need to know quickly.
Question by:C_J_L

    Expert Comment

    Are those info show correctly before export?
    I use following code and it works:
    ' Tells the browser to use Excel to open the file
    Response.AddHeader "Content-Disposition", "attachment; filename=ACRpt.xls;"
    Response.ContentType = "application/"


    Author Comment

    All I am doing is right clicking in IE on Export to Excel. It works on other web pages (not our app) but not on our table. Why is it saying data is not available? Is it because it can't see it?
    LVL 17

    Expert Comment

    by:Serena Hsi
    What permissions have been set for that file and/or its data range?

    Author Comment

    IE opens Excel and places the data into a new worksheet with no access restrictions.

    Author Comment

    I found the reason why it was giving me that error.

    I used the button on the TOOLBAR to select Edit with Microsoft Office Excel which did work. This button will open Excel and present a web query window which allows you to choose which of the tables on the web page you want to import. But in this case, in the web query window we are asked to login again (secure site), and choose all of the selection criteria again as if I just starting fresh. Then when you have tables available in the window, you select the arrow icon by the table you want to import and click import. This imports it into the spreadsheet.

    Doing the right click on the web page, and choosing export to Microsoft Excel will not work because it skips the web query window and tries to automatically export ALL tables on the web page. And in this case, there are no tables populated because Excel could not login and make selections to populate the tables so it gives the error of no data is available in the tables.

    So this question is closed.


    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
    Building “do-it-yourself” web sites has become an epidemic. There are so many blogs, web sites and even books that "teach" you how to build your web site in a few extremely simple and easy steps. Building a web site has become easier than boiling an…
    Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
    This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now