You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2017/03/24 11:22:14 UTC

[Bug 60915] New: XLS to HTML Charts to coming

https://bz.apache.org/bugzilla/show_bug.cgi?id=60915

            Bug ID: 60915
           Summary: XLS to HTML Charts to coming
           Product: POI
           Version: 3.15-FINAL
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: blocker
          Priority: P2
         Component: HSLF
          Assignee: dev@poi.apache.org
          Reporter: pooja.dhannawat535@gmail.com
  Target Milestone: ---

I am using ExcelToHtmlConverter provided by POI to xls to pdf conversion.
Somehow in the output I am not getting charts. 

I thought of adding one more method in ExcelToHtmlConverter named as
processChart by extending the class. Sample method -

 //TODO convert chart to images and add to output
    private void processChart(HSSFSheet sheet) {
        for(HSSFChart chart : HSSFChart.getSheetCharts(sheet)){
            Element table = this.htmlDocumentFacade.createTable();
            this.htmlDocumentFacade.addStyleClass(table,
this.cssClassPrefixTable, "border-collapse:collapse;border-spacing:0;");
            Element tableBody = this.htmlDocumentFacade.createTableBody();
            tableBody.setTextContent(chart.getChartTitle());
            table.appendChild(tableBody);
            this.htmlDocumentFacade.getBody().appendChild(table);
        }
    }


Somehow I am not able to convert this HSSFChart to image. Please suggest me a
way to convert to chart to image or to add them in final output.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 60915] XLS to HTML Charts not coming

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60915

pooja.dhannawat535@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|XLS to HTML Charts to       |XLS to HTML Charts not
                   |coming                      |coming

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 60915] XLS to HTML Charts not coming

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60915

Javen O'Neal <on...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|blocker                     |enhancement
         Resolution|---                         |INVALID
             Status|NEW                         |RESOLVED

--- Comment #1 from Javen O'Neal <on...@apache.org> ---
I am not sure what the issue is. Sounds like a mixture of a usage question and
a feature enhancement request. ExcelToHtmlConverter outputs to HTML, not PDF.
POI currently cannot render charts to images. If anyone is interested in
improving the charts API, we encourage them to contact us on the mailing list.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 60915] XLS to HTML Charts not coming

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60915

pooja.dhannawat535@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|HSLF                        |HSSF

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org