Customer Portal

SpreadsheetDataWriter -> DICTIONARY

Comments 3

  • Avatar
    imriskal
    0
    Comment actions Permalink
    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,
  • Avatar
    capucha
    0
    Comment actions Permalink
    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 <
  • Avatar
    imriskal
    0
    Comment actions Permalink
    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,

Please sign in to leave a comment.