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

[Sunny1290]

How to write data into Excel sheet and if I want to enter a new data it should not replace the old data rather it should be at the top row and older data pushed down the row?

Also how to select a particular element of that Excel sheet and display it on the front panel?

[smercurio_fc]

To program Excel you have two options:

• Buy the Report Generation Toolkit.
• Program it yourself using ActiveX. There is an example that ships with LabVIEW that can get you started. You will need to know the ActiveX object model of Excel This is documented over at Microsoft. You can find lots of examples in this forum. Search. You can also find a user-made toolkit, as well as links to other examples in the Excel thread. NOTE: DO NOT POST QUESTIONS IN THE EXCEL THREAD!!!!

[nyc_(is_out_of_here)]

Reading from Excel worksheet is fairly straigthtforwrd. The included examples with LabVIEW show you how.

Generally people keep appending new data.

I would suggest that instead of pre-pending new data as you want to do.

[P@Anand]

Mostly pre-pending the data to any file directly is not possible (as far I know) what you have to do in that case is you need to read the entire data and keep it in memory and insert the data at the top and the write the whole data again to the same file overwriting the old content. This will be valid for files of smaller size if the file size grows bigger you may need to chunk the data and take only the portion where you want insert the data.

[smercurio_fc]

Of course, you could also take the easy approach, and simply deal with text files. Then you don't have to worry about ActiveX. Just use the Write to Spreadsheet File VI. It can create a delimited text file that you can import into Excel.

[nyc_(is_out_of_here)]

Yes, but that won't help him with his wanting to pre-pend data.

[ben64]

Using ActiveX you can use the Insert method of the Range object to insert a row type range you defined at row 1 of the worksheet. The method has a shift argument that you can set to xlShiftDown (-4121) to push the other rows down.

Ben64

[smercurio_fc]

---

@nyc_(is_out_of_here) wrote:

Yes, but that won't help him with his wanting to pre-pend data.

---

Why not? Read the file. Prepend your string. Write out the new string to the file.

[nyc_(is_out_of_here)]

---

@smercurio_fc wrote:

---

@nyc_(is_out_of_here) wrote:

Yes, but that won't help him with his wanting to pre-pend data.

---

Why not? Read the file. Prepend your string. Write out the new string to the file.

---

I know that, but I was referring to his unspoken expectation that he can just write data and have it automatically be pre-pended.

[smercurio_fc]

Ah, well, sometimes we can't cure someone's expectations on how the universe works (without checking first) vs how it actually does.