Use Java to operate Excel files

xiaoxiao2021-03-06  13

Import java.io. *; import java.lang.string; import jxl. *; import jxl.write. *; import jxl.format.underlinestyle

public class ExcelSaver {public String fileName; public jxl.write.WritableCellFormat wcfFC; public WritableWorkbook wwb; public WritableSheet ws; public ExcelSaver (String str) {fileName = str; try {// Construction Workbook object, // read-only Workbook object directly Create Workbook from the local file to create Workbook wwb = workbook.createworkbook (new file (filename)); ws = wwb.createsheet ("Test Sheet 1", 0); // Create an Excel Worksheet

// add an object with a font color Formatting jxl.write.WritableFont wfc = new jxl.write.WritableFont (WritableFont.TIMES, 10, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK); wcfFC = New JXL.WRITE.WRITABECELLFORMAT (WFC);} catch (exception e) {E.PrintStackTrace ();}

} Public void close () {Try {wwb.write (); wwb.close ();} catch (exception e) {E.PrintStackTrace ();}}

Public Void Savedata (INT I, INT J, STRING STR) {try {jxl.write.label labelcfc = new jxl.write.label (i, j, str, wcffc); ws.addcell (labelcfc);} catch (Exception e) {E.PrintStackTrace ();}}

Public static void main (string args []) {

Excelsaver Excelsaver = New Excelsaver ("Work.xls"); Excelsaver.savedata (0,0, "Hello"); Excelsaver.savedata (0, 1, "23423"); Excelsaver.close ();}}

转载请注明原文地址:https://www.9cbs.com/read-50337.html

New Post(0)