can we send data from html to excel sheet using java script

[sandeep123456]

hi,
can we send data from html to excel sheet using java script
sandeep

[r035198x]

hi,
can we send data from html to excel sheet using java script
sandeep

Moved to Javascript forum.
P.S Welcome to TSDN.

[acoder]

hi,
can we send data from html to excel sheet using java script
sandeep

Not with standard javascript as far as I'm aware.

You could use AJAX to simulate client-side interactions or it could even be as simple as right-click and "Send to Excel" or something to that effect (without the need for any scripting).

[contactkakkar]

Yes we can do whatever you are saying:

I am listing an example function where I am copying the html data in a div to the excel sheet. It is following copy-paste technique. But you can select and carry the data in a javascript variable and then save it cell-wise. Google out the rest yourself. You have got the clue.

 function fnSelect(objId)
{
   fnDeSelect();
   if (document.selection) 
   {
      var range = document.body.createTextRange();
      range.moveToElementText(document.getElementById(objId));
      range.select();
      range.execCommand("Copy");
   }
   else if (window.getSelection) 
   {
      var range = document.createRange();
      range.selectNode(document.getElementById(objId));
      window.getSelection().addRange(range);
      range.execCommand("Copy");
   }
var eWApp = new ActiveXObject("Excel.Application")
eWApp.Visible = true
eWApp.Workbooks.Add()
xlSheet = eWApp.ActiveSheet;
xlSheet.Paste();
fnDeSelect();
}
 
function fnDeSelect() 
{
   if (document.selection)
             document.selection.empty();
   else if (window.getSelection)
              window.getSelection().removeAllRanges();
}

[acoder]

Yes we can do whatever you are saying:

I am listing an example function where I am copying the html data in a div to the excel sheet. It is following copy-paste technique. But you can select and carry the data in a javascript variable and then save it cell-wise. Google out the rest yourself. You have got the clue.

 function fnSelect(objId)
{
   fnDeSelect();
   if (document.selection) 
   {
      var range = document.body.createTextRange();
      range.moveToElementText(document.getElementById(objId));
      range.select();
      range.execCommand("Copy");
   }
   else if (window.getSelection) 
   {
      var range = document.createRange();
      range.selectNode(document.getElementById(objId));
      window.getSelection().addRange(range);
      range.execCommand("Copy");
   }
var eWApp = new ActiveXObject("Excel.Application")
eWApp.Visible = true
eWApp.Workbooks.Add()
xlSheet = eWApp.ActiveSheet;
xlSheet.Paste();
fnDeSelect();
}
 
function fnDeSelect() 
{
   if (document.selection)
             document.selection.empty();
   else if (window.getSelection)
              window.getSelection().removeAllRanges();
}

Welcome to TSDN!

Thanks for sharing your code.

Just to mention though, this is JScript, not Javascript. It uses ActiveX. It would work in IE, but not in any other browser.