Data360 Analyze

 View Only
  • 1.  Stop overwritten output, keep formatting

    Posted 02-03-2023 12:32

    I am working on outputting a file to excel after some formatting. Currently I am using the output excel node with formatting from a template (FormatOutput & TemplateInputFile). The excel input file has columns such as percent, accounting, etc, but when exported out it gets converted back to General in excel, so it keeps the format integrity for the header row only but none of the data. Is there a way to have the format stay for all rows?

    Thank you

    Javian Brown
    Knowledge Community Shared Account

  • 2.  RE: Stop overwritten output, keep formatting

    Posted 03-22-2023 10:39
      |   view attached

    I cannot reproduce the issue you reported.

    Here is the example I used to test it out:

    The source data is from a CSV file:

    A Modify Fields node is used to auto-detect and convert the data type of the fields. The data is then sent to an Output Excel node that is configured to use a Template file (and one that is not using a template file).

    The Output Excel node configuration properties are shown below:

    The OutputSpec property value is configured to route the data from the (first) input pin of the Output Excel node to the second worksheet in the output Excel workbook.

    The Template xlsx file has two worksheets. The second is a default worksheet that will store the data that is loaded into the file by the Output Excel node (it is named Raw_Data).

    The first worksheet had format definitions for the required cell ranges and the values for those cells reference the cells in the second worksheet:

    When the data flow is run, the output workbook is populated with the data and the first worksheet contains the formatted data.

    See the attached zip file.

    Adrian Williams
    Precisely Software Inc.