Home

Awesome

kishikawakatsumi/SpreadsheetView has moved!

It is being actively maintained at bannzai/SpreadsheetView.

This fork was created when the project was moved, and is provided for backwards compatibility for old projects, but no guarantees are made on how up to date it will be.

You're encouraged to update your import statements to use the official bannzai/SpreadsheetViewk version above.

Apologies for the fuss, the new place has amazing people maintaining the community alive.

<p align="center"> <img src="Resources/Logo.png" style="width: 400px;" width="400" /> </p> <p align="center"> <a href="https://travis-ci.org/kishikawakatsumi/SpreadsheetView"> <img src="https://travis-ci.org/kishikawakatsumi/SpreadsheetView.svg?branch=master&style=flat" alt="Build Status"> </a> <a href="https://codecov.io/gh/kishikawakatsumi/SpreadsheetView"> <img src="https://codecov.io/gh/kishikawakatsumi/SpreadsheetView/branch/master/graph/badge.svg" alt="Codecov" /> </a> <a href="https://cocoapods.org/pods/SpreadsheetView"> <img src="https://img.shields.io/cocoapods/v/SpreadsheetView.svg?style=flat" alt="Pods Version"> </a> <a href="http://cocoapods.org/pods/SpreadsheetView/"> <img src="https://img.shields.io/cocoapods/p/SpreadsheetView.svg?style=flat" alt="Platforms"> </a> <a href="https://github.com/Carthage/Carthage"> <img src="https://img.shields.io/badge/Carthage-compatible-brightgreen.svg?style=flat" alt="Carthage Compatible"> </a> </p>

Full configurable spreadsheet view user interfaces for iOS applications. With this framework, you can easily create complex layouts like schedule, Gantt chart, timetable as if you are using Excel.

<img src="Resources/DailySchedule_portrait.png" style="width: 300px; height: 534px;" width="300" height="534"></img> <img src="Resources/DailySchedule_landscape.png" style="width: 534px; height: 300px;" width="534" height="300"></img><br> <img src="Resources/Timetable.png" style="width: 300px; height: 534px;" width="300" height="534"></img>  <img src="Resources/GanttChart.png" style="width: 534px; height: 300px;" width="534" height="300"></img>

Features

Find the above displayed examples in the Examples folder.

Requirements

SpreadsheetView is written in Swift 3. Compatible with iOS 8.0+

Installation

CocoaPods

SpreadsheetView is available through CocoaPods. To install it, simply add the following line to your Podfile:

pod 'SpreadsheetView'

Carthage

For Carthage, add the following to your Cartfile:

github "kishikawakatsumi/SpreadsheetView"

Getting Started

The minimum requirement is connecting a data source to return the number of columns/rows, and each column width/row height.

import UIKit
import SpreadsheetView

class ViewController: UIViewController, SpreadsheetViewDataSource {
    @IBOutlet weak var spreadsheetView: SpreadsheetView!

    override func viewDidLoad() {
        super.viewDidLoad()
        spreadsheetView.dataSource = self
    }

    func numberOfColumns(in spreadsheetView: SpreadsheetView) -> Int {
        return 200
    }

    func numberOfRows(in spreadsheetView: SpreadsheetView) -> Int {
        return 400
    }

    func spreadsheetView(_ spreadsheetView: SpreadsheetView, widthForColumn column: Int) -> CGFloat {
      return 80
    }

    func spreadsheetView(_ spreadsheetView: SpreadsheetView, heightForRow row: Int) -> CGFloat {
      return 40
    }
}

Usage

Freeze column and row headers

Freezing a column or row behaves as a fixed column/row header.

Column Header

func frozenColumns(in spreadsheetView: SpreadsheetView) -> Int {
    return 2
}

<img src="Resources/ColumnHeader.gif" style="width: 200px;" width="200"></img>

Row Header

