Hi, glad you view this problem...hope you can help me..
I got a weird problem..
I use GridView to generate a EXCEL file, and of course it's actually generated to HTML and opened by EXCEL...so Excel can automatically tell from the format.
Okay, my question is ...In my HTML(GridView), I have a field , and the value includes three space , such as "A BCDE", there are three spaces between A and B. Well, the HTML surely displays it a single space. But when I export it to EXCEL file, it still a single space not three... Althrough I try to replace the space to " "...it doesn't work , even worse there is no space show....
oh, if i put <pre> tag to wrap it...well, the EXCEL will merge two columns to one colmn...and become weird...why??
how can i solve the problem, to display correct "A BCDE" in the EXCEL????
Please,,somebody help me from Taiwan.< ...
Go to the complete details ...