HotXLS-dokumentasjon
Innhold
Hjem
Oversikt
TGridToXLS
IXLSWorkbook
Hjem
Innhold
Oversikt
NumberFormat egenskap
Returnerer or sets the format code for the range. Read/write WideString
Syntaks
property NumberFormat: WideString;
Eksempel
These examples set the number format for cell A10, row one, and column C (respectively) on sheet one
Workbook.Worksheets[1].Range['A10', 'A10'].NumberFormat := '#,##0.00';
Workbook.Worksheets[1].Range['A1', 'A1'].EntireRow.NumberFormat := 'hh:mm:ss';
Workbook.Worksheets[1].Range['C1', 'C1'].EntireColumn.NumberFormat := '$#,##0.00_);[Red]($#,##0.00)';
Copyright © 2010-2026 losLab Software