1. 用电量日分析

feiyu02

2021-12-02 74ffc8ebf3a25d2e3cee758954ce6efc163cb864

 src/main/kotlin/com/flightfeather/uav/common/utils/FileExchange.kt

@@ -4,6 +4,7 @@
import com.flightfeather.uav.domain.entity.RealTimeData
import com.flightfeather.uav.socket.bean.AirData
import org.apache.poi.hssf.usermodel.HSSFWorkbook
import org.apache.poi.xssf.streaming.SXSSFWorkbook
import java.io.File
import java.io.FileInputStream
import java.io.FileOutputStream
@@ -11,6 +12,9 @@
import java.text.SimpleDateFormat
import java.util.*

/**
 * 无人船采集数据格式转换
 */
class FileExchange {

    companion object {
@@ -150,7 +154,7 @@
        }


        val newWorkBook = HSSFWorkbook()
        val newWorkBook = SXSSFWorkbook(10000)
        ExcelUtil.write2(heads, contents, newWorkBook, "data")

        newWorkBook.write(out)
@@ -239,7 +243,7 @@
            contents.add(cList.toTypedArray())
        }

        val newWorkBook = HSSFWorkbook()
        val newWorkBook = SXSSFWorkbook(10000)
        ExcelUtil.write2(heads, contents, newWorkBook, "data")

        newWorkBook.write(out)