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/
精彩评论