Forum Discussion

Moniek's avatar
Moniek
Icon for Resolver I rankResolver I
3 years ago
Solved

Import csv

Hi, I import multiple excel files, for row header I added the function: "each Excel.Workbook([Content], true", now I want to import CSV files, does anyone knows what the "true" is in Csv.document? T...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, Moniek 

    Unlike function used to access excel data, function used to return the contents of a CSV document does not contain nullable logical (true/false) values in options.

     

    Excel.Workbook(workbook as binary, optional useHeaders as any, optional delayTypes as nullable logical) as table
    Csv.Document(source as any, optional columns as any, optional delimiter as any, optional extraValues as nullable number, optional encoding as nullable number) as table

     

    Please refer to official document about Power Query M formula language for more detail.

    Csv.Document 

    Excel.Workbook 

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Moniek 

Unlike function used to access excel data, function used to return the contents of a CSV document does not contain nullable logical (true/false) values in options.

 

Excel.Workbook(workbook as binary, optional useHeaders as any, optional delayTypes as nullable logical) as table
Csv.Document(source as any, optional columns as any, optional delimiter as any, optional extraValues as nullable number, optional encoding as nullable number) as table

 

Please refer to official document about Power Query M formula language for more detail.

Csv.Document 

Excel.Workbook 

 

Best Regards,
Community Support Team _ Eason