Display Google Sheet in Web App

[@CodeWithCurt]

Code Used In Video Below:
HTML:




Display Google Sheet Web App



















GOOGLE APPS SCRIPT:
function doGet(e) {
var htmlOutput = HtmlService.createTemplateFromFile('DisplaySheet');
return htmlOutput.evaluate();
}
function getSheetData() {
var ss= SpreadsheetApp.getActiveSpreadsheet();
var dataSheet = ss.getSheetByName('Data');
var dataRange = dataSheet.getDataRange();
var dataValues = dataRange.getValues();
return dataValues;
}

[@bestbuisnessidea1422]

Thanks sir... So much informative

[@bestbuisnessidea1422]

I want to publish my each customer database in webapp with ledger sheet.. how can I do this??

[@johnwysham5725]

Curt -- this looks extremely helpful. It is wonderful folks like you share your knowledge like this. John

[@mahimanasa1]

We can use the inbuilt function on the google sheets to achieve this. instead of all these steps .
Spreadsheet>file>Publish to Web> Select the sheet> copy the url.
That's it.😊

[@mxcripto8040]

True. The problem is that you can't add filter, sort or search functionalities to that directly published google spreadsheet.

[@mahimanasa1]

Yea, but this video is only about displaying table as a webpage.

[@wentzel812]

Those options don't exist in 2022 or am I missing something?

[@mahimanasa1]

@@wentzel812 these are still exist you can use them just display sheet data.

[@pushpalatharavi5595]

Extremely helpful, for me as a beginner. Thank you so much.

[@sathaasivamnandakumar7576]

Do you know why dollar simple on the sheet not display in the webapp table? is there any workaround?

[@datclarinet303]

Thanks
How to do action this web app when we insert link to "google site"
Login button can not action ?

[@muhammedaadhil5645]

If you can have a search option top of the table, this would have made our task much easier :)

[@RogerCanda]

Thank you. I got a project to do just like this..

[@winyoophanmuangma7121]

thank you very much. But I have some problem. When I merge cell in google sheet, in HTML don't merge too. please help me about this problem.

[@shasank0803]

Can you please add a search box for this? So that if anyone searches for a string, all the matching records should be displayed.

[@abdullahquhtani4247]

I have a suggestion and I hope you do it. We need and app that works as an API to read and write data to google sheets ( GET POST$ ) it’s better if we can send request to filter data and get response DATA in JSON format. Thank you.

[@kukuhbakuhsatria4125]

excuse me sir...why i writing source code.i meet a problem.
line on system if i want to publish ,script write eror and show alert: cannot read property getSheetName of null
i thing i missing something ..

[@mckegler]

Thanks for this. If one of my columns has html in it, is there any way to get that display in rich text?

[@lecaonguyen79]

Thank, could you do data querying from google sheet file?

[@dawitayele4142]

Thanks... works perfectly.

[@jayasri-ft8040]

Hi how to export displayed Google sheet data to csv file by clicking download button. Can you make one video for that. Thankyou

[@abelinogomez1224]

How do I import a column with date to be displayed as MM-DD-YYYY only?

[@sohaibroomi7404]

Hi Sir, Thanks for the video. I want to write specific row from Google sheet to HTML Table row. Is it Possible.? Any help would be appreciated.

[@jayasri-ft8040]

Sir, I need automatically update data from Google sheet to Excel.

[@jayasri-ft8040]

Bro, is it display url which was available in Google sheet. If it'wont . Please guide me to display with URL.

[@Sinaloa_Cartel]

Hello,
Any idea how I could display my google sheet on a smart tv that’s in my staffs office? We have lg tv but are looking to upgrade. Would I need some additional plug in? Ty

[@cmohanc]

You need a TV that can run a webbrowser on it.Log in to google sheets and display it. I am doing a similar project now.LG TV wit WEB OS can do it.

[@matefacil7968]

Hi. I have tried to deploy the example you shared in this video... but I have an issue. In my computer everything works fine. When I share the app script url to others they can't open it. I already played with the permissions allowing anyone even anonymous and some others but nothing seems to work. Any suggestions would be greately appreciated.

[@debu4118]

Have you got ans? Please share

[@gothamfury]

How do I publish my Google Sheet as-is as a Web App? Basically, the sheets themselves with all the editable functions like a regular spreadsheet ?

[@SathishKumar-u6z]

Heyy did u find how to do this ?

[@siowxsen8821]

I facing a problem here, web app display unable to display hyperlink (there is hyperlink from google sheet)
Can advise? Thanks

[@mxcripto8040]

This works, but it is extremely slow for a table of 11 columns and more than 500 rows...

[@thejoto]

hi, i get this error: TypeError: Cannot read properties of null (reading 'getDataRange')

[@jayasri-ft8040]

Very useful bro. Thankyou

[@logicafuzzy3026]

worked, thank you!

[@arielzabatecuizon5147]

Hi, after displaying it, now I want somebody to edit it. How? Please help.

[@jhicinternational]

wonderful !

[@bapisaha3990]

error
Script function not found: doGet

[@sabeerg7277]

Is this code work in blogger

[@AgendaBioBioCL]

This application was created by another user.....Can you delete that message?

[@alamathngelecs8616]

Hello bro is is the table displayed in the html are realtime?

[@CodeWithCurt]

Doesn't display in realtime. The screen will need to be refreshed to display the latest changes.

[@panopics3608]

thanks a lot

[@umeshbhati7242]

sir muje Code chhaiye