Array(Non Displayable)

[ander99]

Hi,

I'm currently having problem to display the output with the error array(non displayable). Below are the files attached.

[JK1]

Hai,

Kindly Post with some more details on what you are trying to do.  The information is inadequate.

[ander99]

Sorry for that. Currently i want to read data from excel but encounter a error msg array non displayable after the 2nd Variant to Data.

[ander99]

I read through this forum regarding array non displayable. My current excel file display with Exponenatial value. will it because of that result in array non displayable. Anyone can help? i will be gladful.

[JK1]

Hai,

Can you post two missing vi's so that i can try to run the vi and see if i can replicate the same error.  Instead of type casting the variant to string array try with some other datatypes.

[ander99]

Hi JK

Sorry that i forget to add in the subVI. As below is the library file. Really thank for your help.

[JK1]

Hai,

This is pretty strange because i copied the same data to a different excel sheet and saved the sheet in the same name and your vi works fine for that excel file, but when i provide this file name am getting empty output.

"Value -> Array(Non Displayable)" is not an error it even comes for all the excel sheets for which am getting proper output.

Just copy the values to another file and run the vi it works fine.

[ander99]

Thank JK. I tried that before Think that the only way to use my vi. Or i do not know any other way

[vernyew.lim]

Hi ander99,

I think your problem might be that the file you originally posted was named Book1..xls (note that there are TWO dots in the file name) which might explain why if you copy the data and paste it in another file of the same name it works. Try renaming your file so that it only has ONE dot and try again.

Message Edited by vernyew.lim on 03-18-2009 08:34 PM

[ander99]

Hi Vern Yew,

I tried that also. Anyway is ok. I just copy my data to a new excel. I think is the security problem on the excel file that why unable to read or write to the file.