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)
------------------------------
Comments
-
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 sheetIt it possible to write a custom Velocity report that exports to an excel containing multiple sheets ?
------------------------------
Uwe Matzen
Otometrics (Natus Medical Denmark)
------------------------------
Patrick0 -
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 sheetYes, 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 sheetIt it possible to write a custom Velocity report that exports to an excel containing multiple sheets ?
------------------------------
Uwe Matzen
Otometrics (Natus Medical Denmark)
------------------------------
0 -
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 sheetDo 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 sheetYes, 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 sheetIt it possible to write a custom Velocity report that exports to an excel containing multiple sheets ?
------------------------------
Uwe Matzen
Otometrics (Natus Medical Denmark)
------------------------------
Patrick0