Velocity Excel report that has more than one sheet

Uwe Matzen
Uwe Matzen Member, Jama Validation Kit (JVK) + Functional Safety Kit (FSK) Posts: 8

It it possible to write a custom Velocity report that exports to an excel containing multiple sheets ?

------------------------------
Uwe Matzen
Otometrics (Natus Medical Denmark)
------------------------------

Comments

  • Patrick Szabo
    Patrick Szabo Member, Medical Devices & Life Sciences Solution Posts: 55
    edited October 2023

    Yes, this is possible. You can start with creating the file with the sheets you need in excel, then save it as Single File Web page (file ending .mht) and then rename the file ending to *.vm.

    Inside the file, the sections are separated with "------=_NextPart_...." and each sheet should be annotated with sheet001.htm, sheet002.htm, etc.

    Then add your velocity code to the respective sheet.

    ------------------------------
    Patrick
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-29-2023 05:27
    From: Uwe Matzen
    Subject: Velocity Excel report that has more than one sheet

    It it possible to write a custom Velocity report that exports to an excel containing multiple sheets ?

    ------------------------------
    Uwe Matzen
    Otometrics (Natus Medical Denmark)
    ------------------------------
    Patrick
  • Sara Wertanen
    Sara Wertanen Member Posts: 5
    edited October 2023

    Do you know if it's possible to have the velocity report separate items based on folders into separate excel tabs? For example, I have a Set with 4 folders filled with items and I want each folder put into separate excel tabs. I would think it's similar to how velocity can do hierarchy based on folder level and turn them into headings for Word but I'm not sure how to apply that to Excel velocity exports. 

    ------------------------------
    Sara Wertanen
    Oceaneering Entertainment Systems
    FL
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 10-02-2023 07:25
    From: Patrick Szabo
    Subject: Velocity Excel report that has more than one sheet

    Yes, this is possible. You can start with creating the file with the sheets you need in excel, then save it as Single File Web page (file ending .mht) and then rename the file ending to *.vm.

    Inside the file, the sections are separated with "------=_NextPart_...." and each sheet should be annotated with sheet001.htm, sheet002.htm, etc.

    Then add your velocity code to the respective sheet.

    ------------------------------
    Patrick
    ------------------------------

    Original Message:
    Sent: 09-29-2023 05:27
    From: Uwe Matzen
    Subject: Velocity Excel report that has more than one sheet

    It it possible to write a custom Velocity report that exports to an excel containing multiple sheets ?

    ------------------------------
    Uwe Matzen
    Otometrics (Natus Medical Denmark)
    ------------------------------
  • Patrick Szabo
    Patrick Szabo Member, Medical Devices & Life Sciences Solution Posts: 55
    edited October 2023

    This is probably not so straight forward, but you could maybe write a macro which creates a sheet for each folder. Difficulty is probably to let the code create the file list and the array of Tab names, which have to come at the beginning of the file.

    ------------------------------
    Patrick
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 10-02-2023 07:32
    From: Sara Wertanen
    Subject: Velocity Excel report that has more than one sheet

    Do you know if it's possible to have the velocity report separate items based on folders into separate excel tabs? For example, I have a Set with 4 folders filled with items and I want each folder put into separate excel tabs. I would think it's similar to how velocity can do hierarchy based on folder level and turn them into headings for Word but I'm not sure how to apply that to Excel velocity exports. 

    ------------------------------
    Sara Wertanen
    Oceaneering Entertainment Systems
    FL
    ------------------------------

    Original Message:
    Sent: 10-02-2023 07:25
    From: Patrick Szabo
    Subject: Velocity Excel report that has more than one sheet

    Yes, this is possible. You can start with creating the file with the sheets you need in excel, then save it as Single File Web page (file ending .mht) and then rename the file ending to *.vm.

    Inside the file, the sections are separated with "------=_NextPart_...." and each sheet should be annotated with sheet001.htm, sheet002.htm, etc.

    Then add your velocity code to the respective sheet.

    ------------------------------
    Patrick

    Original Message:
    Sent: 09-29-2023 05:27
    From: Uwe Matzen
    Subject: Velocity Excel report that has more than one sheet

    It it possible to write a custom Velocity report that exports to an excel containing multiple sheets ?

    ------------------------------
    Uwe Matzen
    Otometrics (Natus Medical Denmark)
    ------------------------------
    Patrick