[
https://issues.apache.org/jira/browse/ODFTOOLKIT-422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15206170#comment-15206170
]
Kakha Kheladze commented on ODFTOOLKIT-422:
-------------------------------------------
Please see comments and files attached by Nikoloz Gochiashvili [~ngochiashvili]
> PERFORMANCE ISSUE: "Format Load" , "Put Data" & "Append Sheet"
> ---------------------------------------------------------------
>
> Key: ODFTOOLKIT-422
> URL: https://issues.apache.org/jira/browse/ODFTOOLKIT-422
> Project: ODF Toolkit
> Issue Type: Bug
> Components: performance
> Affects Versions: 0.6.2-incubating
> Environment: Windows & Linux
> Reporter: Kakha Kheladze
> Labels: performance
>
> Dear Sir,
> We are using ODFTOOLKIT for 3 main functions:
> 1. "Format Load" - Loading format into spreadsheet
> 2. "Put Data" - population table into spreadsheet , it could be table with
> 5,000 rows and 20 columns.
> 3. "Append Sheet" - Appending several sheets and assembling workbook. (up to
> 150 sheets)
> We have a serious issue with performance, these 3 steps for 150 sheets with
> 5000x20 dimension may take more then 1h.
> See some code below.
> Any help or idea will be highly appreciated.
> Kakha
> ---------------------------------------------------------------------------------------
> @Override
> public void setCellValue(int colIndex, int rowIndex, double value) {
> try {
> Cell cell = currentSheet.getCellByPosition(colIndex, rowIndex);
> String valueType = cell.getValueType();
> if (valueType != null) {
> switch (valueType) {
> case "percentage":
> cell.setPercentageValue(value);
> break;
> default:
> cell.setDoubleValue(value);
> }
> } else {
> cell.setDoubleValue(value);
> }
> } catch (Throwable t) {
> log.error(t.getMessage(), t);
> }
> }
>
>
>
> ---------------------------------------------------------------------------------------------------------
> try (ByteArrayInputStream in = new ByteArrayInputStream(content)) {
> spreadsheetDocument = SpreadsheetDocument.loadDocument(in);
> }
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
