TExcelFile.NewFile Method

Overloads

TExcelFile.NewFile

Creates a new empty file, with 3 empty sheets.

Remarks

The file created will have empty properties, (author, description, etc). If you want to create a more personalized file when you call NewFile (for example with a given Author, or the sheets names on your language), there are 2 options:

  1. Don't use NewFile, but open an existing file you can modify.
  2. Or, you can replace the file "EmptyWorkbook.xls" (on xlsadapter folder) with your own and recompile.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.NewFile; overload;

See also

TExcelFile.NewFile(Integer)

Creates a new empty file, with the specified number of sheets.

Remarks

The file created will have empty properties, (author, description, etc). If you want to create a more personalized file when you call NewFile (for example with a given Author, or the sheets names on your language), there are 2 options:

  1. Don't use NewFile, but open an existing file you can modify.
  2. Or, you can replace the files "EmptyWorkbook.xls", "EmptyWorkbook2007.xls" and "EmptyWorkbook2010.xls" (on xlsadapter folder) with your own and recompile.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.NewFile(const aSheetCount: Integer); overload;

Parameters

<-> Parameter Type Description
const aSheetCount Integer Number of sheets for the new file.

See also

TExcelFile.NewFile(Integer, TExcelFileFormat)

Creates a new empty file, with the specified number of sheets.

Remarks

The file created will have empty properties, (author, description, etc). If you want to create a more personalized file when you call NewFile (for example with a given Author, or the sheets names on your language), there are 2 options:

  1. Don't use NewFile, but open an existing file you can modify.
  2. Or, you can replace the files "EmptyWorkbook.xls", "EmptyWorkbook2007.xls" and "EmptyWorkbook2010.xls" (on xlsadapter folder) with your own and recompile.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.NewFile(const aSheetCount: Integer; const fileFormat: TExcelFileFormat); overload; virtual; abstract;

Parameters

<-> Parameter Type Description
const aSheetCount Integer Number of sheets for the new file.
const fileFormat TExcelFileFormat Different Excel versions save different empty files. By default, FlexCel will create a new file that looks like a file created by Excel 2003, but you can change the version of the new file created with this parameter.

See also