Firemonkey TMS Grid Export and Import filters
ContentsIndexHome
PreviousUpNext
FMX.TMSGridExcelExport.TExportDataType Enumeration

Defines how a cell will be exported to Excel.

Pascal
TExportDataType = (
  Value,
  Text,
  Html,
  Formula
);

FMX.TMSGridExcelExport

Members 
Description 
Value 
The cell will be converted to what it represents. For example, the string "1/1/2000" will be entered as a date.  
Text 
Whatever you have in the grid, will be exported as a string to Excel. Numeric format will be preserved, but the Excel cells will contain strings, never numbers. Those strings can't be used in formulas, for example the sum of a range containing strings with numbers will always be 0.  
Html 
The cell contains HTML formatted text, and will be entered in Excel as rich text.  
Formula 
The cell contains a formula.  
Copyright (c) 2002-2013 TMS Software. All rights reserved.
What do you think about this topic? Send feedback!