View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
-nk- -nk- is offline
external usenet poster
 
Posts: 1
Default dataset to exel issue

Hi,
I am transforming a dataset to excel by converting the dataset xml to
html (using xslt) and then opening the html file using the Excel objects and
saving th file. The problem I am having is that data fromthe dataset that
contains multiple spaces (whitespace) in the text is getting truncated to a
single space in the excel file. I looked at the intermediate html file and
the space exists the
<TD border="1" valign="top" xml:space="preserve"
<font size="1"
Respondent 1
</font
Bur when I open the excel file it reduces the multiple spaces to a single
space between the word Respondent and 1. I need to preserve the wihtespace in
the excel file. Any help would be appreciated. Thanks.

nk