SplatDev.Content 1.0.2

SplatDev.Content

Content helper utilities for .NET applications — Excel import/export, CSV parsing, QR code generation, encryption/decryption, ISO 3166 country data with 240+ countries, timezone data, string helpers, and validation models.

Compatibility

Installation

dotnet add package SplatDev.Content

Configuration

Excel Import/Export (EPPlus)

using SplatDev.Content;

// Export a collection to Excel
var data = GetProducts();
var excelBytes = ExcelImporterHelpers.ExportToExcel(data, "Products");

// Import Excel data into a list
using var stream = File.OpenRead("products.xlsx");
var products = ExcelImporterHelpers.ImportFromExcel<Product>(stream);

CSV Parsing

using SplatDev.Content;

// Parse CSV data from a string or stream
var records = CsvHelpers.Parse<Customer>(csvData);
var csvOutput = CsvHelpers.Serialize(records);

QR Code Generation

using SplatDev.Content;

// Generate a QR code as a byte array (PNG)
var qrBytes = QRHelpers.GenerateQrCode("https://example.com", width: 300, height: 300);
File.WriteAllBytes("qrcode.png", qrBytes);

Encryption & Decryption

using SplatDev.Content;

var encrypted = EncrypDecryptHelpers.Encrypt("sensitive data", "my-secret-key");
var decrypted = EncrypDecryptHelpers.Decrypt(encrypted, "my-secret-key");

Country & Timezone Data

using SplatDev.Content;

// Look up a country by ISO 3166 code
var country = CountryHelpers.GetByCode("BR");          // Brazil
var name = Countries.Brazil.ToString();                // "Brazil"
var isoCountry = Iso3166Countries.GetByAlpha2("US");   // ISO3166Country object

// Access timezone information
var timezones = TimeZones.GetAll();
var brasiliaTz = TimeZones.GetByIanaId("America/Sao_Paulo");

Features

• Excel import/export via EPPlus — supports DataTable, List<T>, and streams
• CSV parsing and serialization with header mapping
• QR code generation with configurable dimensions
• Symmetric encryption and decryption for sensitive data
• Complete ISO 3166 country data: 240+ countries with alpha-2, alpha-3, numeric codes, capitals, and continents
• Countries enum (240+ entries) for compile-time country references
• ISO3166Country model with full metadata (name, codes, continent, currency)
• Iso3166Countries static lookup by code, name, or region
• TimeZones class providing IANA timezone IDs with UTC offsets
• String extension helpers: truncation, slug generation, HTML sanitization
• Validation models for common input types (email, phone, URL, etc.)

Key Classes

Dependencies

SplatDev.Content — part of the SplatDev.Umbraco.Plugins suite. Licensed under MIT. © SplatDev Ltda.

Changelog

1.0.2 — 2026-08-24

Removes a dashboard screenshot that showed an error toast. It was captured against a site where this plugin's API was unreachable, so it advertised a broken dashboard. No screenshot is better than a misleading one; a replacement will be taken against a working install.

1.0.1 — 2026-08-24

Package metadata only: the listing now carries an icon and search tags, and the project and repository links point at the organisation that actually hosts this code. No code changes.

1.0.0 — 2026-08-24

This package now keeps a changelog. Earlier releases predate it and are not reconstructed here — consult the repository history for those. From this version on, every release records what changed for someone using it.