Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (102)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (322)
Collections:
Other Resources:
Example of Excel Date Format with jxl.jar
Where can I find an example Java code that uses jxl.jar to add date cell format to a new Excel file?
✍: FYIcenter.com
You can follow these suggestions and example to add date cell format to a new Excel file with jxl.jar:
Dates are handled similarly to numbers, taking in a format compatible with that used by the java.text.SimpleDateFormat class. In addition, several predefined date formats are specified in the jxl.write.DateFormat class.
As a brief example, the below code fragment illustrates placing the current date and time in cell A7 using a custom format:
// Get the current date and time from the Calendar object
Date now = Calendar.getInstance().getTime();
DateFormat customDateFormat = new DateFormat ("dd MMM yyyy hh:mm:ss");
WritableCellFormat dateFormat = new WritableCellFormat (customDateFormat);
DateTime dateCell = new DateTime(0, 6, now, dateFormat);
sheet.addCell(dateCell);
As with numbers, font information may be used to display the date text by using the overloaded constructors on WritableCellFormat.
Here is the complete source code of example program JxlAddDateFormat.java:
// Copyright (c) FYIcenter.com
import java.util.*;
import jxl.write.*;
import jxl.write.Number;
// Example of adding formatting properties for Dates in a new Excel file
public class JxlAddDateFormat {
public static void main(String [] args) throws Exception {
jxl.write.WritableWorkbook workbook
= jxl.Workbook.createWorkbook(new java.io.File("output.xls"));
jxl.write.WritableSheet sheet = workbook.createSheet("First Sheet", 0);
// Get the current date and time from the Calendar object
Date now = Calendar.getInstance().getTime();
DateFormat customDateFormat = new DateFormat ("dd MMM yyyy hh:mm:ss");
WritableCellFormat dateFormat = new WritableCellFormat (customDateFormat);
DateTime dateCellA7 = new DateTime(0, 6, now, dateFormat);
sheet.addCell(dateCellA7);
// Create a cell format for Times 16, bold and italic
WritableFont times16font = new WritableFont(WritableFont.TIMES, 16, WritableFont.BOLD, true);
WritableCellFormat times16format = new WritableCellFormat (times16font);
WritableCellFormat dateFormat16 = new WritableCellFormat (times16font, customDateFormat);
DateTime dateCellA9 = new DateTime(0, 8, now, dateFormat16);
sheet.addCell(dateCellA9);
workbook.write();
workbook.close();
}
}
You can compile and run the above example in a command window as shown below:
C:\fyicenter>c:\local\jdk-1.8.0\bin\javac -cp .;\fyicenter\jexcelapi\jxl.jar JxlAddDateFormat.java C:\fyicenter>c:\local\jdk-1.8.0\bin\java -cp .;\fyicenter\jexcelapi\jxl.jar JxlAddDateFormat
The output file, output.xls, is ready for Microsoft Excel to open.
⇒ Example of Read Excel File with jxl.jar
⇐ Example of Excel Number Format with jxl.jar
2018-02-28, ∼5938🔥, 0💬
Popular Posts:
How to show the XML parsing flow with sax\DocumentTracer.java provided in the Apache Xerces package?...
Apache ZooKeeper is an open-source server which enables highly reliable distributed coordination. Ap...
JDK 17 jdk.jpackage.jmod is the JMOD file for JDK 17 JPackage tool, which can be invoked by the "jpa...
Where to get the Java source code for Connector/J 8.0 User API module? Java source code files for Co...
JDK 11 java.rmi.jmod is the JMOD file for JDK 11 RMI (Remote Method Invocation) module. JDK 11 RMI m...