面试题，头大不知道该怎么办。 热：报错

用 win 的Com 接口, 直接调用 excel的接口, 导出csv

然后 想咋干就咋干

软件就是服务嘛

把Excel 当成工人看待

jxl是一个java用于处理小数据量的，而且易于使用的处理excel的类库，但仅限于数据量比较少。因为jxl是将workbook中的整个sheet的内容都加载到内存中来处理的，如果你操作的是getSheets(),那么将把workbook中所有的sheet都加载到内存，然后才处理。所以针对数据量比较大的情况下，还是不要使用jxl。另外他对03之前的支持还可以，之后就不支持了。对于数据量比较小的情况下，可以玩玩，数据量大的情况下可以尝试使用poi.

From http://www.andykhan.com/jexcelapi/tutorial.html

Memory Allocation and Sheet Caching

For very large files, it was found that reading in the entire workbook led to horrendous performance. As of version 1.6, it was therefore decided to read in a sheet at a time. Every call to getSheet() frees up all the objects currently allocated in the current sheet and then reads in all the data from the next sheet. This alleviated the problems which previously occurred, but it does however assume that the giant size workbooks are spread over several sheets - if not, performance problems and OutOfMemoryExceptions may still occur. 

A consequence of this is that if you are using the API to constantly flick between sheets in a large workbook, then this will result in adverse performance because every call to getSheet is causing ExcelRead to re-read and re-deduce all the data. It is recommended that ,if possible, the client application should do all their processing necessary on one sheet before progressing to the next. 

The method getSheets(), which returns an array of all sheets, will still attempt to hold all sheets in memory at the same time. Use of this method for very large spreadsheets is not recommended.