Use ExcelTag(s): Varia
These scripts are for IE only
Launch Excel externally
<input type="button" value="excel (IE only)" onclick="startExcel();"> <script language="javascript"> function startExcel() { var xls = new ActiveXObject ( "Excel.Application" ); xls.visible = true; var newBook = xls.Workbooks.Add; newBook.Worksheets.Add; newBook.Worksheets(1).Activate; newBook.Worksheets(1).Cells(1,1).value="First Column, First Cell"; newBook.Worksheets(1).Cells(2,1).value="First Column, Second Cell"; newBook.Worksheets(1).Cells(1,2).value="Second Column, First Cell"; newBook.Worksheets(1).Cells(2,2).value="Second Column, Second Cell"; newBook.Worksheets(1).Name="WorkSheet from Javascript"; // newBook.Worksheets(1).SaveAs("C:\\temp\\TEST2.XLS"); } </script>
Excel embedded into the browser
You need a recent Office version with the OWC control installed. OWC means Office Web Components.
In the registry (HKEY_CLASSES_ROOT\CLSID), you locate the CLSID (or CLASSID) key for "Microsoft Office Spreadsheet 10.0" (if you have Office 10).
Typically
HKEY_CLASSES_ROOT\CLSID\{0002E541-0000-0000-C000-000000000046} "Microsoft Office Spreadsheet 10.0"
Then
<object width = 900 height = 500 id = 'excel' classid = 'CLSID:0002E541-0000-0000-C000-000000000046' VIEWASTEXT> <param name=DisplayTitleBar value=true > <param name="DataType" value="CSVURL"> <param name="AutoFit" value="0"> <param name="DisplayColHeaders" value="1"> <param name="DisplayGridlines" value="1"> <param name="DisplayHorizontalScrollBar" value="1"> <param name="DisplayRowHeaders" value="1"> <param name="DisplayTitleBar" value="1"> <param name="DisplayToolbar" value="1"> <param name="DisplayVerticalScrollBar" value="1"> <param name="EnableAutoCalculate" value="0"> <param name="EnableEvents" value="0"> <param name="MoveAfterReturn" value="1"> <param name="MoveAfterReturnDirection" value="0"> <param name="RightToLeft" value="0"> <param name="XMLURL" value="http://www.rgagnon.com/examples/xls/hello.xml"> </object> <xparam name="HTMLURL" value="http://www.rgagnon.com/examples/xls/t1.html"> <xparam name="csvURL" value="http://www.rgagnon.com/examples/xls/t2.csv"> <script> excel.range('a14').value = '435'; excel.range('b14').value = '0'; excel.range('c14').value = 'yop!'; excel.range('d14').value = 'yip!'; excel.range('e14').value = ''; </script> <script> function boldexcel(){ excel.ActiveCell.EntireRow.Font.Bold = true; } function excelalert(){ alert(excel.ActiveCell.Value); } function excelview(){ excel.ViewableRange="$A$1:$C$4"; } </script> <p> <button onclick="boldexcel()">bold</button> <button onclick="excelalert()">alert</button> <button onclick="excelview()">view</button>
Note :
mail_outline
Send comment, question or suggestion to howto@rgagnon.com
Send comment, question or suggestion to howto@rgagnon.com