That way, it has to assume "text" for all fields you can just add a dummy record into the XML file which sets all fields to some dummy text. (There is a way of tricking Excel into processing all data as text, but I'd rather not have to resort to that.
Via the Developer ribbon (then "Source")?Īnd is there a simple schema that doesn't have to mirror the XML data structure, but just says "all fields are text fields"? Is there any other simple way of telling Excel to process all data as text? Maybe I'm going to have to get the XML schema thing working after all? If so, will Excel read a linked schema, or do you have to load the schema "map" into Excel first
Only then is it dumped into the sheet, as text "79" rather than as a number 79, if that's what the destination format is set to.īut the leading zeroes are long gone before it gets to the sheet. So, for example, "0000079" is processed as a number, to become 79. before Excel knows what the destination cell type is). would have been nice and simple!īut the problem is that the determination of data type appears to happen before the data is actually dumped into the Excel sheet (i.e.