No force-reload pointer on Google Sheets?

So I'm running every night jobs to create some personalized data for my website and also replicate the data in.csv layout to different web server using SCP. After that I make use of these.csv documents in Google Sheets to present them in table layout.

The trouble is, however, that each time I load the.csv documents I require to consider that spread sheet "tough refresh" so it would not make use of "cached" internet browser information when presenting the.csv documents.

Exists an opportunity to rejuvenate the information each time opening up the record?

0
2019-05-07 12:31:52
Source Share
Answers: 2

Unfortunately the remedy recommended by akira does not constantly function. Google will certainly not republish the Spreadsheet information quickly till the next "release" cycle. So what this suggests is that it is not an internet browser caching concern.

0
2019-12-01 20:03:18
Source

i would certainly believe that establishing the run out - time for the.csv documents can aid. that would certainly be something for the web server to supply.

OR you can fool the webbrowser by adding something arbitrary at the end of the link you are making use of to bring the information (see my talk about your inquiry):

http://example.com/myfile.csv?_invalidate_cache_of_browser_XYZ

and afterwards you need to place some arbitrary XYZ right into the link, possibly by usuing the rand() function.

0
2019-05-09 07:05:05
Source