Forum Discussion
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? Thanks!
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 tableCsv.Document(source as any, optional columns as any, optional delimiter as any, optional extraValues as nullable number, optional encoding as nullable number) as tablePlease refer to official document about Power Query M formula language for more detail.
Best Regards,
Community Support Team _ Eason
1 Reply
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 tableCsv.Document(source as any, optional columns as any, optional delimiter as any, optional extraValues as nullable number, optional encoding as nullable number) as tablePlease refer to official document about Power Query M formula language for more detail.
Best Regards,
Community Support Team _ Eason