writing data to excel using activeX

[boodmiester]

Hey, 

I am new at this labview stuff. I have been looking at various examples and I got this vi and modified to my own need. 

It would retrieve the data generated and transfer them to excel, but I have a tiny problem with this vi. I really need the vi to place the each value that was retrive into appropriate cells (like a delimiter). So far its retrieving the data and putting all of them into cell A1. can some one help me please??

So if I retrieve a data like this:  "LabVIEW:Aninputparameterisinvalid."

then I want to read them in excel like so,  "LabVIEW" in cell A1,    "An" in Cell A2,    "input" in cell A3,    "parameter" for Cell A4, and so on. 

[MoReese]

Your receive string example is not delimited.  I am assuming there are delimiters in the string.  Do you have the Report Generation Toolkit.  It's not as flexible, but it is easier to use than Active X; especially if your starting out and it will do what you need.

[boodmiester]

I used the excel Easy Table once, but the reason that I am using activeX is that the toolkit is too generic, has too much parameters, and I can modified a VI to as detail as I want using activeX. Correct me if i am wrong, but does the report generation toolkit allow users to open an existing excel file, choose a specific worksheet, and choose a specific cell to writte on? if it does, could you show me? 

Thanks

[MoReese]

---

@boodmiester wrote:

I used the excel Easy Table once, but the reason that I am using activeX is that the toolkit is too generic, has too much parameters, and I can modified a VI to as detail as I want using activeX. Correct me if i am wrong, but does the report generation toolkit allow users to open an existing excel file, choose a specific worksheet, and choose a specific cell to writte on? if it does, could you show me? 

Thanks

---

Yes, it does.  They are located under the Excel General pallete for pointing to a specific sheet or workbook.  You can use the Excel Easy text to write to a specific cell.  I should note that the RGT uses Active X controls internally to do the same thing you are trying to do.  Open them up and have a look.

[boodmiester]

So I have made this VI according to your suggestion and so far its working well except for the delimiter. I am glad that the "end of line" constant works well cause thats one less problem that I have to worry about. but do you have any suggestion in how to apply delimiter to this VI?  

I have tried using the "Array to spreadsheet string" VI that Labview has, but that didnt work at all.

Thanks

[smercurio_fc]

moved to here:http://forums.ni.com/t5/LabVIEW/connecting-two-terminals-of-different-types/td-p/2045658