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

Beyound Compare : Ignore File Extension option

Image
Beyond Compare 3 doesn't have the "ignore file extension" setting. It was replaced by the "Alignment Overrides" setting in BC3 Pro. As an example, here's how to align .bmp files on the left with .jpg files on the right using BC3 Pro: Select Session > Session Settings. Go to the Misc tab. Click New. For "Align left file (or folder)" enter "*.bmp". For "with right file (or folder)" enter "*.jpg". Click OK until you're back to the main window.
Read more