### Configure Cells and Formatting

Source: https://github.com/3973770/swiftxlsx/blob/main/README.md

Examples of setting cell values, borders, alignment, and fonts within a worksheet.

```swift
   cell.Border = true
   cell.value = .text("item #3")

   cell = sheet.AddCell(XCoords(row: line, col: 4))
   cell.Border = true
   cell.value = .double(4)
   cell.alignmentHorizontal = .right

   cell = sheet.AddCell(XCoords(row: line, col: 5))
   cell.Border = true
   cell.value = .double(200)
   cell.alignmentHorizontal = .right

   cell = sheet.AddCell(XCoords(row: line, col: 6))
   cell.Border = true
   cell.value = .double(800)
   cell.alignmentHorizontal = .right

   line += 2

   cell = sheet.AddCell(XCoords(row: line, col: 1))
   cell.value = .text("Thank you for your business!")
   cell.Font = XFont(.TrebuchetMS, 10, false, true)
   cell.alignmentHorizontal = .left

   cell = sheet.AddCell(XCoords(row: line, col: 5))
   cell.Cols(txt: .white, bg: .systemOrange)
   cell.value = .text("Total")
   cell.Font = XFont(.TrebuchetMS, 11, true)
   cell.alignmentHorizontal = .left

   cell = sheet.AddCell(XCoords(row: line, col: 6))
   cell.Cols(txt: .white, bg: .systemOrange)
   cell.value = .double(1100)
   cell.Font = XFont(.TrebuchetMS, 11, true)
   cell.alignmentHorizontal = .right

   line += 2

   cell = sheet.AddCell(XCoords(row: line, col: 1))
   cell.value = .text("Payment Options")
   cell.Font = XFont(.TrebuchetMS, 12, true, false)
   cell.alignmentHorizontal = .left

   line += 1

   cell = sheet.AddCell(XCoords(row: line, col: 1))
   cell.value = .text("Enter PayPal email address or bank account number here")
   cell.Font = XFont(.TrebuchetMS, 10, false, true)
   cell.alignmentHorizontal = .left

   sheet.buildindex()
```

--------------------------------

### Generate Large XLSX File

Source: https://github.com/3973770/swiftxlsx/blob/main/README.md

Use this method to generate a large XLSX file with multiple sheets. No specific setup is required beyond importing the library.

```swift
    // library generate huge XLSX file with three sheets.
    XWorkBook.test()
```

--------------------------------

### List Available Font Families with XFontName

Source: https://context7.com/3973770/swiftxlsx/llms.txt

Utilize the XFontName enum to specify font families for cells. This example demonstrates assigning various common fonts to cells for visual distinction.

```swift
import SwiftXLSX

let book = XWorkBook()
let sheet = book.NewSheet("Fonts")

// Common font families
let fonts: [(XFontName, String)] = [
    (.Arial, "Arial - Sans-serif"),
    (.HelveticaNeue, "Helvetica Neue - Clean"),
    (.TimesNewRoman, "Times New Roman - Serif"),
    (.Georgia, "Georgia - Elegant Serif"),
    (.Verdana, "Verdana - Screen-friendly"),
    (.CourierNew, "Courier New - Monospace"),
    (.TrebuchetMS, "Trebuchet MS - Modern"),
    (.Futura, "Futura - Geometric"),
    (.Baskerville, "Baskerville - Classic"),
    (.Menlo, "Menlo - Code Font"),
    (.Zapfino, "Zapfino - Script"),
    (.Chalkduster, "Chalkduster - Playful"),
]

for (index, (fontName, description)) in fonts.enumerated() {
    let cell = sheet.AddCell(XCoords(row: index + 1, col: 1))
    cell.value = .text(description)
    cell.Font = XFont(fontName, 14)
}

sheet.ForColumnSetWidth(1, 200)
let filePath = book.save("font_families.xlsx")
```

--------------------------------

### Create and Populate Excel Sheet with SwiftXLSX

Source: https://github.com/3973770/swiftxlsx/blob/main/README.md

This snippet demonstrates creating a new Excel workbook, adding a sheet, and populating it with various data types and formatting. It includes setting cell values, text, numbers, colors, fonts, and alignment. Use this for generating reports or data exports.

