I have created a little script that creates an XML file for the user. However, the XML file created will always have an exponent in one of the elements. In order to present this, I wrote:
That is accepted and runs smoothly when opened in Excel, except for the fact that the output is:
" . . . . . . . . . . . . . . . ΔP (kgf/cm . . . . . . . 2 . . . . . . . ) " [periods placed to display extra white spaces which are otherwise truncated in this forum]
This problem also repeats itself in the case of
Where the output is:
" . . . . . . . . . . . . ΔP (kPa) . . . . . . . . . . "
Other elements, containing no child-elements under <Data> have no such spacing problems. It's also worth mentioning that I built the script by creating a template on Excel and then saving it as an .xml instead of as an .xls
Bookmarks