DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

Export to Excel

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
0 Kudos
Message 1 of 4
(4,629 Views)
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.
0 Kudos
Message 2 of 4
(4,628 Views)

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

Matthias Alleweldt
Project Engineer / Projektingenieur
Twigeater?  
0 Kudos
Message 3 of 4
(4,603 Views)
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

0 Kudos
Message 4 of 4
(4,586 Views)