```swift
   let book = XWorkBook()

   let color:[UIColor] = [.darkGray, .green, .lightGray, .orange, .systemPink, .cyan, .purple, .magenta, .blue]
   let colortext:[UIColor] = [.darkGray, .black, .white, .darkText, .lightText]


   func GetRandomFont() -> XFontName {
       let cases = XFontName.allCases
       return cases[Int.random(in: 0..<cases.count)]
   }


   var sheet = book.NewSheet("Invoice")

   var cell = sheet.AddCell(XCoords(row: 2, col: 6))
   cell.Cols(txt: .white, bg: .systemOrange)
   cell.value = .text("INVOICE")
   cell.Font = XFont(.TrebuchetMS, 16,true)
   cell.alignmentHorizontal = .center

   cell = sheet.AddCell(XCoords(row: 3, col: 6))
   cell.Cols(txt: .white, bg: .systemOrange)
   cell.value = .text("#12345")
   cell.Font = XFont(.TrebuchetMS, 12,true)
   cell.alignmentHorizontal = .left

   cell = sheet.AddCell(XCoords(row: 2, col: 1))
   cell.value = .text("Your company name")
   cell.Font = XFont(.TrebuchetMS, 16,true)

   cell = sheet.AddCell(XCoords(row: 3, col: 1))
   cell.value = .text("[Address Line 1]")

   cell = sheet.AddCell(XCoords(row: 4, col: 1))
   cell.value = .text("[Address Line 2]")

   cell = sheet.AddCell(XCoords(row: 5, col: 1))
   cell.value = .text("[Address Line 3]")

   cell = sheet.AddCell(XCoords(row: 7, col: 1))
   cell.color = .systemOrange
   cell.value = .text("Bill To:")
   cell.Font = XFont(.TrebuchetMS, 12,true)

   cell = sheet.AddCell(XCoords(row: 8, col: 1))
   cell.value = .text("[Address Line 1]")

   cell = sheet.AddCell(XCoords(row: 9, col: 1))
   cell.value = .text("[Address Line 2]")

   cell = sheet.AddCell(XCoords(row: 10, col: 1))
   cell.value = .text("[Address Line 3]")

   /// date
   cell = sheet.AddCell(XCoords(row: 13, col: 1))
   cell.color = .systemOrange
   cell.value = .text("Invoice Date")
   cell.Font = XFont(.TrebuchetMS, 12,true)

   cell = sheet.AddCell(XCoords(row: 14, col: 1))
   cell.value = .text("01/22/2022")

   /// term
   cell = sheet.AddCell(XCoords(row: 13, col: 2))

   cell.value = .text("Terms")
   cell.Font = XFont(.TrebuchetMS, 12,true)

   cell = sheet.AddCell(XCoords(row: 14, col: 2))
   cell.value = .text("30 days")

   /// Due Date
   cell = sheet.AddCell(XCoords(row: 13, col: 3))
   cell.color = .systemOrange
   cell.value = .text("Due Date")
   cell.Font = XFont(.TrebuchetMS, 12,true)

   cell = sheet.AddCell(XCoords(row: 14, col: 3))
   cell.value = .text("02/20/2022")

   /// table
   /// title
   var line = 16
   cell = sheet.AddCell(XCoords(row: line, col: 1))
   cell.Cols(txt: .white, bg: .systemOrange)
   cell.Border = true
   cell.value = .text("Description")

   cell = sheet.AddCell(XCoords(row: line, col: 4))
   cell.Cols(txt: .white, bg: .systemOrange)
   cell.Border = true
   cell.value = .text("Qty")
   cell.Font = XFont(.TrebuchetMS, 10,true)

   cell = sheet.AddCell(XCoords(row: line, col: 5))
   cell.Cols(txt: .white, bg: .systemOrange)
   cell.Border = true
   cell.value = .text("Unit Price")
   cell.Font = XFont(.TrebuchetMS, 10,true)

   cell = sheet.AddCell(XCoords(row: line, col: 6))
   cell.Cols(txt: .white, bg: .systemOrange)
   cell.Border = true
   cell.value = .text("Amount")
   cell.Font = XFont(.TrebuchetMS, 10,true)

   /// line
   line += 1
   cell = sheet.AddCell(XCoords(row: line, col: 1))
   cell.Border = true
   cell.value = .text("item #1")

   cell = sheet.AddCell(XCoords(row: line, col: 4))
   cell.Border = true
   cell.value = .double(3)
   cell.alignmentHorizontal = .right

   cell = sheet.AddCell(XCoords(row: line, col: 5))
   cell.Border = true
   cell.value = .double(50)
   cell.alignmentHorizontal = .right

   cell = sheet.AddCell(XCoords(row: line, col: 6))
   cell.Border = true
   cell.value = .double(150)
   cell.alignmentHorizontal = .right

   /// line
   line += 1
   cell = sheet.AddCell(XCoords(row: line, col: 1))
   if #available(iOS 13.0, *) {
       cell.Cols(txt: .black, bg: .systemGray6)
   } else {
       cell.Cols(txt: .black, bg: .lightGray)
   }
   cell.Border = true
   cell.value = .text("item #2")

   cell = sheet.AddCell(XCoords(row: line, col: 4))
   if #available(iOS 13.0, *) {
       cell.Cols(txt: .black, bg: .systemGray6)
   } else {
       cell.Cols(txt: .black, bg: .lightGray)
   }
   cell.Border = true
   cell.value = .double(2)
   cell.alignmentHorizontal = .right

   cell = sheet.AddCell(XCoords(row: line, col: 5))
   if #available(iOS 13.0, *) {
       cell.Cols(txt: .black, bg: .systemGray6)
   } else {
       cell.Cols(txt: .black, bg: .lightGray)
   }
   cell.Border = true
   cell.value = .double(100)
   cell.alignmentHorizontal = .right

   cell = sheet.AddCell(XCoords(row: line, col: 6))
   if #available(iOS 13.0, *) {
       cell.Cols(txt: .black, bg: .systemGray6)
   } else {
       cell.Cols(txt: .black, bg: .lightGray)
   }
   cell.Border = true
   cell.value = .double(200)
   cell.alignmentHorizontal = .right

   /// line
   line += 1
   cell = sheet.AddCell(XCoords(row: line, col: 1))

```

