首页 > 解决方案 > 如何解析 CSV 文件,以便 tableView 可以轻松访问它?

问题描述

我编写了一个 CSV 文件,其中按行包含一组项目。我使用这样的类来形成 CSV 文件,这是创建文件的代码:

class SymptomData: NSObject {
var symptom: String = ""
var severity: String = ""
var comment: String = ""
var timestamp: String = ""
}

var symptom_data = [SymptomData]()
var symptomData: SymptomData!

func writeTrackedSymptomValues(symptom: String, comment: String, time: String, timestamp: String) {
    symptomData = SymptomData()
    for _ in 0..<5 {
        symptomData.symptom = symptom
        symptomData.severity = self.severity
        symptomData.comment = comment
        symptomData.timestamp = timestamp
        symptom_data.append(symptomData!)
    }

    createCSV()
}

    var logFile: URL? {
        guard let documentsDirectory = FileManager.default.urls(for: .documentDirectory, in: .userDomainMask).first else { return nil }
        let fileName = "symptom_data.csv"
        return documentsDirectory.appendingPathComponent(fileName)
    }

    func createCSV() {
        guard let logFile = logFile else {
            return
        }

        guard let data = ("\(symptomData.symptom),\(symptomData.severity),\(symptomData.comment),\(symptomData.timestamp)\n").data(using: String.Encoding.utf8) else { return }

        if FileManager.default.fileExists(atPath: logFile.path) {
            if let fileHandle = try? FileHandle(forWritingTo: logFile) {
                fileHandle.seekToEndOfFile()
                fileHandle.write(data)
                fileHandle.closeFile()
            }
        } else {
            var csvText = "Symptom,Severity,Comment,Time\n"


                 let newLine = "\(symptomData.symptom),\(symptomData.severity),\(symptomData.comment),\(symptomData.timestamp)\n"
                 csvText.append(newLine)


             do {
                try csvText.write(to: logFile, atomically: true, encoding: String.Encoding.utf8)

             } catch {
                 print("Failed to create file")
                 print("\(error)")
             }
             print(logFile ?? "not found")
        }
    }

CSV 文件如下所示:

CSV 文件

现在我想读取文件,并将每一行添加到我的表格视图中。理想情况下,我希望能够像这样轻松访问每一行:

row0.symptom = symptomData[0].symptom
row0.comment = symptomData[0].comment

等等,但我不知道如何将数据解析回我的班级,我也希望这样,这样我就可以按时间戳对它们重新排序。

到目前为止,这是我解析数据的方式:

func readCSV() {
    guard let logFile = logFile else {
        return
    }

    if FileManager.default.fileExists(atPath: logFile.path) {
        if let fileHandle = try? FileHandle(forWritingTo: logFile) {
            fileHandle.seekToEndOfFile()
            fileHandle.readDataToEndOfFile()
            fileHandle.closeFile()
            print("symptom_data exists")
            do {
                let file = try String(contentsOf: logFile)
                let rows = file.components(separatedBy: .newlines)
                for row in rows {
                    let fields = row.replacingOccurrences(of: "\"", with: "").components(separatedBy: ",")

                    print(fields)

                }
            } catch {
                print(error)
            }

        }
    } else {
         print("No symptom_data File.")
    }
}

这打印:

 ["Symptom", "Severity", "Comment", "Time"]
 ["Anxiety", "Severe", "test", "1592333677"]
 ["Anxiety", "Mild", "test2", "1592333686"]
 ["Fatigue", "Mild", "test3", "1592160840"]
 ["Electric shock sensations (Brain Zaps)", "Mild", "", "1592333820"]
 ["Anxiety", "Severe", "", "1592336985"]

如何将每一行放入一个类或结构中,以便我可以轻松地将其添加到表视图中,或者有更好的方法吗?

标签: swiftxcodecsvparsingswift5

解决方案


推荐阅读