Scrip Code
function doGet() {
// Access the active spreadsheet and sheet
var sheet = SpreadsheetApp.getActiveSheet();
// Get the data range (adjust range as needed)
var dataRange = sheet.getDataRange();
// Get the values in the range
var data = dataRange.getValues();
// Create HTML table structure
var html = "
";
for (var i = 0; i < data.length; i++) {
html += "";
for (var j = 0; j < data[i].length; j++) {
html += "| " + data[i][j] + " | ";
}
html += "
";
}
html += "
";
// Return the HTML output
return HtmlService.createHtmlOutput(html);
}
ifreme