--------------------------------

### Create and Save Excel Workbooks with XWorkBook

Source: https://context7.com/3973770/swiftxlsx/llms.txt

Demonstrates how to create a new workbook, add sheets, add data to cells, and save the workbook. Requires importing SwiftXLSX.

```swift
import SwiftXLSX

// Create a new workbook
let book = XWorkBook()

// Add sheets to the workbook
let sheet1 = book.NewSheet("Sales Report")
let sheet2 = book.NewSheet("Inventory")
let sheet3 = book.NewSheet("Summary")

// Add some data to a sheet
let cell = sheet1.AddCell(XCoords(row: 1, col: 1))
cell.value = .text("Monthly Sales")

// Save the workbook and get the file path
let filePath = book.save("report.xlsx")
print("File saved to: \(filePath)")
// Output: File saved to: /var/mobile/Containers/Data/Application/.../Caches/tmpxls/report.xlsx
```

--------------------------------

### Configure Cell Values and Styling with XCell

Source: https://context7.com/3973770/swiftxlsx/llms.txt

Illustrates how to set various cell value types (text, integer, double, float, long) and apply styling such as fonts, colors, borders, and alignment. Requires importing SwiftXLSX and platform-specific UI frameworks.

```swift
import SwiftXLSX
#if os(iOS)
import UIKit
#else
import Cocoa
#endif

let book = XWorkBook()
let sheet = book.NewSheet("Styled Cells")

// Text cell with custom font and colors
let titleCell = sheet.AddCell(XCoords(row: 1, col: 1))
titleCell.value = .text("Invoice Total")
titleCell.Font = XFont(.TrebuchetMS, 16, true)  // Font name, size, bold
titleCell.Cols(txt: .white, bg: .systemBlue)    // Text color, background color
titleCell.alignmentHorizontal = .center
titleCell.alignmentVertical = .center
titleCell.Border = true

// Numeric cells with different types
let intCell = sheet.AddCell(XCoords(row: 2, col: 1))
intCell.value = .integer(42)
intCell.alignmentHorizontal = .right

let doubleCell = sheet.AddCell(XCoords(row: 2, col: 2))
doubleCell.value = .double(1299.99)
doubleCell.alignmentHorizontal = .right

let floatCell = sheet.AddCell(XCoords(row: 2, col: 3))
floatCell.value = .float(3.14)

let longCell = sheet.AddCell(XCoords(row: 2, col: 4))
longCell.value = .long(9876543210)

// Cell with italic and underline font
let noteCell = sheet.AddCell(XCoords(row: 3, col: 1))
noteCell.value = .text("Important note")
noteCell.Font = XFont(.Georgia, 12, false, true, false, true)  // size, bold, italic, strike, underline
noteCell.color = .red

// Alternative alignment method
let alignedCell = sheet.AddCell(XCoords(row: 4, col: 1))
alignedCell.value = .text("Aligned")
alignedCell.Als(v: .bottom, h: .right)  // Vertical, Horizontal alignment

let filePath = book.save("styled_cells.xlsx")
```