func frozenRows(in spreadsheetView: SpreadsheetView) -> Int {
    return 2
}

<img src="Resources/RowHeader.gif" style="width: 200px;" width="200"></img>

both

func frozenColumns(in spreadsheetView: SpreadsheetView) -> Int {
    return 2
}

func frozenRows(in spreadsheetView: SpreadsheetView) -> Int {
    return 2
}

<img src="Resources/BothHeaders.gif" style="width: 200px;" width="200"></img>

Merge cells

Multiple cells can be merged and then they are treated as one cell. It is used for grouping cells.

func mergedCells(in spreadsheetView: SpreadsheetView) -> [CellRange] {
    return [CellRange(from: (row: 1, column: 1), to: (row: 3, column: 2)),
            CellRange(from: (row: 3, column: 3), to: (row: 8, column: 3)),
            CellRange(from: (row: 4, column: 0), to: (row: 7, column: 2)),
            CellRange(from: (row: 2, column: 4), to: (row: 5, column: 8)),
            CellRange(from: (row: 9, column: 0), to: (row: 10, column: 5)),
            CellRange(from: (row: 11, column: 2), to: (row: 12, column: 4))]
}

<img src="Resources/MergedCells.png" style="width: 200px;" width="200"></img>

Circular Scrolling

Your table acquires infinite scroll just set circularScrolling property.

Enable horizontal circular scrolling

spreadsheetView.circularScrolling = CircularScrolling.Configuration.horizontally

Enable vertical circular scrolling

spreadsheetView.circularScrolling = CircularScrolling.Configuration.vertically

Both

spreadsheetView.circularScrolling = CircularScrolling.Configuration.both

<img src="Resources/CircularScrolling.gif" style="width: 200px;" width="200"></img>

If circular scrolling is enabled, you can set additional parameters that the option not to repeat column/row header and to extend column/row header to the left/top edges. CircularScrolling.Configuration is a builder pattern, can easily select the appropriate combination by chaining properties.

e.g.

spreadsheetView.circularScrolling = 
    CircularScrolling.Configuration.horizontally.columnHeaderNotRepeated
spreadsheetView.circularScrolling = 
    CircularScrolling.Configuration.both.columnHeaderStartsFirstRow

Customize gridlines, borders and cell spacing

You can customize the appearance of grid lines and borders of the cell. You can specify whether a cell has a grid line or border. Grid lines and borders can be displayed on the left, right, top, or bottom, or around all four sides of the cell.

The difference between gridlines and borders is that the gridlines are drawn at the center of the inter-cell spacing, but the borders are drawn to fit around the cell.

Cell spacing

<img src="Resources/IntercellSpacing.png" style="width: 200px;" width="200"></img>

spreadsheetView.intercellSpacing = CGSize(width: 1, height: 1)

Gridlines

<img src="Resources/Grid.png" style="width: 200px;" width="200"></img>

SpreadsheetView's gridStyle property is applied to the entire table.

spreadsheetView.gridStyle = .solid(width: 1, color: .lightGray)

You can set different gridStyle for each cell and each side of the cell. If you set cell's gridStyle property to default, SpreadsheetView's gridStyle property will be applied. Specify none means the grid will not be drawn.

cell.gridlines.top = .solid(width: 1, color: .blue)
cell.gridlines.left = .solid(width: 1, color: .blue)
cell.gridlines.bottom = .none
cell.gridlines.right = .none

Border

<img src="Resources/Border.png" style="width: 200px;" width="200"></img>

You can set different borderStyle for each cell as well.

cell.borders.top = .solid(width: 1, color: .red)
cell.borders.left = .solid(width: 1, color: .red)
cell.borders.bottom = .solid(width: 1, color: .red)
cell.borders.right = .solid(width: 1, color: .red)

Author

Kishikawa Katsumi, kishikawakatsumi@mac.com

License

SpreadsheetView is available under the MIT license. See the LICENSE file for more info.