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