Tagged articles
data conversion
16 articles · Page 1 of 1
The article explains a real‑world requirement to map numeric business levels to Chinese strings in Excel and provides two Python solutions—one using openpyxl for modern .xlsx files and another using win32com for legacy .xls files—complete with runnable code and execution results.
Excel AutomationPythondata conversion
0 likes · 8 min read

Learn how to transform CSV files into polished HTML using a free Cloudmersive API in PHP, covering required Composer installation, API key setup, and a complete code example that handles conversion and error handling for efficient, accurate results.
CSVCloudmersive APIHTML
0 likes · 3 min read

This article explains why converting a YAML document containing both numeric and string keys (e.g., 1 and "1") to JSON fails in Go using yaml.v3, demonstrates the resulting errors, and shows how to resolve the issue with dyno.ConvertMapI2MapS or alternative libraries, while also comparing behavior in Python and JavaScript.
GoJSONSerialization
0 likes · 17 min read

This article walks through building a reusable EasyExcel wrapper for Spring Boot, covering environment setup, step‑by‑step usage, full source code, common pitfalls like date formatting and POI version conflicts, and practical solutions to ensure reliable Excel import and export.
EasyExcelExcel ExportJava backend
0 likes · 20 min read

This article explains the structure of XML, outlines the general rules for converting XML to JSON using Python's ElementTree, highlights key conversion nuances such as attributes, text nodes, repeated tags, CDATA and namespaces, and provides a complete Tkinter‑based GUI implementation.
PythonXMLdata conversion
0 likes · 10 min read

This article explains how Spring Boot 3's BeanWrapper simplifies Java object property manipulation with detailed examples covering basic usage, map binding, nested objects, collections, custom type conversion, HTTP request binding, property access, and metadata extraction.
BeanWrapperJavaProperty Binding
0 likes · 9 min read

This article explains how PHP's built-in json_decode function converts JSON-formatted strings into PHP variables, demonstrating both object and associative array outputs with code examples, and shows how to adjust parameters to obtain the desired data structure.
BackendPHPdata conversion
0 likes · 4 min read

This article explains how to convert between strings, lists, dictionaries, and JSON in Python using ast.literal_eval, json.loads, and json.dumps, and demonstrates practical applications such as API response handling in automation testing.
JSONListPython
0 likes · 6 min read

This article explains how PHP's json_decode function can transform JSON-formatted strings into PHP objects or associative arrays, demonstrates usage with code examples, and shows the resulting output for both object and array conversions.
BackendJSONdata conversion
0 likes · 4 min read

Learn how to use the Linux dd command for low‑level I/O tasks, including copying, converting, creating backups, generating files, testing disk speed, creating swap space, making bootable USB drives, and handling MBR, with detailed parameter explanations and practical examples.
data conversiondd commanddisk backup
0 likes · 15 min read

This article provides a collection of Python examples that demonstrate how to convert lists and strings to JSON, format dates and timestamps, read files, generate QR codes and barcodes, compare lists and JSON data, retrieve class methods via reflection, and automatically delete large files based on size and time.
BarcodeDATETIMEFile I/O
0 likes · 14 min read

This article presents a collection of Python code examples covering JSON serialization, date‑time formatting, file reading, QR‑code and barcode creation, list and JSON comparison, class method reflection, and automatic file‑size‑based cleanup, providing practical guidance for everyday scripting tasks.
BarcodeFile I/OPython
0 likes · 14 min read

The second article in the user‑behavior series explains ClickHouse‑based funnel analysis, covering unordered and ordered models, configuration, computation, and storage phases, key ClickHouse functions such as windowFunnel and array utilities, detailed SQL examples, and optimization strategies for real‑time, low‑cost querying.
ClickHouseClickHouse functionsFunnel Analysis
0 likes · 17 min read

This article introduces Python’s struct module, explaining how it converts between bytes and other binary data types, detailing its functions, format strings, alignment options, and practical examples of packing, unpacking, and size calculation for efficient binary data handling.
PythonStructbinary data
0 likes · 6 min read

This guide shows how to retrieve MySQL query results in Python and transform the default tuple output into usable string, list, and JSON formats, providing complete code examples for each conversion method to support automated testing validation.
JSONMySQLPython
0 likes · 6 min read

This article explains how to use Node.js C++ Addons and the V8 API to define, convert, and transfer JavaScript primitive and complex types to C++ and back, covering type inheritance, immutability, argument handling, and the role of NAN for version stability.
C++ AddonsNaNNode.js
0 likes · 13 min read
