开发者

Is there any API that takes an Excel file and converts it to a CSV file using Java?

I have 200,000 or more records in an Excel file. If I tri开发者_如何转开发ed to read records row by row and create a CSV file it's very costly as well as time consuming. Is there any API that can help me with that?


There are several frameworks out there, if you have a look.

For example, you can try:

  • Apache POI (example)
  • JExcel (example)


This seems to be the same question as How to import an Excel file into MySQL using ODBC in Java?

What has changed? If you want to write to a CSV file you should use a CSV library such as OpenCSV: http://opencsv.sourceforge.net/

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