As a process of learning Excel 2003 XML file, an Excel XML Writer implements an Excel XML File. Basically, the Excel 2003 XML file format is full support, the list is as follows: Row Cell Styles (Font, Alignment, Interior, NumberFormat) NamedRange formula (not completion yet). A small demo code sets the units of the A1 to E5: import com.dyz.xfe. *; / ** * @Author dengyunze * * Todo to change the template for this Generated Type Comment Go To * WINDOW - Preferences - Java - Code Style - Code Templates * / Public Class Testmain {
Public static void main (string [] args) {workbook book = new workbook ("d: /excel.xml"); Worksheet S1 = BOOK.GETWORKSHEET (1); Book.defineralge ("Range1", 1, 1, 1 , 4, 4); for (int i = 1; i <5; i ) {for (int J = 1; j <5; j ) {Cell Cell = S1.Getcell (i, j); cell.setValue i * j);}} box.close ();}}
