Pascal (Lazarus/Delphi)

Write utf-8 CSV Compatible with Excel

See more CSV Examples

A CSV containing non-English characters that is saved using the utf-8 character encoding must include a BOM (also known as a preamble) if it is to be correctly loaded into Excel. See https://en.wikipedia.org/wiki/Byte_order_mark

This example shows how to save the CSV to a file using utf-8 with a BOM.

Note: This example requires Chilkat v9.5.0.93 or later.

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;

begin
  success := False;

  //  This example program loads a file (japanese.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
  //  2010,silver,"太志","森田"
  //  

  csv := TCsv.Create;
  csv.HasColumnNames := True;
  success := csv.LoadFile2('qa_data/csv/test.csv','utf-8');
  if (success <> True) then
    begin
      WriteLn(csv.LastErrorText);
      Exit;
    end;

  //  To save the CSV using utf-8 with a BOM/preamble, 
  //  add "EMIT_BOM" to the UncommonOptions.
  //  (This feature was added in Chilkat v9.5.0.93)

  csv.UncommonOptions := 'EMIT_BOM';
  success := csv.SaveFile2('qa_output/test.csv','utf-8');
  if (success <> True) then
    begin
      WriteLn(csv.LastErrorText);
      Exit;
    end;

  WriteLn('OK, try to load the CSV in Excel to see if the non-English chars are correct.');


  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.