Pascal (Lazarus/Delphi)

Read CSV File

See more CSV Examples

Demonstrates how to read a .csv file and access the contents.

The Chilkat CSV library/component/class is freeware. The downloads for .NET, C++, Perl, Java, Ruby, and Python contain all of the Chilkat classes, some of which are freeware and some of which require licensing.

Pascal (Lazarus/Delphi)

program ChilkatDemo;

// Demonstrates using the Chilkat Pascal wrapper via the C bridge DLL.
// Builds as a console application under Lazarus (FPC) or Delphi.

{$IFDEF FPC}
  {$MODE DELPHI}
{$ENDIF}
{$APPTYPE CONSOLE}

uses
  {$IFDEF UNIX}
  cthreads,
  {$ENDIF}
  SysUtils,
  CkDllLoader,
  Chilkat.Csv;

// ---------------------------------------------------------------------------

procedure RunDemo;
var
  success: Boolean;
  csv: TCsv;
  row: Integer;
  n: Integer;

begin
  success := False;

  //  This example program loads a file (sample.csv)
  //  that contains this content:
  //  
  //  year,color,country,food
  //  2001,red,France,cheese
  //  2005,blue,"United States",hamburger
  //  2008,green,Italy,pasta
  //  1998,orange,Japan,sushi
  //  
  //  The first row contains the column names.
  //  This file is available at:
  //  http://www.chilkatsoft.com/testData/sample.csv

  csv := TCsv.Create;

  //  Prior to loading the CSV file, indicate that the 1st row
  //  should be treated as column names:
  csv.HasColumnNames := True;

  //  Load the CSV records from the file:

  success := csv.LoadFile('sample.csv');
  if (success <> True) then
    begin
      WriteLn(csv.LastErrorText);
      Exit;
    end;

  //  Display the contents of the 3rd column (i.e. the country names)

  n := csv.NumRows;
  for row := 0 to n - 1 do
    begin
      WriteLn(csv.GetCell(row,2));
    end;



  csv.Free;

end;

// ---------------------------------------------------------------------------

begin

  try
    RunDemo;
  except
    on E: Exception do
      WriteLn('Unhandled exception: ', E.ClassName, ': ', E.Message);
  end;

  WriteLn;
  {$IFDEF MSWINDOWS}
  WriteLn('Press Enter to exit...');
  ReadLn;
  {$ENDIF}
end.