How to Read HTML table data and set in to String variable?

priyankajailia · ‎06-22-2016

Hi, I have a HTML table created on Catalog item. And On click on Add line button , one line gets added in to HTML area. So on submit I need the data from this HTML area to another String variable to process it further. Please help me on this.

<tbody>

<tr>

<p><strong>New eSourcing Vendor Setup</strong></p>

</td>

</tr>

<p><strong>Supplier Type</strong></p>

</th><th style="text-align: center; font: 12pt Calibri, sans-serif; background: #c0c0c0; border: 1px solid black;" width="10%">

</th></tr>

</tbody>

</table>

===========================================

=============================

I tried below code but getElementById is not working

var table_rows = g_form.getValue('app_html') + '';

var table = document.getElementById("dataTable2").value;

var table = document.getElementById("dataTable2");

var arrRows = table.getElementsByTagName("tr");

var arrAllCells = table.getElementsByTagName("td");

var arrHeaders = table.getElementsByTagName("th");

//cells by rows

for(var i=0;i<arrRows.length;i++){

var arrRCells = arrRows[i].getElementsByTagName("td");

alert("arrRCells " +arrRCells);

}

g_form.setValue("hold_html_data", table);

ramireddy · ‎06-23-2016

Ok. Rows are separated by "@" and column values are separated by comma. Try below code. If you face any issues, put few alerts in between those statements and check.

var table_rows = g_form.getValue('app_html');

var table = gel("dataTable2");

var arrRows = table.rows;

//cells by rows

var sHTML = "";

for(var i=0;i<arrRows.length;i++)

{

for(var cellcounter = 0 ; cellcounter < arrRows[i].cells.length ; cellCounter++)

{

sHTML += arrRows[i].cells[cellCounter].innerText + ";"

}

sHTML += "@"

}

g_form.setValue("hold_html_data", sHTML);

priyankajailia · ‎06-23-2016

My Bad Luck/// Line --- var table = gel("dataTable2"); ------------ is returning null when i alert table var.

ramireddy · ‎06-23-2016

Try,

$('dataTable2') instead of gel function..

On Thu, 23 Jun 2016, 13:08 priyankajailia, <

Rivka Br · ‎08-30-2022

Hi,

Any find any solution for it?

RudhraKAM · ‎02-03-2025

any solution for this ?