OpenOffice CALC in DIAdem

[Devaseelan]

HI

 I am trying to write data to open Office Calc from DIadem using activex (OOCALCVB.dll). i can able to open openoffice calc application,Add new worksheet and rename the worksheet using Diadem script. but i can't able write data to specific cell.

 using that same dll i can able write data in Labview.

i not have knowledge in VB or DIAdem Scripting. Please Help me.

[Brad_Turpin]

Hi Deva,

How much data are you wanting to import into OpenOffice CALC?  If it's a lot, you should consider instead saving your DIAdem data to a TDM or TDMS data file and opening that TDM or TDMS file into OpenOffice CALC with the TDM Excel Add-in for OpenOffice?

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[Devaseelan]

HI Brad Turpin

Thanks for your reply.

My entire datalog format is in tdms only. I am using Openoffice Calc as Final consolidated Report requested by customer as XSL or .ods which is generated by DIAdem Script. I am trying to use openoffice due to open-source

[Brad_Turpin]

Hi Deva,

So what do you think of the suggestion of saving the data for the final report to a TDM/TDX file and loading it into OpenOffice?  Alternatively, I can help you make VBScript calls to send values to cells in Excel, then the resulting XLS file could be loaded into OpenOffice.

Your VBscript code doesn't run on my computer.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[Devaseelan]

Hi Brad Turpin

My Requirement is

*I am Collecting 100000 Samples/Sec and Save Data as TDMS and Sending to DIAdem.

* From DIAdem Calculating Some Points and Saving Report in TDR Format and PDF Format for Each Test.

*Again from DIAdem i want to save Day Report as Test Parameters, Test Result and Time of each Test in Excel sheet for every day.

I am already did DIAdem to Excel Data Export. Now our end user is not willing to buy Microsoft office for each computer, So i am now trying to do that same procedure in openoffice.

To run that script in diadem you need to install openoffice and register the OOCALCVB.dll(save in Windows/system 32).

That script needs to create New openoffice spreadsheet, rename sheet name and save data to spreadsheet.

script successfully open openoffice spreadsheet and rename the active sheet successfully, but finally data not writing into sheet. 

Using that same dll i can able to do same procedure in Labview successfully.

Thankyou.

[Brad_Turpin]

Hi Deva,

One difference between VBScript and LabVIEW when communicating to an external DLL, is that LabVIEW can send and receive all IEEE data types, whereas VBScript can only send and receive variants.  If the DLL has any methods with inputs or outputs that are NOT of type variant, then those methods will work in LabVIEW and not in VBScript.  In most cases you need to wrap the DLL with a COM object in order to guarantee that VBScript can use all the methods in the DLL.  There are some DLLs that are built with only variant inputs and outputs and require no COM wrapping.

If you'll send me the LabVIEW code that works, then I can look at the data types from the VI.  Or you could do it and let me know what you find.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[Devaseelan]

HI Brad Turpin

Datatype of that Dll is String.

[Brad_Turpin]

Hi Deva,

That explains it then.  VBScript can only send and receive variant variables.  Variant-of-subtype-string is not the same thing as a String data type.  The Excel ActiveX interface sends and receives only variant variables.

Brad Turpin

DIAdem Product Support Engineer

National Instruments