Read integer values from spreadsheet and display the values in a table

[avinash3010]

Hi all,

I have integer values to read from a spreadsheet and display them in a table. I am using 'Read from spreadsheet file' in 'integer' mode. I would like to display these values in a table. The problem is that the table takes only 2d-array of string as input but not integer.  

It works fine if I change the mode of 'Read from spreadsheet file' from 'integer' to 'string' but I want to read integers and have to use the integer values for further calculations. Please give any suggestions on displaying integers to a table.

Thank you. 

[P@Anand]

You do the same thing but in the display part convert that into string and display them but for the other numeric operation you can take the values from the numeric that you are reading from the spreadsheet.

[avinash3010]

Hi Anand,

I tried converting each element into a string by using index array and build it back into an array of string but it failed to dsplay.

Thank you.

[TiTou]

Can you post your VI that fails?

[P@Anand · Accepted solution]

No don't take element by element just convert as a whole. See the attached example

Good luck

[avinash3010]

Thank you Anand...it is working..

but it is displaying the decimal places with zerors. any suggestion to remove this?

[P@Anand]

Then use Numeric to Decimal String function.

[avinash3010]

Thank you very much.

[avinash3010]

Hi TiTou

Sorry for not posting the VI. I got the solution before I could post. Thank you verymuch for replying.

[TiTou]

No worries, glad to see you've got a solution 🙂