Good day,
I have a web page that shows info retrieved from a MySQL db and I
would like to convert all these data into an .XLS file.
Have searched the net high and low but seems that I'm unable to find a
free tool that can do the above and therefore I'm forced to do
everything from scratch.
Till now have developed two different versions of the programs and
both somehow work but still have a small problem that I can't
understand.
The first version uses the header
Content-Type:applicatio n/vnd.ms-excel and create a simple table in
HTML. For instance :
<table cellspacing=0 cellpadding=0 border=0 bgcolor=#BBDDFF >
<tr><td>AAA</td><td>BBB</td><td>CCC</td></tr>
...
It works (also with big files, have created an .XLS file that was
22000 rows x 12 cols) but I cannot access all Excel options /
functions (for instance : I cannot add a filter)
The second version uses JS and ActiveX :
<script language="VBScr ipt"></script>
<script language="javas cript">
function ExcelShow()
{
var oXL = new ActiveXObject(" Excel.Applicati on");
var oWB = oXL.Workbooks.A dd();
var oS = oWB.ActiveSheet ;
oS.Name="test";
oS.Cells(5, 1) = "AAA";
oS.Cells(5, 2) = "BBB";
oS.Cells(5, 3) = "CCC";
This work fine, it is fast and I can access Excel functions but have
noted that when number of rows is high the program dies without any
warning / error message. It simply dies and in the HTML page I see
only :
<html><head><ti tle></title></head>
<script language="VBScr ipt">
</script>
Any idea about what can cause the problem and how to solve it ?
Tks, regards
Valerio
I have a web page that shows info retrieved from a MySQL db and I
would like to convert all these data into an .XLS file.
Have searched the net high and low but seems that I'm unable to find a
free tool that can do the above and therefore I'm forced to do
everything from scratch.
Till now have developed two different versions of the programs and
both somehow work but still have a small problem that I can't
understand.
The first version uses the header
Content-Type:applicatio n/vnd.ms-excel and create a simple table in
HTML. For instance :
<table cellspacing=0 cellpadding=0 border=0 bgcolor=#BBDDFF >
<tr><td>AAA</td><td>BBB</td><td>CCC</td></tr>
...
It works (also with big files, have created an .XLS file that was
22000 rows x 12 cols) but I cannot access all Excel options /
functions (for instance : I cannot add a filter)
The second version uses JS and ActiveX :
<script language="VBScr ipt"></script>
<script language="javas cript">
function ExcelShow()
{
var oXL = new ActiveXObject(" Excel.Applicati on");
var oWB = oXL.Workbooks.A dd();
var oS = oWB.ActiveSheet ;
oS.Name="test";
oS.Cells(5, 1) = "AAA";
oS.Cells(5, 2) = "BBB";
oS.Cells(5, 3) = "CCC";
This work fine, it is fast and I can access Excel functions but have
noted that when number of rows is high the program dies without any
warning / error message. It simply dies and in the HTML page I see
only :
<html><head><ti tle></title></head>
<script language="VBScr ipt">
</script>
Any idea about what can cause the problem and how to solve it ?
Tks, regards
Valerio
Comment