How to enter numeric values into excel sheet and how to select a particular element from excel sheet?

[Sunny1290]

And the values of both should be entered in the same workbook.

[smercurio_fc]

---

@Sunny1290 wrote:

Hello Sir,

I have attached a VI can you please tell me if I have done it correctly?

And, Now is there any way to check if the submit button is pressed so it generates 1 in excel at position Row 0 column 0?

---

You simply refuse to listen to what people are telling you. You asked about how to prepend a row into Excel. You're told how to do it. You do it in the completely wrong order. Then you create a VI that for some reason uses Get Last Row and then appends to the table.

I give up.

[Sunny1290]

First I had thought of prepending the data but I created a VI in which the data is appending, so, it is good enough for me.

What I asked is how to enter data at a particular row and column? What function can I use? can you show me an example?

[Sunny1290]

When I enter values such as 0.00002 or 0.0005 in the numeric control it displays as 0 in the excel file.

How can I display 0.00002 as 0.00002  and 0.0005 as 0.0005 in Excel file rather than 0.00000?

[nyc_(is_out_of_here)]

You either are (1) writing 0.0005 to Excel and you really aren't or (2) the formatting of the cell in Excel isn't set up to display the number properly.

Hard to tell from here.

[Sunny1290]

You either are (1) writing 0.0005 to Excel and you really aren't 

I am writing 0.0005 in the excel sheet.

or (2) the formatting of the cell in Excel isn't set up to display the number properly.

I have also done the formatting of the cell upto 6 decimal places.

Still when I enter 0.0005 what I get in excel is 0.0000.

[Sunny1290]

Finally I have cleared all the doubts (some by myself and many by the forum).Now I realize that in the beginning I was asking very silly and small doubts.

So sorry for irritating some of the guys in this thread as well as the other threads.Actually I was a newbie that time so thought of instead studying the Core 1 and 2 I would just ask the doubts(was loooking for a shortcut.)

In the end I realized that self study is the best and you guys here are doing a good job by emphasizing on that very fact.

Thank you so much for guiding me through it and now I am looking forward to work more on LabVIEW and give you guys some more trouble .

Thank You guys.

P.S - Thank you Smercurio_FC( You handle people in your own way ).