export to excel

Hello,

how can i export skiplist to excel , is that possible with dxl ?

thanks ,

Re: export to excel
Mathias Mamsch - Thu Aug 31 12:10:11 EDT 2017

Sure. You can do something like:

Skip mySkip = create();

void exportSkipValueToExcel(string val) {
    // to be implemented
} 

// fill your skip list
// ...
// 

for val in Skip do {
    exportSkipValueToExcel(val);
}

Maybe you are looking for something more specific? There are lots of topics on excel export. Did you do a search?

Regards, Mathias

Re: export to excel
Control17 - Mon Sep 04 04:11:16 EDT 2017

Skip mySkip = create();

void exportSkipValueToExcel(string val) {
    // to be implemented
} 

// fill your skip list
// ...
// 

for val in Skip do {
    exportSkipValueToExcel(val);
}

thank u , i will  try it .

Regards ,

Neven

Re: export to excel
Control17 - Thu Sep 28 09:16:44 EDT 2017

Hello ,

I found many topic about export to excel in this forum , but I did not find what I need ?

how to export skiplist to excel and when I do export which part of skiplist I get ( key and value ) ?

Regards,

Neven

Re: export to excel
Mike.Scharnow - Fri Sep 29 00:18:46 EDT 2017

Hello Neven,

sorry, but exporting to Excel is really a very advanced DXL topic as you have to deal with OLE and the COM Model and with talking to the Excel application, sheets, cells, formats etc..

The only advice I can give is to use e.g. the Enhanced Export to Excel add in from Galactic Solutions (http://galactic-solutions.com/downloads/GalacticDownloadExcel.htm, the dxl file is unencrypted) as a start for your implementation and adopt it to your needs.

Regards,
Mike

Re: export to excel
Mike.Scharnow - Fri Sep 29 01:12:19 EDT 2017

Alternatively, create a tsv (or csv) file. Use a stream for writing to a tsv file, print the tab seperated (comma/semicolon separated) heading line to the file,, use a loop that iterates over the skip list, for every entry print a line that contains key and value, tab seperated. Close the stream, open the tsv file in Excel.