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 there:
<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

n,

HTML does not preserve runs of spaces - they will be compressed to a
single space even if they appear in the source.

Try replacing your spaces with "&nbsp;"

Tim.


"-nk-" <[email protected]> wrote in message
news:[email protected]...
> 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 there:
> <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
>