This can be useful in cases where the dimensions metadata is incorrect. InferSheetDimensions: Can be null or a logical (true/false) value indicating whether the area of a worksheet that contains data should be inferred by reading the worksheet itself, rather than by reading the dimensions metadata from the file.DelayTypes: Can be null or a logical (true/false) value indicating whether the columns of each returned table should be left untyped.UseHeaders: Can be null or a logical (true/false) value indicating whether the first row of each returned table should be treated as a header.If a record is specified for useHeaders (and delayTypes is null), the following record fields may be provided: delayTypes can be null or a logical (true/false) value indicating whether the columns of each returned table should be left untyped. useHeaders can be null, a logical (true/false) value indicating whether the first row of each returned table should be treated as a header, or an options record.Returns the contents of the Excel workbook. Excel.Workbook( workbook as binary, optional useHeaders as any, optional delayTypes as nullable logical) as table
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |