f# - 使用 F# ExcelProvider 处理多行标题和隐藏列

Question

我正在尝试使用 Excel Provider 解析和 excel 文件，下面显示了一个示例。

type Data = {
     Time: string
     Pressure: string
     Force: string
     Appshear: string
     Stress: string
     Appvisc: string
     Shear: string
     Viscosity: string
     Position: string
     Temperature: string
     Velocity: string
     Fgamr: string
     M: string}

open FSharp.Interop.Excel
type TheFile = ExcelFile<"************.xls","Data",HasHeaders =false>
let file = TheFile()
let rows = file.Data 
       |> Seq.skip 3
       |> Seq.head

第一行包含如下所示的输出。

val rows : ExcelFile<...>.Row =
Row 3
    Column1 =
    Column10 = [Pa*s]
    Column11 = [mm]
    Column12 = [°C]
    Column13 = [°C]
    Column14 = [°C]
    Column15 = [mm/s]
    Column16 = [-]
    Column17 = [-]
    Column18 =
    Column19 =
    Column2 = [hh:mm:ss.00]
    Column20 =
    Column21 =
    Column22 =
    Column23 =
    Column24 =
    Column25 =
    Column26 =
    Column27 =
    Column28 =
    Column29 =
    Column3 = [bar]
    Column4 = [N]
    Column5 = [1/s]
    Column6 = [Pa]
    Column7 = [Pa*s]
    Column8 = [1/s]
    Column9 = [Pa]

如何获取这些行输出并将它们放入记录中以另存为 .csv？

标签： f#f#-data