Export to Excel

[Lila]

Hi all,

I am currenting working with a script in DIAdem 10.2, trying to export a channel containing 2 values to an already existing excel file using the following command:

Call ExcelExport(EXCELFile, EXCELSheet, EXCELDlgFlag, EXCELConfigFile)

I have basically 2 questions:

1)  Upon the DIAdem help, the second parameter should be the name of the worksheet in Excel.  So I tried once with giving a name of the worksheet in an existing excel file and run the above command.  This command delete all the existing worksheets and add a new one under the name of "DIAdem" and export the data I wanted to.  The same happened when I don't give hany EXCELsheet in the above command.  Does anyone know how I can save my data in one specific worksheet?

2)  Is there any command for exporting a channel from data portal where I can set a certain column or row in excel for saving the exported channel?

Greetings,

Lila

[Lila]

By the way, can anyone tell me how I can delete my own post in the forum?  Nothing mentioned in the help of the Forum.

[Twigeater]

Hello Lila!

1. DIAdem will always create a new output file and isn't able to add content to an existing file.
2. There is no way to specify a starting cell.

The only way out I know is to use the Excel OLE interface.

Matthias

[Walter_Rick]

Hi Lila,

In addition I would like to point to the (free of charge) Excel-Add-In.

Link: http://zone.ni.com/devzone/cda/epd/p/id/2944

With that Add-In it is possible to load TDM files directly, so it is not necessary to export them as Excel file.

Greetings
Walter