tags:

views:

14

answers:

0
Q: 

How do I write a date Cell that has a vertical alignment of TOP

In JExcelApi, I can write a date cell, and it's formatted as a date (if I call addCell without a CellFormat). But, if I add a CellFormat, Excel doesn't treat it as a date format. I can't find any way with a WritableCellFormat to set a DateFormat, and I can't set it to top vertical alignment without passing in a CellFormat.

related questions

JExcel Output Issues
jexcel - transpose question
Using the JExcel API, how do I enter a cell value of unknown data type without a hidden apostrophe being added?
How to read excel using jexcel ?
Installing jexcelapi
JExcelApi : Cells with no background color became black when using WritableWorkbook.write
JExcel doesn't copy Array formula
Problem when extracting excel data using POI in JAVA?
Opening an Excel file using the default program
Detecting struckout text in a cell using JExcelApi
Making new colors in JExcelApi
JExcelApi: multiple formats in one cell?
JExcelApi currency format on formula cell - file error
jExcelApi - cell date format reusing doesn't work.
Choosing an excel java api.
JExcelAPI - writing date to Excel sheet ignores day, month and year.
Which library should I use to write an XLS from Linux / Python?