• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 544
  • Last Modified:

Export to Excel From Browser Error

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.
0
C_J_L
Asked:
C_J_L
1 Solution
 
aimfanCommented:
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.Clear()
Response.AddHeader "Content-Disposition", "attachment; filename=ACRpt.xls;"
Response.ContentType = "application/vnd.ms-excel"

0
 
C_J_LAuthor Commented:
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?
0
 
Serena HsiMarketing ConsultantCommented:
What permissions have been set for that file and/or its data range?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
C_J_LAuthor Commented:
IE opens Excel and places the data into a new worksheet with no access restrictions.
0
 
C_J_LAuthor Commented:
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.

0
 
CetusMODCommented:
PAQed with points refunded (500)

CetusMOD
Community Support Moderator
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now