Skip to content
Demo Swift Excel Xlsx Reader Writer
Branch: swift-4-xcode-9
Clone or download
Latest commit a629c84 Nov 9, 2017
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
Demo Swift Excel Xlsx Reader Writer
doc/setup
src Fix typo Nov 9, 2017
.gitignore Upgrade for Swift 3 Xcode 8 Sep 25, 2017
README.md Fix typo Nov 9, 2017
README.png Add art Aug 11, 2016
demo.xlsx

README.md

Demo Swift Excel Xlsx Reader Writer

Excel

This demonstration shows:

Example code to load a spreadsheet and print a cell value:

let spreadsheet: BRAOfficeDocumentPackage = BRAOfficeDocumentPackage.open(path)
let worksheet: BRAWorksheet = spreadsheet.workbook.worksheets[0] as! BRAWorksheet
let cell: BRACell = worksheet.cellForCellReference("A1")
print(cell.stringValue())

Start

To use this demo, you can clone this repo, or you can use this README to create your own project.

If you clone this repo, then be aware that there are multiple git branches, so pick the one you want.

  • swift-4-xcode-9: Swift version 4, Xcode version 9, iOS version 11.

  • swift-3-xcode-8: Swift version 3, Xcode version 8, iOS version 10.

Create the project

Launch Xcode and create a new Xcode project.

  • Use iOS template "Single View Application" and Product Name "Demo Swift Excel Xlsx Reader Writer".

  • Help

Get XlsxReaderWriter

Get the repository, and put it in the the same folder as our demo project's xcodeproject:

git clone --depth=1 https://github.com/renebigot/XlsxReaderWriter.git

If you want to confirm you put in the in the expected place, do the command ls:

Demo Swift Excel Xlsx Reader Writer
Demo Swift Excel Xlsx Reader Writer.xcodeproj
Demo Swift Excel Xlsx Reader WriterTests
Demo Swift Excel Xlsx Reader WriterUITests
XlsxReaderWriter

Link

Add the file XlsxReaderWriter.xcodeproj to the project, within the

Add dependency:

  • Choose: Targets → Demo Swift Excel Xlsx Reader Writer
  • → Build Phases → Target Dependencies
  • Add: XslxReaderWriterXslxReaderWriter

Link binaries:

  • Choose: Targets → Demo Swift Excel XlsxReaderWriter
  • → Build Phases → Link Binaries With Libraries
  • Add: libXlsxReaderWriter.a (which is in the XlsxReaderWriter folder)
  • Add libz.tbd (which is in the standard list of Apple items). The libz.tbd is more current than the older version named libz.dylib.

Linking:

  • Choose: Targets → Demo Swift Excel Xlsx Reader Writer
  • → Build Settings → All → Linking → Other Linker Flags
  • → Debug → (+) → Any Architecture | Any SDK
  • Add: -all_load
  • → Release → (+) → Any Architecture | Any SDK
  • Add: -all_load

Search Paths:

  • Project → Demo → Build Settings → Search Paths → User Header Search Paths
  • → Debug → (+) → Any Architecture
  • Set it to: $(SRCROOT)/XlsxReaderWriter/ not $(SRCROOT)/XlsxReaderWriter/XlsxReaderWriter/.
  • Select "recursive".
  • → Release) → (+) → Any Architecture
  • Set it to: $(SRCROOT)/XlsxReaderWriter/ not $(SRCROOT)/XlsxReaderWriter/XlsxReaderWriter/.
  • Select "recursive".

Bridging Header:

  • Create a new file to Xcode (File > New > File), then see the “Source” section, and click “Header File“. If an icon for "Header File" doesn't appear, then use the search box and type "Header".

  • We like the file name Bridge.h

  • Add this code:

    #ifndef Demo_Swift_Excel_Xlsx_Reader_Writer_Bridging_Header_h
    #define Demo_Swift_Excel_Xlsx_Reader_Writer_Bridging_Header_h
    #import "XlsxReaderWriter-swift-bridge.h"
    #endif /* Demo_Swift_Excel_Xlsx_Reader_Writer_Bridging_Header_h */

Add the bridge:

  • Project → Demo → Build Settings → Swift Compiler - General → Objective-C Bridging Header
  • → (Debug & Release) → (+) → Any Architecture | Any SDK → Add: Bridge.h

Run

Run the project to verify it works so far.

It should compile then launch the simulator.

Troubleshooting

Build error "'XlsxReaderWriter-swift-bridge.h' file not found":

  • Ensure that you've created the search paths as described above, and that they are both recursive.

Load an Excel file

This demo repository has an Excel file demo.xlsx.

  • You can use this file as is. The cell A1 has the word "Alpha".

  • Or you can create your own file by using your own Excel software, or any Excel-compatible software.

Add the file to the project.

Write the code

Edit ViewController.swift:

import UIKit

class ViewController: UIViewController {

  override func viewDidLoad() {
    super.viewDidLoad()

    // Set the path to the path of wherever you put your Excel file.
    // The path in this demo code is the path to the demo.xlsx file.
    let path: String = Bundle.main.path(forResource: "demo", ofType: "xlsx")!


    // Open the spreadsheet, get the first sheet, first worksheet, and first cell A1.
    // This is solely demo code to show basics; your actual code would do much more here.
    let spreadsheet: BRAOfficeDocumentPackage = BRAOfficeDocumentPackage.open(path)
    let sheet: BRASheet = spreadsheet.workbook.sheets[0] as! BRASheet
    let worksheet: BRAWorksheet = spreadsheet.workbook.worksheets[0] as! BRAWorksheet
    let cell: BRACell = worksheet.cell(forCellReference: "A1")

    // Print some info to show the code works.
    print(sheet.name) // print "Sheet1"
    print(cell.stringValue()) // print "Alpha"
  }

  override func didReceiveMemoryWarning() {
    super.didReceiveMemoryWarning()
  }

}

Run

Run the project.

  • It should compile and launch a blank simulator.

  • The Xcode console should now show the text "Sheet1" and "Alpha".

Congratulations, you're successful!

Troubleshooting

If this line fails at runtime:

let path: String = Bundle.main.path(forResource: "demo", ofType: "xlsx")!

Then the app is unable to find the file demo.xlsx.

Verify that the file is at the top level of the project.

Tracking

  • Package: demo_swift_excel_xlsx_reader_writer
  • Version: 3.0.0
  • Created: 2016-07-02
  • Updated: 2017-09-22
  • License: BSD, GPL, MIT
  • Contact: Joel Parker Henderson (joel@joelparkerhenderson.com)
You can’t perform that action at this time.