| <#ftl output_format="HTML" > |
| <#-- |
| Licensed to the Apache Software Foundation (ASF) under one |
| or more contributor license agreements. See the NOTICE file |
| distributed with this work for additional information |
| regarding copyright ownership. The ASF licenses this file |
| to you under the Apache License, Version 2.0 (the |
| "License"); you may not use this file except in compliance |
| with the License. You may obtain a copy of the License at |
| http://www.apache.org/licenses/LICENSE-2.0 |
| Unless required by applicable law or agreed to in writing, |
| software distributed under the License is distributed on an |
| "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| KIND, either express or implied. See the License for the |
| specific language governing permissions and limitations |
| under the License. |
| --> |
| <#assign document = Documents.get(0)> |
| <#assign documentName = document.name> |
| <#assign workbook = ExcelTool.parse(document)> |
| <#assign date = .now?iso_utc> |
| <#---------------------------------------------------------------------------> |
| <!DOCTYPE html> |
| <html> |
| <head> |
| <title>${documentName}</title> |
| <meta charset="UTF-8"> |
| <meta name="viewport" content="width=device-width, initial-scale=1"> |
| <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css"> |
| </head> |
| <body> |
| <div class="container-fluid"> |
| <h1>Excel Test |
| <small>${documentName}, ${date}</small> |
| </h1> |
| <@writeSheets workbook/> |
| </div> |
| </body> |
| </html> |
| |
| <#---------------------------------------------------------------------------> |
| <#-- writeSheets --> |
| <#---------------------------------------------------------------------------> |
| <#macro writeSheets workbook> |
| <#assign sheets = ExcelTool.getSheets(workbook)> |
| <#list sheets as sheet> |
| <@writeSheet sheet/> |
| </#list> |
| </#macro> |
| |
| <#---------------------------------------------------------------------------> |
| <#-- writeSheet --> |
| <#---------------------------------------------------------------------------> |
| <#macro writeSheet sheet> |
| <#assign rows = ExcelTool.toTable(sheet)> |
| <h2>${sheet.getSheetName()}</h2> |
| <@writeRows rows/> |
| </#macro> |
| |
| <#---------------------------------------------------------------------------> |
| <#-- writeRows --> |
| <#---------------------------------------------------------------------------> |
| <#macro writeRows rows> |
| <table class="table table-striped"> |
| <#list rows as row> |
| <#if row?is_first> |
| <tr> |
| <th>#</th> |
| <#list row as column> |
| <th>${column}</th> |
| </#list> |
| </tr> |
| <#else> |
| <tr> |
| <td>${row?index}</td> |
| <#list row as column> |
| <td>${column}</td> |
| </#list> |
| </tr> |
| </#if> |
| </#list> |
| </table> |
| </#macro> |