following the tutorial "Exporting context data into Excel using the WD binary cache" I've added an export function to my wd app for a table's contents.
In the Excel document I'd like to treat all as text, avoiding e.g. the null values written, the ...E+17, deletion of leading zeroes and so on.
Can you help me please?
If your client's Excel application supports XML format (starting from Office XP, AFAIK) you may produce output in Excel XML rather then CSV(comma separated values) while former allows formatting.
You may get details about MS Office specific XML schemas here http://www.microsoft.com/office/xml/default.mspx .
Next, if this format is useful for you, you may use code posted here () to convert context node data to XML. You may either supply XSL template to transform generic XML into Excel-specific XML (better option) or modify original code to produce Excel XML directly.