Skip to main content

File.read

readformaton_problems

Group: Input
Aliases: load, open

Documentation​

Read a file using the specified file format

Arguments​

  • format: A File_Format object used to read file into memory. If Auto_Detect is specified; the provided file determines the specific type and configures it appropriately. If there is no matching type then a File_Error.Unsupported_Type error is returned.
  • on_problems: Specifies the behavior when a problem occurs during the function. By default, a warning is issued, but the operation proceeds. If set to Report_Error, the operation fails with a dataflow error. If set to Ignore, the operation proceeds without errors or warnings.

Examples​

Read the first sheet of an XLSX from disk and convert it into a table.​

      from Standard.Table import all
      import Standard.Examples

      example_xlsx_to_table = Examples.xlsx.read

Read the sheet named Dates from an XLS and convert it to a table.​

      from Standard.Table import all
      import Standard.Examples

      example_xls_to_table = Examples.xls.read (..Sheet 'Dates')