--------------------------------

### Create a complete invoice workbook

Source: https://context7.com/3973770/swiftxlsx/llms.txt

Demonstrates how to build a multi-sheet workbook with custom fonts, colors, borders, and merged cells. Requires the SwiftXLSX library and platform-specific imports for UIKit or Cocoa.

```swift
import SwiftXLSX
#if os(iOS)
import UIKit
#else
import Cocoa
#endif

let book = XWorkBook()

// Create Invoice Sheet
var sheet = book.NewSheet("Invoice")

// Company Header
var cell = sheet.AddCell(XCoords(row: 2, col: 1))
cell.value = .text("ACME Corporation")
cell.Font = XFont(.TrebuchetMS, 18, true)

cell = sheet.AddCell(XCoords(row: 3, col: 1))
cell.value = .text("123 Business Street")

cell = sheet.AddCell(XCoords(row: 4, col: 1))
cell.value = .text("New York, NY 10001")

// Invoice Title
cell = sheet.AddCell(XCoords(row: 2, col: 5))
cell.Cols(txt: .white, bg: .systemOrange)
cell.value = .text("INVOICE")
cell.Font = XFont(.TrebuchetMS, 16, true)
cell.alignmentHorizontal = .center

cell = sheet.AddCell(XCoords(row: 3, col: 5))
cell.Cols(txt: .white, bg: .systemOrange)
cell.value = .text("#INV-2024-001")
cell.Font = XFont(.TrebuchetMS, 12)
cell.alignmentHorizontal = .center

// Bill To Section
cell = sheet.AddCell(XCoords(row: 7, col: 1))
cell.value = .text("Bill To:")
cell.Font = XFont(.TrebuchetMS, 12, true)
cell.color = .systemOrange

cell = sheet.AddCell(XCoords(row: 8, col: 1))
cell.value = .text("Customer Name")
cell = sheet.AddCell(XCoords(row: 9, col: 1))
cell.value = .text("456 Customer Ave")

// Date Information
cell = sheet.AddCell(XCoords(row: 7, col: 4))
cell.value = .text("Invoice Date:")
cell.Font = XFont(.TrebuchetMS, 10, true)
cell = sheet.AddCell(XCoords(row: 7, col: 5))
cell.value = .text("2024-01-15")

cell = sheet.AddCell(XCoords(row: 8, col: 4))
cell.value = .text("Due Date:")
cell.Font = XFont(.TrebuchetMS, 10, true)
cell = sheet.AddCell(XCoords(row: 8, col: 5))
cell.value = .text("2024-02-14")

// Table Header
let headerRow = 12
let headers = ["Description", "Qty", "Unit Price", "Amount"]
let headerCols = [1, 3, 4, 5]

for (index, header) in headers.enumerated() {
    cell = sheet.AddCell(XCoords(row: headerRow, col: headerCols[index]))
    cell.Cols(txt: .white, bg: .systemOrange)
    cell.value = .text(header)
    cell.Font = XFont(.TrebuchetMS, 11, true)
    cell.Border = true
    cell.alignmentHorizontal = index == 0 ? .left : .center
}

// Table Data
let items: [(String, Int, Double)] = [
    ("Web Development Services", 40, 150.00),
    ("UI/UX Design", 20, 125.00),
    ("Server Hosting (Monthly)", 1, 99.00),
]

for (rowOffset, item) in items.enumerated() {
    let dataRow = headerRow + 1 + rowOffset
    let bgColor: ColorClass = rowOffset % 2 == 0 ? .white : .lightGray

    // Description
    cell = sheet.AddCell(XCoords(row: dataRow, col: 1))
    cell.value = .text(item.0)
    cell.colorbackground = bgColor
    cell.Border = true

    // Quantity
    cell = sheet.AddCell(XCoords(row: dataRow, col: 3))
    cell.value = .integer(item.1)
    cell.colorbackground = bgColor
    cell.Border = true
    cell.alignmentHorizontal = .center

    // Unit Price
    cell = sheet.AddCell(XCoords(row: dataRow, col: 4))
    cell.value = .double(item.2)
    cell.colorbackground = bgColor
    cell.Border = true
    cell.alignmentHorizontal = .right

    // Amount
    cell = sheet.AddCell(XCoords(row: dataRow, col: 5))
    cell.value = .double(Double(item.1) * item.2)
    cell.colorbackground = bgColor
    cell.Border = true
    cell.alignmentHorizontal = .right
}

// Total Row
let totalRow = headerRow + 4
let total = items.reduce(0.0) { $0 + (Double($1.1) * $1.2) }

cell = sheet.AddCell(XCoords(row: totalRow, col: 4))
cell.Cols(txt: .white, bg: .systemOrange)
cell.value = .text("Total:")
cell.Font = XFont(.TrebuchetMS, 12, true)
cell.alignmentHorizontal = .right

cell = sheet.AddCell(XCoords(row: totalRow, col: 5))
cell.Cols(txt: .white, bg: .systemOrange)
cell.value = .double(total)
cell.Font = XFont(.TrebuchetMS, 12, true)
cell.alignmentHorizontal = .right

// Merge description column cells
sheet.MergeRect(XRect(headerRow, 1, 2, 1))
for i in 0..<items.count {
    sheet.MergeRect(XRect(headerRow + 1 + i, 1, 2, 1))
}

// Set column widths
sheet.ForColumnSetWidth(1, 120)
sheet.ForColumnSetWidth(2, 80)
sheet.ForColumnSetWidth(3, 50)
sheet.ForColumnSetWidth(4, 80)
sheet.ForColumnSetWidth(5, 80)

// Thank you message
cell = sheet.AddCell(XCoords(row: totalRow + 2, col: 1))
cell.value = .text("Thank you for your business!")
cell.Font = XFont(.TrebuchetMS, 10, false, true)

// Save the workbook
let filePath = book.save("invoice.xlsx")
print("Invoice saved to: \(filePath)")
```

--------------------------------

### Manage Worksheet Content with XSheet

Source: https://context7.com/3973770/swiftxlsx/llms.txt

Shows how to add cells, set column widths and row heights, merge cells, and build an index for a worksheet. Requires importing SwiftXLSX.

```swift
import SwiftXLSX

let book = XWorkBook()
let sheet = book.NewSheet("Data Sheet")

// Add cells at specific coordinates (row, col are 1-indexed)
let headerCell = sheet.AddCell(XCoords(row: 1, col: 1))
headerCell.value = .text("Product Name")

let priceHeader = sheet.AddCell(XCoords(row: 1, col: 2))
priceHeader.value = .text("Price")

// Set column widths (in points)
sheet.ForColumnSetWidth(1, 150)  // Column A = 150 points wide
sheet.ForColumnSetWidth(2, 80)   // Column B = 80 points wide

// Set row height
sheet.ForRowSetHeight(1, 30)     // Row 1 = 30 points tall

// Merge cells: XRect(row, col, width, height)
// This merges A3:C3 (row 3, columns 1-3)
sheet.MergeRect(XRect(3, 1, 3, 1))

// Build the cell index for optimal lookup performance
sheet.buildindex()

// Retrieve a cell by coordinates
if let existingCell = sheet.Get(XCoords(row: 1, col: 1)) {
    print("Cell value exists")
}

let filePath = book.save("sheet_demo.xlsx")
```

--------------------------------

### Performance Testing with Large Datasets

Source: https://github.com/3973770/swiftxlsx/blob/main/README.md

Generating large sheets with randomized data to test performance.

