SpreadsheetDataWriter -> DICTIONARY

I have following problem.
I am using SpreadsheetDataWriter ( in this component I am using predefined template file ) which is filled from DB fields.
But I am not able to pass it to the dictionary ( because i would like to give the result of graphrun to user (I would like to use same way as in mountain example)

I found that I am able quite simply pass result of XLSDataWriter to dictionary. in file url i use dict:XLSX_FILE.XLSX:source

Could you tell me if this is possible with SpreadsheetDataWriter?

Hi, capucha,

I am not sure I fully understand. If you are trying to use dict:XLSX_FILE.XLSX:source on SpreadsheetDataWriter and you are getting “Unsupported format of output file!” error like me, try to set Type of formatter property from Auto to e.g. XLS. That helped in my case and I am now able to write using both XLSDataWriter and SpreadsheetDataWriter in the same way. It is a bug, both writers should behave in the same way here, see https://bug.javlin.eu/browse/CL-2754

If I misunderstood something, please, let me know.

Best regards,

Thank you,
it helps a little.
My problem is that i need to pass to user XLS file with results of graph execution.(spreadsheetDataWriter with template and horizontal and vertical data filling)
I am able to Save xlsx file to data-out dictionary, but I don’t know how to pass this file as a result of “Launch Service” through server?
I have tried to use writable.channel but it seems it works only with xlsDataWriter.

Is there a waz how to do this <

Hello again,

Would not be easier to pass name of the xls file instead of the whole file? Dictionary does not serve for storage of data, it serves just for storage of small pieces of information (value of some variable, path to some file, id of last processed record, … )

Your question partially covers topic discussed here viewtopic.php?f=4&t=6540 Please read it for more information. Bottom line is that implementation of passing of large data sets directly is planned for the version 3.5.M1.

Best regards,