LoginSignup
9
20

More than 3 years have passed since last update.

Android, Kotlin: CSVの読み書き

Last updated at Posted at 2020-09-10
  • Minimum SDK: API 23
  • Android Studio 4.0.1
  • Kotlin 1.4.0
  • opencsv Version: 5.2

Android, KotlinでCSVの読み書きを、opencsvを使って実装します。
CSVの操作を説明するために、StringReader, StringWriterを使って実装していますので、必要に応じてFileReader, FileWriter, InputStreamReader, OutputStreamWriterに置き換えて実装してください。

SDカードへのファイル読み書きはこちらを参照ください。→ Android: SDカード上のファイルへの読み書き

準備

opencsvライブラリ取り込み

build.gradle(app)
dependencies {
    implementation 'com.opencsv:opencsv:5.2'
}

配列を使った方法

書き込み

実装
        val strWriter = StringWriter()
        val csvWriter = CSVWriter(strWriter)
        csvWriter.writeNext(arrayOf("三幸太郎", "45", "男"))
        csvWriter.writeNext(arrayOf("三幸次郎", "44", "男"))
        csvWriter.writeNext(arrayOf("三幸花子", "35", "女"))
        println(strWriter.toString())
出力
"三幸太郎","45","男"
"三幸次郎","44","男"
"三幸花子","35","女"

読み込み

読み込み元は、先ほど作成したCSVテキスト(strWriter)

実装
        val strReader = StringReader(strWriter.toString())
        val csvIter = CSVIterator(CSVReader(strReader))
        for (row in csvIter) {
            for (col in row) {
                print(col)
            }
        }

オブジェクト(Bean)を使った方法

データ定義

初期値はいるみたいです。

CSVヘッダー無し
data class User(
    @CsvBindByPosition(position = 0)
    val name: String = "",

    @CsvBindByPosition(position = 1)
    val age: Int = 0,

    @CsvBindByPosition(position = 2)
    val gender: String = ""
)
CSVヘッダーあり
data class User(
    @CsvBindByName(column = "名前", required = true)
    val name: String = "",

    @CsvBindByName(column = "年齢", required = true)
    val age: Int = 0,

    @CsvBindByName(column = "性別", required = true)
    val gender: String = ""
)

書き込み

実装
        val strWriter = StringWriter()
        val beanWriter = StatefulBeanToCsvBuilder<User>(strWriter).build()
        beanWriter.write(User("三幸太郎", 45, "男"))
        beanWriter.write(User("三幸次郎", 44, "男"))
        beanWriter.write(User("三幸花子", 35, "女"))
        println(strWriter.toString())
出力(ヘッダー無し)
"三幸太郎","45","男"
"三幸次郎","44","男"
"三幸花子","35","女"
出力(ヘッダーあり)
"名前","年齢","性別"
"三幸太郎","45","男"
"三幸次郎","44","男"
"三幸花子","35","女"

読み込み

読み込み元は、先ほど作成したCSVテキスト(strWriter)

実装
        val strReader = StringReader(strWriter.toString())
        val beanList = CsvToBeanBuilder<User>(strReader)
            .withType(User::class.java)
            .withIgnoreLeadingWhiteSpace(true)
            .build()
            .parse()
        for (user in beanList) {
            println(String.format("%s, %d, %s", user.name, user.age, user.gender))
        }
9
20
1

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
9
20