Forum Discussion

RakeshKumar1's avatar
RakeshKumar1
New Contributor
4 years ago

Does Snaplogic support writing Grid format headers for Excel Binary Spreadsheet(.xslb files)?

Hello Team, I have requirement of writing excel binary spreadsheet .xslb extension type. Used Excel formatter snap followed by file writer and able to write the .xslb file , But how do i apply ...
christwr's avatar
christwr
Contributor III
8 years ago
Copy LinkReport

There is an Aggregate snap, which you do stuff like COUNT, but not sure it’s worth it. If you did a Head snap with Offset=1 and Documents=1000000 (or some arbitrary max) would that work?

mongley's avatar
mongley
New Contributor II
8 years ago
Copy LinkReport

Hi Chris, yes that works thanks

  • Harsha3's avatar
    Harsha3
    New Contributor III
    5 years ago
    Copy Link

    Hi Ptaylor,

    Please find my Parent and Child pipeline and source file known as Excel Date

    Pipelines:

    Generator.Holiday files_2021_01_30 (1).slp (11.3 KB) Parent Date Pipeline_2021_01_30.slp (7.3 KB)

    Source File:Date Generator.xlsx (18.7 KB)

    My Expected Output:

    My Obtained Output:

    May be I am using file overwrite here may be a concern . If we store the same in a oracle table through insert method we could capture all of them . But I need a file writer to this job.

    Thanks