visionarylab

Report: Handling 10,000,000 cells in Google Spreadsheet using Google Apps Script

Introduction

On March 14, 2022, it reported about "Google Sheets doubles cell limit". Ref By this update, now, the users can use 10,000,000 cells in a Google Spreadsheet. This is great news for us. When I tried to handle 10,000,000 cells in a Google Spreadsheet using Google Apps Script, it was found that there were various important points. In this report, I would like to introduce the important points for handling 10,000,000 cells in Google Spreadsheet using Google Apps Script.

Experiences

In this report, as a sample Google Spreadsheet, a Google Spreadsheet including a sheet that has 10,000,000 cells (10 columns x 1,000,000 rows) is used.

Resumable Download of File from Google Drive using Drive API with Python

This is a sample script for achieving the resumable download of a file from Google Drive using Dive API with Python.

There might be a case in that you want to achieve the resumable download of a file from Google Drive using Dive API with Python. For example, when a large file is downloaded, the downloading might be stopped in the middle of downloading. At that time, you might want to resume the download. In this post, I would like to introduce the sample script of python.

In order to achieve the partial download from Google Drive, the property of Range: bytes=500-999 is required to be included in the request header. But, unfortunately, in the current stage, MediaIoBaseDownload cannot use this property. When MediaIoBaseDownload is used, all data is downloaded.

So, in order to achieve this goal, it is required to use a workaround. In this workaround, I proposed the following flow.

Note: This is all almost full YouTube ID informations. Original owner goes to AgentOak, modified version by Martin Eesmaa.

See the credits and also special thanks in below.

Last updated: June 2024

Also known as itag or format codes and way back they could be specified with the fmt parameter (e.g. &fmt=22). Depending on the age and/or popularity of the video, not all formats will be available.

DASH video

Creating a Progressive Web App (PWA) to store contact details from a form and submit them when internet access is available involves a combination of technologies like HTML, CSS, JavaScript, and service workers. Below is a simplified example of how you can achieve this:

HTML Form: Create an HTML form to collect contact details. You can create an index.html file.

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">

https://developer.microsoft.com/en-us/microsoft-edge/tools/vms/

	https://gist.github.com/djibe/87b6ae5157c309fb611b428445e9fce9
	https://gist.github.com/asheroto/5087d2a38b311b0c92be2a4f23f92d3e


	https://www.tenforums.com/tutorials/1964-move-users-folder-location-windows-10-a.html#MethodTwo
	https://devblogs.microsoft.com/setup/booting-windows-to-a-differencing-virtual-hard-disk/
	https://us.informatiweb.net/tutorials/it/multiboot/vhd-vhdx-multiboot-with-windows-10-and-windows-11.html
	https://learn.microsoft.com/en-us/windows-server/virtualization/hyper-v/best-practices-analyzer/avoid-using-vhd-format-differencing-virtual-hard-disks-on-virtual-machines
	https://www.ajni.it/2019/10/hyper-v-create-a-master-vhdx-to-save-tons-of-space/

	addEventListener('fetch', event => {
	event.respondWith(fetchAndApply(event.request))
	})

	/**
	* Make multiple requests,
	* aggregate the responses and
	* stream it back as a single response.
	*/
	async function fetchAndApply(request) {

	[package]
	name = "rust-sqlite-test"
	version = "0.1.0"
	edition = "2021"

	# See more keys and their definitions at https://doc.rust-lang.org/cargo/reference/manifest.html

	[dependencies]
	anyhow = "1.0.72"
	byteorder = "1.4.3"

	/**
	* cloudflare-worker-youtube-dl.js
	* Get direct links to YouTube videos using Cloudflare Workers.
	*
	* Usage:
	* GET /?v=dQw4w9WgXcQ
	* -> Returns a JSON list of supported formats
	*
	* GET /?v=dQw4w9WgXcQ&f=251
	* -> Returns a stream of the specified format ID

	<video controls="" width="400">
	<source src="http://66.128.61.175/reel/1cc976948e74aa62f7a7fde16e64fb6b/360p" type="video/mp4">
	Your browser does not support HTML5 video.
	</video>