Skip to content

Instantly share code, notes, and snippets.

@CodingOctocat
CodingOctocat / xlutils.py
Created August 29, 2022 13:48
openpyxl utils.
import re
from enum import Enum
from typing import Union, Optional
from openpyxl.cell.cell import Cell, MergedCell
from openpyxl.worksheet.cell_range import CellRange
from openpyxl.worksheet.worksheet import Worksheet
class Direction(Enum):
@CodingOctocat
CodingOctocat / xlconvertor.py
Created August 29, 2022 13:47
xls2xlsx or xlsx2xls.
import os
from enum import Enum
import win32com.client as win32
class Overwrite(Enum):
ASK = 0
ALWAYS = 1
NEVER = 2
@CodingOctocat
CodingOctocat / DebounceDispatcher.cs
Created August 29, 2022 13:01
Debounce Dispatcher.
using System;
using System.Collections.Concurrent;
using System.Threading.Tasks;
using System.Timers;
using System.Windows.Threading;
namespace CodingNinja.Common;
/// <summary>
/// Debounce Dispatcher.
@CodingOctocat
CodingOctocat / ISubtitle.cs
Last active May 8, 2022 03:38
Speech-to-Subtitle (word-level timestamp) code snippet based on MS Azure Speech.
/// <summary>
/// 表示一条包含基本要素的字幕。
/// </summary>
public interface ISubtitle
{
/// <summary>
/// 获取或设置字幕的开始时间。
/// </summary>
public TimeSpan Begin { get; set; }