jxl.dll操作总结

1）Jxl是一个开源的Java Excel API项目，通过Jxl，Java可以很方便的操作微软的Excel文档。除了Jxl之外，还有Apache的一个POI项目，也可以操作Excel，两者相比之下：Jxl使用方便，但功能相对POI比较弱。

2）jxl.dll据说是一个韩国人写的，并且是用java语言写的。是通过一个ikvm的工具转换为jxl.dll供windows平台使用的。具体可以参照下面两个链接内容：

 

http://www.splinter.com.au/using-java-libraries-in-a-c-app-with-ikvm/
http://blog.csdn.net/kingdax1/article/details/2679610

3）并且jxl不支持excel2007及以上的版本。

4）简要使用方法如下:

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using jxl;
using jxl.write;
namespace ExcelWrap
{
    /// <summary>
    /// jxl.dll帮助类
    /// 说明:jxl不支持excel2007以上格式
    /// </summary>
    public class JxlHelper
    {

        public static void ReadExcel(string ExcelPath)
        { 
          
        try {
            
            //Create a workbook object from the file at specified location. 
            //Change the path of the file as per the location on your computer. 
            Workbook wrk1 =  Workbook.getWorkbook(new FileInfo(ExcelPath));
            
            //Obtain the reference to the first sheet in the workbook
            Sheet sheet1 = wrk1.getSheet(0);
            
            //Obtain reference to the Cell using getCell(int col, int row) method of sheet
            Cell colArow1 = sheet1.getCell(0, 0);
            Cell colBrow1 = sheet1.getCell(1, 0);
            Cell colArow2 = sheet1.getCell(0, 1);
            
            //Read the contents of the Cell using getContents() method, which will return 
            //it as a String
            String str_colArow1 = colArow1.getContents();
            String str_colBrow1 = colBrow1.getContents();
            String str_colArow2 = colArow2.getContents();
            
            //Display the cell contents
            System.Console.WriteLine("Contents of cell Col A Row 1: \""+str_colArow1 + "\"");
            System.Console.WriteLine("Contents of cell Col B Row 1: \""+str_colBrow1 + "\"");
            System.Console.WriteLine("Contents of cell Col A Row 2: \"" + str_colArow2 + "\"");


        }
        catch (jxl.read.biff.BiffException e)
        {
            Console.WriteLine(e.StackTrace);
        } catch (IOException e) {
            Console.WriteLine(e.StackTrace);
        }
        
        }

        public static void WriteExcel(string ExcelPath)
        { 
          try {
            FileInfo exlFile = new FileInfo(ExcelPath);
            WritableWorkbook writableWorkbook = Workbook
                    .createWorkbook(exlFile);

            WritableSheet writableSheet = writableWorkbook.createSheet(
                    "Sheet1", 0);

            //Create Cells with contents of different data types. 
            //Also specify the Cell coordinates in the constructor
            Label label = new Label(0, 0, "Label (String)");
            System.DateTime dt = System.DateTime.Now;
            jxl.write.DateTime date = new jxl.write.DateTime(1, 0, ref dt);
            jxl.write.Boolean bl = new jxl.write.Boolean(2, 0, true);
            Number num = new Number(3, 0, 9.99);

            //Add the created Cells to the sheet
            writableSheet.addCell(label);
            writableSheet.addCell(date);
            writableSheet.addCell(bl);
            writableSheet.addCell(num);

            //Write and close the workbook
            writableWorkbook.write();
            writableWorkbook.close();

        } catch (IOException e) {
            Console.WriteLine(e.StackTrace);
        } catch (jxl.write.biff.RowsExceededException e) {
            Console.WriteLine(e.StackTrace);
        } catch (WriteException e) {
            Console.WriteLine(e.StackTrace);
        }
        }
    }
}

 5)其他的使用方法可以参考java实现的例子。网上关于java的例子还是挺多的。之前我并不知道它是通过java转换而来的，也没有可以使用的例子，只有通过Reflector反编译看源码，慢慢了解。