Samsung Note on Windows
FFmpeg Convert Video Format
FFmpeg is a free and open-source software project consisting of a suite of libraries and programs for handling video, audio, and other multimedia files and streams. At its core is the command-line ffmpeg tool itself, designed for processing video and audio files. It is widely used for format transcoding, basic editing (trimming and concatenation), video scaling, video post-production effects, and standards compliance (SMPTE, ITU).
Wikipedia ── FFmpeg
Introduction
在本篇文章中會透過 FFmpeg 實現將影片編碼轉換。
VSCode with iverilog Environment Settings
Change uWSGI Python Version from Default to Specific
Export Photo from iPhone and View on Windows 10
記錄一下如何在 iPhone 匯出、並在 Windows 10 上瀏覽 HEIC 檔案。
Export LINE Messages between Android and iOS
dotNET Core Update from 3.1 to 6
Migrate ASP.NET Core Razor Project
In this paragraph, we will update the ASP.NET Core project from 3.1 to 6.
The following table shows that current LTS version status:
| LTS Version | Release Date | EOS |
|---|---|---|
| .NET Core 2.1 | 2018-05-30 | 2021-08-21 |
| .NET Core 3.1 | 2019-12-03 | 2020-12-13 |
| .NET 6 | 2021-11-08 | 2024-11-12 |
| .NET 8 | 2023-11 (projected) | 2026-12 (projected) |
Python Inject VBA Macro into XLSM File
Introduction
雖然在 Python 中可以通過 openpyxl 套件來很好的操作 Excel 讀寫,但當想要在檔案中插入 VBA macro 時便沒有辦法依靠 openpyxl。不過我們仍然可以透過 pywin32 套件來操作 Windows API,達到在 Excel 檔案中插入 VBA macro 的需求。
在本篇文章中將會提到:
- 透過
pywin32對 XLSM 檔案插入 VBA macro。 - 解決在過程中會出現的「檔案信任」的問題。
- 將程式碼包裝為類(class)以方便使用,以及其使用範例。
- 如何透過
openpyxl建立可插入 VBA macro 的 XLSM 檔案。
