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.

	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/

	##Learning Bursa
	https://www.bursamalaysia.com/trade/trading_resources/brokers_for_derivatives/list_of_trading_participants
	https://www.moomoo.com/my

	https://www.creem.io/pricing (appsumo)
	https://appsumo.com/products/locker-password-manager/
	https://docs.2fauth.app/usage/steam-guard/
	https://docs.onlykey.io/importpgp.html
	https://tld-list.com/ (Porkbun vs spaceship vs domain.com?)(nameserver / A record way)
	Blockchain Web3 digital identity

	#agency
	https://cuppa.ai/features/integrations

	Nvidia AI AGENT

	##
	https://glama.ai/pricing

	https://labs.iximiuz.com/premium
	https://kodekloud.com/community/t/extend-the-lab-time/397106
	https://kodekloud.com/community/t/what-are-the-limitations-for-playgrounds/462284
	https://help.pluralsight.com/hc/en-us/articles/24425549311380-Cloud-sandboxes-getting-started#access (4 hour and 8 hour team plan)

	https://docs.getcommandeer.com/releases/latest/version-1.8.0-3-23-2021/#view-container-and-volume-files

	https://dev.to/siddhantkcode/binary-embedding-shrink-vector-storage-by-95-5e0l
	https://myscale.com/blog/full-text-search-battle-weaviate-qdrant/

	{pkgs}: {
	channel = "stable-24.05";
	packages = [
	pkgs.nodejs_20
	pkgs.yarn
	pkgs.nodePackages.pnpm
	pkgs.bun
	];
	env = { HELLO="worl"; };
	idx.extensions = [

	https://www.izoukhai.com/blog/directus-vs-strapi-full-comparison
	refine.dev (directus,strapi,rest,graphql,hasura,nestjs,nextjs,remix

	https://github.com/directus/directus
	https://strapi.io/blog/getting-started-with-strapi-workflows-using-git
	https://github.com/statamic/cms
	payload 3.0 with next.js, ESM across,

	https://www.youtube.com/watch?v=Z8W0BpsKybs&pp=ygUTZGlyZWN0dXMgQU5EIHN0cmFwaQ%3D%3D

	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) {

visionarylab

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

Introduction

Experiences

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

DASH video