KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am writing a tool in Java using Apache POI API to convert an XML to MS Excel. In my XML input, I receive the column width in points. But the Apache POI API has a slightly queer logic for setting column width based on font size etc. (refer API docs ) Is there a formula for converting points to the width as expected by Excel? Has anyone done this before? There is a setRowHeightInPoints() method though :( but none for column. P.S.: The input XML is in ExcelML format which I have to convert to MS Excel.
Tags (comma-separated)
Save Edits
Cancel