problems writing to an Excel file.

[Harry King]

I've got a VI which I use to control a CVD furnace. I take readings every
so often, and accompany my readings (temperature, gas flow, power, etc)
with date and time. For some reason, when I import my file into a
spreadsheet, I get a box in front of everything except for my date. As a
result, Excel doesn't recognize the numbers as numbers.

Background: I have a bundle with all of my data (except my time and date
command) going into a "to fractional" command. Then, I build an array,
then send that array to an "array to spreadsheet string" which goes to a
"write characters to file.vi"

The only problem I have is those little boxes. Any ideas?

Harry


--
"Little Joe for the Big Heisman, '99"

[Greg_McKaskle2]

> ... I get a box in front of everything except for my date. As a
> result, Excel doesn't recognize the numbers as numbers.
>
> Background: I have a bundle with all of my data (except my time and date
> command) going into a "to fractional" command. Then, I build an array,
> then send that array to an "array to spreadsheet string" which goes to a
> "write characters to file.vi"
>
> The only problem I have is those little boxes. Any ideas?

The boxes usually indicate that a nonprintable character
exists. Select some of the text and paste it in a new
string control. Set the string control to show backslash
characters or hex. Determine what the nonprintable is, then
you can either filter it out, or determine how it is being
inserted.

Greg McKaskle