Commands Text and Num. Specify the data type
for XLS files.
These commands are to specify Excel the data
type of the text that is being exported. These commands are rarely necessary
because all the information that is exported to XLS from RPV is “general”. This
means that Excel will define what data type is each portion of the exported
file. Example:
{$1;text} 0012345678 {$2} 0012345678
On this example, a number is exported as a
text. Excel will understand that, even when it will warn about the possible
mistake.
Commands Num and Text must be specified every
time a field is exported. For the example that is shown above, numbers exported
on column $2 will not be treated as text but as general.
|