I have the following google sheet table: google sheet <https://i.stack.imgur.com/TzAu3.png>
Using google visualization I am showing this table on website: google sheet withdrawn on website <https://i.stack.imgur.com/YT8sM.png> The code of google visualization is: google.load('visualization', '1', { packages: ['table'] }); var visualization; function drawVisualization() { var query = new google.visualization.Query('https://spreadsheets.google.com/tq?key=1xXCb2Xtp_Lsak3HLF7mV7IzcuaiMnBKPA6x2HUxCKrM&output=html&range=B4:Q30&headers=1&gid=451291128&&usp=sharing'); query.setQuery('SELECT B, C, D, E, F, G, H, I, J,K,L,M,N,O,P,Q'); query.send(handleQueryResponse); } function handleQueryResponse(response) { if (response.isError()) { alert('There was a problem with your query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } var data = response.getDataTable(); visualization = new google.visualization.Table(document.getElementById('table')); visualization.draw(data, { allowHtml: true, legend: 'bottom' }); } google.setOnLoadCallback(drawVisualization); I need to high-lite all cells with letter B with color on website. I have tried to change all B to <span>B</span> through the javascript innerhtml, but it does not work for B in table, as it has specific loading on the page. I supposed to think, it is necessary to change all B to <span color="red">B</span> in google visualization query before it is getting withdrawn to the table, but I have no idea how to do that. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/34de9774-2053-4bfd-9de1-fc3a0ee185d2%40googlegroups.com.
