cannot save numeric to excel

[davidha]

Using 'Append Table to Report.vi' to save numeric data to excel does NOT save it as NUMERIC data in excel
and I cannot use what appears in the spreadsheet to do any calculations or graphs later in excel - can
anybody help please - thanks Davidha Labview 6.1 Excel 97

[Joe_H]

Well one thing you can do but i'm not sure how much help it will be to you since you are using a report and excel I have never done that before, but you can right click on the append table to report vi and select visible items then select the show polymorphic selector and change it to numeric and see if this does what you want.what I would do is if you really want this in excel is to use write to spreadsheet file. If you open this vi from the file i/o pallette it will show you how to convert it to take in strings. there are many different ways to do this. Let me know what your end goals are and i will try to help you.

[davidha]

Thanks for your reply Joe.
I tried what you suggested but didn't get anywhere. I modified the 'Append numeric table to report.vi' and the
'Excel insert table.vi' and now I can use the data in excel. The origional vi's internally convert everything to strings that excel can't use (dont't know why they do this). Attached is an example from the NI site that doesn't work called
'Data Appended in Excel.vi'and my modified vi that does work called 'Write_2D_numeric_array_to_Excel.vi'.

Maybe you know why the NI vi's don't work,

many thanks,

Dave.

[Donald]

"Maybe you know why the NI vi's don't work"

Dave,

In your regional options for Windows, are you using a , (i.e. a comma) for the decimal symbol?

The NI examples and VIs as received work have worked for me (LV6.1, Excel 2000 now, Excel 97 before), but only when the decimal symbol is a point. When using a comma, they fail because the highlighted code in "Append Numeric Table to Report" shown in the attached jpg replaces all commas with points which unhappily makes Excel think it's text. Cutting the offending code out makes things work, which is just a different edit than what you probably did.

[davidha]

Donald,

thanks for your reply. My regional settings are a point for decimal and comma for number grouping but it still does not work, I also tried swapping the decimal point and the comma in the vi but this didn't work either! I'll have to keep trying!

Dave.

[Joe_H]

If you are just wanting to write your table to excel then i have a vi for you to try. I myself do not have any trouble converting numeric to string and then using in excel.try it and see what you think, this does not use the report generation toolkit.

hope this helps

[Donald]

Joe,

You'll have to backsave it to LV6.1 for people like Dave and me who aren't quite leading edge.

Donald

[Joe_H]

sorry here you go

[Joe_H]

you can also open up the cell value VI and save it as a different name and change it to accept in numeric directly.Just a thought

[davidha]

Many thanks to all - I think I have enough to go on now,

Dave.