Skip to content

Instantly share code, notes, and snippets.

View ci010's full-sized avatar
💭
Thinking

CI010 ci010

💭
Thinking
  • TimeZone GMT+8
View GitHub Profile
@ci010
ci010 / APIs Demo.EXCEL.yaml
Created August 31, 2021 07:57
For McGrillHill Online APIs
name: APIs Demo
description: For McGrillHill Online APIs
host: EXCEL
api_set: {}
script:
content: |
$("#addListeners").click(() => tryCatch(addListeners));
async function addListeners() {
const start = Date.now();
@ci010
ci010 / Range Top Mismatch.EXCEL.yaml
Created August 25, 2021 09:17
Possible Mismatch in Top parameter of range when zoom level of sheets are deferent.
name: Range Top Mismatch
description: >-
Possible Mismatch in Top parameter of range when zoom level of sheets are
deferent.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
@ci010
ci010 / APIs Demo.EXCEL.yaml
Created July 19, 2021 02:54
For McGrillHill Online APIs
name: APIs Demo
description: For McGrillHill Online APIs
host: EXCEL
api_set: {}
script:
content: |
$("#addListeners").click(() => tryCatch(addListeners));
async function addListeners() {
const start = Date.now();
name: Worksheet TabId
description: ''
host: EXCEL
api_set: {}
script:
content: |
$("#printCurrent").click(() => tryCatch(printCurrent));
$("#printTarget").click(() => tryCatch(printTarget));
async function printCurrent() {
name: TableRowCollection.DeleteRows
description: ''
host: EXCEL
api_set: {}
script:
content: |
$("#DeleteRowsAt").click(() => tryCatch(DeleteRowsAt));
$("#DeleteRows").click(() => tryCatch(DeleteRows));
async function DeleteRowsAt() {
@ci010
ci010 / Get file using slicing.EXCEL.yaml
Created June 9, 2021 05:58
Uses slicing to get the byte array and base64-encoded string that represent the current document.
name: Get file using slicing
description: >-
Uses slicing to get the byte array and base64-encoded string that represent
the current document.
host: EXCEL
api_set: {}
script:
content: |
$("#setup").click(() => tryCatch(setup));
$("#get-file").click(() => tryCatch(getCurrentFile));
name: CellEditMode
description: ''
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
console.log("Now, double click a cell to enter edit mode!");
@ci010
ci010 / Worksheet.TabId.EXCEL.yaml
Created March 16, 2021 05:54
Print Worksheet.TabId
name: Worksheet.TabId
description: Print Worksheet.TabId
host: EXCEL
api_set: {}
script:
content: >
$("#run").click(() => tryCatch(getActiveWorksheet));
$("#run1").click(() => tryCatch(getInputWorksheet));
@ci010
ci010 / Worksheet.TabId.EXCEL.yaml
Created March 15, 2021 02:15
Print Worksheet.TabId
name: Worksheet.TabId
description: Print Worksheet.TabId
host: EXCEL
api_set: {}
script:
content: >
$("#run").click(() => tryCatch(getActiveWorksheet));
$("#run1").click(() => tryCatch(getInputWorksheet));
@ci010
ci010 / BugBash.EXCEL.yaml
Last active December 8, 2020 06:39
Adjust a chart title's format.
name: BugBash
description: Adjust a chart title's format.
host: EXCEL
api_set: {}
script:
content: |
function getDir() {
const dir = $("#direction").val();
switch (dir) {
case "up":