Google spreadsheet is very important tool as far
as official work is concerned. every official who works Google spreadsheets
certainly face one problem common problem that they often has to face 5 min
minutes of delay when they need to publish their spreadsheet as HTML. Such
problem often gets aggravated when we need to publish an spreadsheet instantly,
for example in case, when we need to publish spreadsheet containing live
market rate, game score, leaderboard ranks, results of exam etc. In Such cases
delays is really a big headache. Earlier there were really no solution of such
delay and the solution which was there, was not working and publishing the way
we want to publish. So what to do ? Here is the solution !! The solution which
I am providing here is not only publishing spreadsheet like the way we want but
also it publishes spreadsheet without dealer of any five minutes or any second;
for this you just need to follow the steps mentioned below
- Create Google spreadsheet
- Work on the spreadsheet
- Arrange it in the way you want
to publish
- Share spreadsheet publicly or
select an option everyone with the public
- Copy the URL of the spreadsheet
https://docs.google.com/spreadsheets/d/SOMETHING/edit#gid=1184897127
- Write this URL somewhere in the
text box
- Replace "/d" the
part of URL with u/0/d"
- Replace the part of URL
containing "edit#gid="
with "htmlembed/sheet?"
- We will get URL like this https://docs.google.com/spreadsheets/u/0/d/SOMETHING/htmlembed/sheet?gid=1184897127
- URL which is formed with this,
is the new URL, which automatically get published as soon as we made
changes in the spreadsheet
- Copy this new URL and give it
to the users who want you to display without any delay
Comments
Post a Comment