TXlsFile.NewFile Method

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.XlsAdapter

procedure TXlsFile.NewFile(const aSheetCount: Integer; const fileFormat: TExcelFileFormat); overload; override;

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