```swift
   sheet = book.NewSheet("Perfomance1 Sheet")
   for col in 1...20 {
       sheet.ForColumnSetWidth(col,Int.random(in: 50..<100))
       for row in 1...1000 {
           let cell = sheet.AddCell(XCoords(row: row, col: col))
           cell.value = .integer(Int.random(in: 100..<200000))
           cell.Font = XFont(GetRandomFont(), Int.random(in: 10..<20))
           cell.color = colortext[Int.random(in: 0..<colortext.count)]
           cell.colorbackground = color[Int.random(in: 0..<color.count)]
           cell.Border = true
           cell.alignmentHorizontal = .center
           cell.alignmentVertical = .center
       }
   }

   sheet = book.NewSheet("Perfomance2 Sheet")
   for col in 1...20 {
       sheet.ForColumnSetWidth(col,Int.random(in: 50..<100))
       for row in 1...1000 {
           let cell = sheet.AddCell(XCoords(row: row, col: col))
           cell.value = .text("\(row):\(col)")
           cell.Font = XFont(GetRandomFont(), Int.random(in: 10..<20))
           cell.color = colortext[Int.random(in: 0..<colortext.count)]
           cell.colorbackground = color[Int.random(in: 0..<color.count)]
           cell.Border = true
           cell.alignmentHorizontal = .center
           cell.alignmentVertical = .center
       }
   }
```

--------------------------------

### Add SwiftXLSX Dependency

Source: https://github.com/3973770/swiftxlsx/blob/main/README.md

Add SwiftXLSX as a dependency in your Swift package by including its URL and version in the Package.swift file.

```swift
dependencies: [
  .package(url: "https://github.com/3973770/SwiftXLSX", .upToNextMajor(from: "0.1.0"))
]
```

--------------------------------

### Configure Text Alignment with XAligmentHorizontal and XAligmentVertical

Source: https://context7.com/3973770/swiftxlsx/llms.txt

Control cell text alignment using horizontal and vertical enums, or the combined Als method.

```swift
import SwiftXLSX

let book = XWorkBook()
let sheet = book.NewSheet("Alignment")

// Horizontal alignment options
let hAlignments: [(XAligmentHorizontal, String)] = [
    (.left, "Left Aligned"),
    (.center, "Center Aligned"),
    (.right, "Right Aligned")
]

for (index, (alignment, text)) in hAlignments.enumerated() {
    let cell = sheet.AddCell(XCoords(row: index + 1, col: 1))
    cell.value = .text(text)
    cell.alignmentHorizontal = alignment
    cell.Border = true
}

// Vertical alignment options (set row height to see effect)
let vAlignments: [(XAligmentVertical, String)] = [
    (.top, "Top"),
    (.center, "Center"),
    (.bottom, "Bottom")
]

for (index, (alignment, text)) in vAlignments.enumerated() {
    let cell = sheet.AddCell(XCoords(row: index + 1, col: 3))
    cell.value = .text(text)
    cell.alignmentVertical = alignment
    cell.alignmentHorizontal = .center
    cell.Border = true
    sheet.ForRowSetHeight(index + 1, 50)  // Taller rows to show vertical alignment
}

// Combined alignment using Als method
let combinedCell = sheet.AddCell(XCoords(row: 5, col: 1))
combinedCell.value = .text("Bottom-Right")
combinedCell.Als(v: .bottom, h: .right)
combinedCell.Border = true
sheet.ForRowSetHeight(5, 60)

sheet.ForColumnSetWidth(1, 120)
sheet.ForColumnSetWidth(3, 100)

let filePath = book.save("alignment.xlsx")
```

--------------------------------

### Define Cell Typography with XFont

Source: https://context7.com/3973770/swiftxlsx/llms.txt

Configure cell text appearance including font family, size, and text decorations like bold, italic, strikethrough, and underline. Use XFont with various parameters to achieve desired styling.

