Embedding Built-In Swift Data with Xlsx

My new app is going to have a built-in filled SwiftData. When I was building one of my own app, supporting to study for public license test. I considered about how to construct database and manage it conveniently.

I didn’t want to make any server or tool. The popular solution was Excel(xlsx) file. We can input various and huge arranged contents and there is already a good tool, Microsoft Excel.

So I decided to make the database using a spreadsheet.

Setting up Spreadsheet

Embeding Spreadsheet

Install CoreXLSX

Excel Repository

Reading Sheets

Reading Cells

Reading Cells using Rows

Loading Headers

Loading Row

Generating Info with Row

Synchronizing Swift Data

SQLite

Embedding SQLite

#swiftdata #excel #builtin #sqlite

https://toyboy2.medium.com/embedding-built-in-swift-data-with-xlsx-in-ios-f878edc1e3c6