EXCEL

[SOLO]

....Hi..
I would like to export from a VI all settings and data to an EXCEL workbook..
I use LV5.1 and Office 2000..
....Has someone an example to give me?

Thanks...

[LunaBlue]

Did you have a look at the example
....\LabVIEW\EXAMPLES\COMM\ole-excel8.llb ?

SOLO wrote:
> ....Hi..
> I would like to export from a VI all settings and data to an EXCEL workbook..
> I use LV5.1 and Office 2000..
> ....Has someone an example to give me?
>
> Thanks...

[Solo]

Yes I tried it but it doesn't work correctly.
If I try to modify an example sometimes some wire becomes no good..
Maybe i have problem with activeX.. I use WinXP, LV 5.1 and Office XP...





Nikolai Maris wrote:
> Did you have a look at the example
> ...\LabVIEW\EXAMPLES\COMM\ole-excel8.llb ?
>
> SOLO wrote:
>> ....Hi..
>> I would like to export from a VI all settings and data to an EXCEL
>> workbook.. I use LV5.1 and Office 2000..
>> ....Has someone an example to give me?
>>
>> Thanks...

[ilan the amazing]

I have the same problem. I have spreadsheet data in a text file I want to write to an excel file (that is the easy part, just use the "write to excel.vi" in the excel VI library). The hard part is naming the excel file with the same name I used for the text file (just with different extensions, .xls instead of .txt).

there is an activeX component called "To Variant" that is supposed to be able to change anything to EXCEL data but it's not working. I'm using the "TO Variant" to convert the filename (in string) to a format excel can recognize. I then send this information to the "filename" property on the excel workbook property node (all located inside "write to excel.vi." Excel wont take the name though. I was told to use "write labview measurement data.vi" but i have no idea how this works and I don't think it's helping me.

[SVences]

Hello –

The complexity of the ActiveX interface of Microsoft Word and Excel makes the development of custom applications difficult.
My recommendation is that you use the LabVIEW Report Generation Toolkit for Microsoft Office to easily interact with these document packages.

S Vences
Applications Engineer
National Instruments

[Caki]

Hi !

I can't find an Code.  How can I get the Text in the middle of excel cell.

Can Everybody help me !

Thanks

[ilan the amazing]

You must be more specific, I dont understand your question.

In short, if you want to write to excel, there are VI's built into labview and you can also buy the Labview-to-MS Office suite to accomplish report generation in MS Office using data generated/gathered in labview.

if you want to read from excel, you're scr*wed.

[Caki]

I have a vi they put many dates in excel cells. this vi customise the test format blod,  column , row heigth etc. I will put the text in the middle of the cell, but i haven't find Propery to this funktion.  I will make an Alignmentation to the spezified cells.

Thanks

[AESulzer]

Are you saying that you want to be able to control the alignment of cells in LabVIEW? If so, perhaps we could better help you if you posted a simplified example with a description about what you are trying to do with it.

Kind Regards,