HTML table to Excel table using Javascript

Convert HTML tabular date to Excel form using Javascript


Let try to generate html data to xml data by using code below:

< html >

< head >
< script type="text/javascript" >

function CreateExcelSheet()
{


var x=myTable.rows

var xls = new ActiveXObject("Excel.Application")
xls.visible = true
xls.Workbooks.Add
for (i = 0; i <  x.length; i++)
{
var y = x[i].cells

for (j = 0; j <  y.length; j++)
{
xls.Cells( i+1, j+1).Value = y[j].innerText
}
}

}
< /script >


< /head >

< body marginheight="0" marginwidth="0" >
< form >
< input type="button" onclick="CreateExcelSheet()" value="Create Excel Sheet" >
< /form >
< table id="myTable" border="1" >
< tr > < b >< td >Name < /td > < td >Age< /td >< /b >< /tr >
< tr > < td >Shivani < /td > < td >25< /td > < /tr >
< tr > < td >Naren < /td > < td >28< /td > < /tr >
< tr > < td >Logs< /td > < td >57< /td > < /tr >
< tr > < td >Kas< /td > < td >54< /td > < /tr >
< tr > < td >Sent < /td > < td >26< /td > < /tr >
< tr > < td >Bruce < /td > < td >7< /td > < /tr >
< /table >



< /body >

< /html >

Comments

Post a Comment

Popular posts from this blog

Python commands for Mac and Windows

Image
Python commands and VS Code Setup To check Python version enter command   Python3 – – version To check with pip version Pip3 —version To check diesel version enter the command following Django-admin —version Install Django We can install the Django in two types first we can install in virtual environment second we can install globally. In virtual environment if we install the Django it will not be accessible outside of this environment. Install Django in Separate Environment Install virtual environment wrapper This is used to install virtual environment wrapper. Pip install virtualenvwrapper-win Example:- (In windows ) pip install virtualenvwrapper   (in MacOS) pip3 install virtualenvwrapper Create virtual environment (VE) This is used to create virtual environment. It will automatically activate environment. For windows:- mkvirtualenv envname For example :- mkvirtualenv ckesripyvrenv For my macOS:- Step 1.   python3 -m venv envname For example :- python3 -m venv ckesri...
Read more

Drive are not opening in same window on double click in windows XP

If your Drives are opening in new window on double click, It might be possible that your folder setting can be changed: follow the steps given below to make sure folder settings: Open "My Computer". Go on Tools menu and open Folder Option. In General Tab, check "Open each folder in the same window". Click on OK to save setting and close the "Folder Option" window. if you still facing the problem then you need to follow these steps or refer this site : First Method: 1. Open Start >> Run and type regsvr32 /i shell32.dll 2. press ok 3. You will see a message DllRegisterServer and DllInstall in shell32.dll succeeded 4. that’s it Second Method: 1. Open Start >> Run and type regedit 2. Navigate to HKEY_CLASSES_ROOT/Directory/Shell 3. Double click the default key type none and press ok. 4. now navigate to HKEY_CLASSES_ROOT/Drive/Shell. 5. Double click the default key type none and press ok. Third Method: If you don’t want to play with the registry ,yo...
Read more

Unable to Start Debugging on the Web Server

Image
Solution for the error: " Unable to start debugging on the web server. Debugging failed because integrated windows authentication is not enabled. Please see help for assistance. " Steps 1. Start --> Run --> inetmgr --> click on ok to open the iis window. Steps 2. websites --> Right click on it ---> choose " Properties " to open the web site properties window. Steps 3. select " Directory securities " --> click on edit button in "Anonymous access and authentican control". Steps 4. check the " Integrated windows authentication " check box in authenticated access. and click on OK buton to close the authentication Method window. Now you are ready to run your asp.net website with ASP.NET debugger .
Read more