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

Export to excel problem

Hi all,

I have script, which is used to export the table information to the excel file.
The code is working fine in client machine (I am using Windows XP & IE 6.0). If I test the same html page in other hosting server, its not downloading(not open the excel file with data).
What's the issue in that?

My code is given below:
<html>
<head>
<title>Testing</title>
</head>
<body>
<script language="vbscript">
Sub exporttoexcel
      Dim sHTML
        Dim oExcel
        Dim oBook
      sHTML = document.all.item("inner_table").outerhtml
        Set oExcel = CreateObject("Excel.Application")
      Set oBook = oExcel.Workbooks.Add
      oBook.HTMLProject.HTMLProjectItems("Sheet1").Text = sHTML
      oBook.HTMLProject.RefreshDocument
      oExcel.Visible = true
      oExcel.UserControl = true
End Sub
</script>
<table  border = 0 cell padding = 0>
<tr>
<td><font size = -1><a href='javascript:exporttoexcel()'>Export To Excel</a></td>
</tr>
</table>

<table id ="inner_table">
<tr><td> Hello</td></tr>
</table>
</body>
</html>
0
r_kar
Asked:
r_kar
  • 4
  • 4
1 Solution
 
MacroLandCommented:
vbscript is a microsoft technology so as I know only microsoft OS supports
0
 
r_karAuthor Commented:
MacroLand,

If I open this page using my IE explorer, it should work... right?
Its not working if I use IE browser in my XP machine.

Anyone can tell me what's happening at that end?

Thanks

0
 
MacroLandCommented:
I use your code with IE on my xp machine and it works fine. However with FireFox it does not work.

The reason I guess is your script uses document.all which is Microsoft supported instead of document.getElementById which is Mozilla supported.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
r_karAuthor Commented:
MacroLand,
ok.
My problem is if I use same script in some other server (like geocities), it will not work properly.
But If I copy the code using "View Source" and tested, its working.
So what's happening in both case? No idea.... I am using same browser for both testing....

Thanks
0
 
MacroLandCommented:
>>My problem is if I use same script in some other server (like geocities), it will not work properly.

I think the reason is with security attributes of your browser. If you run the file from your computer your browser considers it to be safe so it lets MS Excel to run. However if you try to run it from external resources like Goecities it is deemed as ActiveX control so your security settings does not let it run.

Regards,
0
 
r_karAuthor Commented:
MacroLand,
Thanks for your reply.
Is there anyway to resolve this issue?
Or do you have any sample script to download the table information as excel file?
Regards
0
 
MacroLandCommented:
>>Is there anyway to resolve this issue?

I think you can set your security setting to download ActiveX controls but this is totally up to you. You will be more susceptible to intrusions by this way.

Unfortunately I have no source code for this. I right click the mouse and choose Export to Excel function provided by IE which works fine for me. Sorry.

Regards,

0
 
r_karAuthor Commented:
Hi all,

I think its difficult to get a solution for my problem. For the time being,  I will do it in server side.
I am going to Delete/Cancel this question with all your permission.

Regards
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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