I have input excel and need to read that data inside the Modified JavaScript Value step in Pentaho tool using JavaScript code.
Input excel contains:
Name City
Vinay Hyderabad
Ravi Nizamabad
tried below code to read data from excel and generate the data in html format inside Modified JavaScript value step in Pentaho tool:
<code>var inputRowMeta = getInputRowMeta();
var numFields = inputRowMeta.size();
// Define the HTML content
var htmlContent = "<html><head><title>Generated HTML</title></head><body><table border='1'><tr><th>Name</th><th>City</th></tr>";
var rows;
// Loop through the rows
for(var i=0; i<numFields; i++) {
// Access data from the rows
var column1Value = getVariable("Name", i);
var column2Value = getVariable("City", i);
// Append row to HTML content
htmlContent += "<tr><td>" + column1Value + "</td><td>" + column2Value + "</td></tr>";
}
// Close HTML content
htmlContent += "</table></body></html>";
// Write HTML content to a file
var file = new java.io.File("C:\Users\Admin\file.html");
var writer = new java.io.FileWriter(file);
writer.write(htmlContent);
writer.close();
</code>
<code>var inputRowMeta = getInputRowMeta();
var numFields = inputRowMeta.size();
// Define the HTML content
var htmlContent = "<html><head><title>Generated HTML</title></head><body><table border='1'><tr><th>Name</th><th>City</th></tr>";
var rows;
// Loop through the rows
for(var i=0; i<numFields; i++) {
// Access data from the rows
var column1Value = getVariable("Name", i);
var column2Value = getVariable("City", i);
// Append row to HTML content
htmlContent += "<tr><td>" + column1Value + "</td><td>" + column2Value + "</td></tr>";
}
// Close HTML content
htmlContent += "</table></body></html>";
// Write HTML content to a file
var file = new java.io.File("C:\Users\Admin\file.html");
var writer = new java.io.FileWriter(file);
writer.write(htmlContent);
writer.close();
</code>
var inputRowMeta = getInputRowMeta();
var numFields = inputRowMeta.size();
// Define the HTML content
var htmlContent = "<html><head><title>Generated HTML</title></head><body><table border='1'><tr><th>Name</th><th>City</th></tr>";
var rows;
// Loop through the rows
for(var i=0; i<numFields; i++) {
// Access data from the rows
var column1Value = getVariable("Name", i);
var column2Value = getVariable("City", i);
// Append row to HTML content
htmlContent += "<tr><td>" + column1Value + "</td><td>" + column2Value + "</td></tr>";
}
// Close HTML content
htmlContent += "</table></body></html>";
// Write HTML content to a file
var file = new java.io.File("C:\Users\Admin\file.html");
var writer = new java.io.FileWriter(file);
writer.write(htmlContent);
writer.close();
output:
enter image description here
I’m getting 0,1 values instead actual values, any help would be appreciated
New contributor
Shaik Noor Mohammad is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.