DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

Program. selecting channels for excel export wizard

Is it possible to set which channels to be selected before showing the Excel Export wizard? When the wizard is shown the user off course can select/deselect any channels, but i would just like to select the time channels as a kind of default selection.

I've tried playing around with the "ExcelExpChn" variable to no avail, but I'm not sure that's what it's for anyway.

I want the script to be generic (independent of the number of groups/channels present) so I don't think a config file is the answer.
0 Kudos
Message 1 of 4
(3,923 Views)
I've used the following script for exporting the
10 channels (2,3,7...14):
 
Option Explicit
EXCELChnCount=10
ExcelExpChn(1)=2
ExcelExpChn(2)=3
ExcelExpChn(3)=7
ExcelExpChn(4)=8
ExcelExpChn(5)=9
ExcelExpChn(6)=10
ExcelExpChn(7)=11
ExcelExpChn(8)=12
ExcelExpChn(9)=13
ExcelExpChn(10)=14
call EXCELExport ("x:\hel\abc.xls","",1,"")
 
EXCELChnCount is the number of channels to export,
in ExcelExpChn(1...EXCELChnCount) you put the channels
(1-based index) to export.
The channel type is determined automatically from the DIAdem channel.
Please note that the array ExcelExpChn is limited to 256 entries.
0 Kudos
Message 2 of 4
(3,893 Views)
Exactly what i needed, thanks!
Thats how i expected it to work, only i didn't know about the ExcelChnCount variable.
0 Kudos
Message 3 of 4
(3,884 Views)

Do you know how to export (with this or other command/code) more than 256 channels from DIAdem to Excel without using the wizard?

It seems impossible with EXCELExport because you obtain the following error: "EXCELExpChn(257) invalid vector or matrix index", but certainly it is possible to do if you open the Excel Export Wizard and select the check boxes of more than 256 channels.

How to do the same without open Winzard?

Thanks,
Jose

0 Kudos
Message 4 of 4
(3,228 Views)