```swift
import SwiftXLSX

let book = XWorkBook()
let sheet = book.NewSheet("Font Styles")

// Basic font: font name and size
let basicCell = sheet.AddCell(XCoords(row: 1, col: 1))
basicCell.value = .text("Basic Arial 12pt")
basicCell.Font = XFont(.Arial, 12)

// Bold font
let boldCell = sheet.AddCell(XCoords(row: 2, col: 1))
boldCell.value = .text("Bold Text")
boldCell.Font = XFont(.HelveticaNeue, 14, true)  // bold = true

// Bold and italic
let boldItalicCell = sheet.AddCell(XCoords(row: 3, col: 1))
boldItalicCell.value = .text("Bold & Italic")
boldItalicCell.Font = XFont(.TimesNewRoman, 14, true, true)  // bold, italic

// Strikethrough text
let strikeCell = sheet.AddCell(XCoords(row: 4, col: 1))
strikeCell.value = .text("Strikethrough")
strikeCell.Font = XFont(.Verdana, 12, false, false, true)  // strike = true

// Underlined text
let underlineCell = sheet.AddCell(XCoords(row: 5, col: 1))
underlineCell.value = .text("Underlined")
underlineCell.Font = XFont(.Georgia, 12, false, false, false, true)  // underline = true

// Full formatting: XFont(name, size, bold, italic, strike, underline)
let fullStyleCell = sheet.AddCell(XCoords(row: 6, col: 1))
fullStyleCell.value = .text("All Styles")
fullStyleCell.Font = XFont(.Futura, 16, true, true, false, true)

let filePath = book.save("font_styles.xlsx")
```

--------------------------------

### Save Spreadsheet File

Source: https://github.com/3973770/swiftxlsx/blob/main/README.md

Finalizing and saving the workbook to a file.

```swift
   let fileid = book.save("example.xlsx")
   print("<<<File XLSX generated!>>>")
   print("\(fileid)")
```

--------------------------------

### Manage Cell Positioning and Regions with XCoords and XRect

Source: https://context7.com/3973770/swiftxlsx/llms.txt

Define specific cell locations using 1-indexed XCoords and create merged cell regions using XRect.

```swift
import SwiftXLSX

let book = XWorkBook()
let sheet = book.NewSheet("Positioning")

// XCoords: row and column are 1-indexed
// Row 1, Column 1 = Cell A1
let a1 = sheet.AddCell(XCoords(row: 1, col: 1))
a1.value = .text("A1")

// Row 1, Column 3 = Cell C1
let c1 = sheet.AddCell(XCoords(row: 1, col: 3))
c1.value = .text("C1")

// Row 5, Column 2 = Cell B5
let b5 = sheet.AddCell(XCoords(row: 5, col: 2))
b5.value = .text("B5")

// XRect for merging: XRect(startRow, startCol, width, height)
// Merge A3:D3 (row 3, columns 1-4, span 4 wide, 1 tall)
let mergedHeader = sheet.AddCell(XCoords(row: 3, col: 1))
mergedHeader.value = .text("Merged Header A3:D3")
mergedHeader.Cols(txt: .white, bg: .darkGray)
mergedHeader.alignmentHorizontal = .center
sheet.MergeRect(XRect(3, 1, 4, 1))

// Merge B7:C9 (start at B7, 2 columns wide, 3 rows tall)
let verticalMerge = sheet.AddCell(XCoords(row: 7, col: 2))
verticalMerge.value = .text("Vertical Merge B7:C9")
verticalMerge.Cols(txt: .black, bg: .yellow)
verticalMerge.alignmentHorizontal = .center
verticalMerge.alignmentVertical = .center
sheet.MergeRect(XRect(7, 2, 2, 3))

// Check if coordinate is within a rectangle
let rect = XRect(7, 2, 2, 3)
let testCoord = XCoords(row: 8, col: 2)
let isInRect = rect.inrect(testCoord)  // Returns true (inside but not origin)

let filePath = book.save("positioning.xlsx")
```

--------------------------------

### Merge Cells and Set Column Widths

Source: https://github.com/3973770/swiftxlsx/blob/main/README.md

Methods for merging rectangular cell areas and defining specific column widths.

```swift
   sheet.MergeRect(XRect(2, 1, 5, 1))
   sheet.MergeRect(XRect(3, 1, 5, 1))
   sheet.MergeRect(XRect(4, 1, 5, 1))
   sheet.MergeRect(XRect(5, 1, 5, 1))

   sheet.MergeRect(XRect(16, 1, 3, 1))
   sheet.MergeRect(XRect(17, 1, 3, 1))
   sheet.MergeRect(XRect(18, 1, 3, 1))
   sheet.MergeRect(XRect(19, 1, 3, 1))

   sheet.MergeRect(XRect(23, 1, 3, 1))
   sheet.MergeRect(XRect(24, 1, 3, 1))


   sheet.ForColumnSetWidth(1, 100)
   sheet.ForColumnSetWidth(2, 70)
   sheet.ForColumnSetWidth(3, 60)
   sheet.ForColumnSetWidth(4, 70)
   sheet.ForColumnSetWidth(5, 70)
   sheet.ForColumnSetWidth(6, 90)
```

