The Servlet cannot download an Excel file with more than 65,000 rows because it only supports the legacy .xls format. Adding support of the .xlsx format would eliminate this limitation. Yes we could use the REST APIs to obtain the same information. But the servlet is very powerful with it being able to pull additional information from the user and the issue. Doing that with the REST APIs would require multiple calls and matching the data among those calls. And yes we could call the servlet with smaller date ranges. But appending multiple spreadsheets together to create a monthly report is very inconvenient. We currently have approximately 80,000 worklogs a month. I’m sure this enhancement would be very useful to other large shops.
Jeff Schumacher
| Tempo Products | Tempo Timesheets |
| Tempo Platform | On-Premise |
Hi Jeff,
It is .xlsx format, but since the format=excel parameter already produces .xls files we didn't want to break functionality for anyone depending on that file ending. The file is essentially in Office Open XML, which explains the new format parameter value. Open Office XML is the format that Microsoft uses for Excel 2007 and later.
I'm concerned when you say format=ooxml.
Is it .xml or .xlsx format?
I'm pleased to inform you that with Tempo Timesheets 10.20 that is now available through the Atlassian marketplace, the Tempo Servlet Export plugin supports exporting Excel 2007 format by using the format=ooxml parameter.
https://tempo-io.atlassian.net/wiki/spaces/SERVERNEWS/pages/1279164697/2020-09-21+Tempo+Timesheets+for+Server+10.20.0+Release
Tempo Servlet to support Excel .xlsx format. This is great to have.
It is easy to integrate and read .xlsx format with other development tools.
As .xlsx is widely using, Tempo servlet should also support it. I see scope of improvement here.
With a large user base and requirements of different views for Finance, managers, teams a single spreadsheet will ease out the problem of manual intervention .
With an increasing # of users and requirement for time entry this will provide a single download without manual manipulation, and therefore, reduce the risk of error. In addition, from an auditor's perspective, they prefer system generated with no manipulation