--------------------------------

### Embed Images in Cells with XImages and XImageCell

Source: https://context7.com/3973770/swiftxlsx/llms.txt

Use XImages to register image assets and XImageCell to define their placement and display size within a worksheet.

```swift
import SwiftXLSX
#if os(iOS)
import UIKit
typealias PlatformImage = UIImage
#else
import Cocoa
typealias PlatformImage = NSImage
#endif

let book = XWorkBook()
let sheet = book.NewSheet("Images")

// Load an image (from bundle, file, or create programmatically)
if let logoImage = PlatformImage(named: "company_logo") {
    // Register image with XImages and get a unique key
    if let imageKey = XImages.append(with: logoImage) {

        // Create a cell with the image
        let imageCell = sheet.AddCell(XCoords(row: 1, col: 1))
        let imageCellValue = XImageCell(
            key: imageKey,
            size: CGSize(width: 200, height: 75)  // Display size in pixels
        )
        imageCell.value = .icon(imageCellValue)

        // Same image at different size
        let largeImageCell = sheet.AddCell(XCoords(row: 5, col: 1))
        let largeImageValue = XImageCell(
            key: imageKey,  // Reuse same image key
            size: CGSize(width: 400, height: 150)
        )
        largeImageCell.value = .icon(largeImageValue)
    }
}

// Add multiple different images
let iconNames = ["icon1", "icon2", "icon3"]
for (index, iconName) in iconNames.enumerated() {
    if let iconImage = PlatformImage(named: iconName),
       let iconKey = XImages.append(with: iconImage) {
        let cell = sheet.AddCell(XCoords(row: 1, col: index + 2))
        cell.value = .icon(XImageCell(key: iconKey, size: CGSize(width: 32, height: 32)))
    }
}

// Set column width to accommodate images
sheet.ForColumnSetWidth(1, 250)

let filePath = book.save("images.xlsx")

// Clean up image cache when done
XImages.removeAll()
```

--------------------------------

### Insert Image into Cell

Source: https://github.com/3973770/swiftxlsx/blob/main/README.md

To insert an image into a cell, use the XValue.icon initializer with an XImageCell object. Ensure the image is appended to XImages first.

```swift
    //new kind value of XValue for icons/images 
    XValue.icon(XImageCell)
```

```swift
   let cell = sheet.AddCell(XCoords(row: 1, col: 1))
   let ImageCellValue:XImageCell = XImageCell(key: XImages.append(with: logoicon!)!, size: CGSize(width: 200, height: 75))
   // CGSize(width: 200, height: 75) - size display image in pixel
    cell.value = .icon(ImageCellValue)
```

--------------------------------

### Assign Different Data Types with XValue

Source: https://context7.com/3973770/swiftxlsx/llms.txt

Represent various data types within cells using the XValue enum. This includes text, integers, doubles, floats, and large numbers (UInt64).

```swift
import SwiftXLSX

let book = XWorkBook()
let sheet = book.NewSheet("Value Types")

// Text value
let textCell = sheet.AddCell(XCoords(row: 1, col: 1))
textCell.value = .text("Hello, World!")

// Integer value
let intCell = sheet.AddCell(XCoords(row: 2, col: 1))
intCell.value = .integer(12345)

// Double value (formatted to 3 decimal places in output)
let doubleCell = sheet.AddCell(XCoords(row: 3, col: 1))
doubleCell.value = .double(3.14159265)

// Float value
let floatCell = sheet.AddCell(XCoords(row: 4, col: 1))
floatCell.value = .float(2.718)

// Long (UInt64) value for large numbers
let longCell = sheet.AddCell(XCoords(row: 5, col: 1))
longCell.value = .long(9223372036854775807)

// Labels for clarity
let labels = ["Text:", "Integer:", "Double:", "Float:", "Long:"]
for (index, label) in labels.enumerated() {
    let labelCell = sheet.AddCell(XCoords(row: index + 1, col: 2))
    labelCell.value = .text(label)
    labelCell.Font = XFont(.Arial, 10, true)
}

let filePath = book.save("value_types.xlsx")
```

=== COMPLETE CONTENT === This response contains all available snippets from this library. No additional content exists. Do not make further requests.