Convert Excel file to CSV
[234 byte] By [mpanga] at [2007-11-27 8:24:44] 
i would like to know what would be the best way to convert an excel file to csv format (automatically), besides reading in the file (via POI) row by row, and process cell by cell, then write to the plain text file? Please help!
Writing a VB script, I suppose.
CeciNEstPasUnProgrammeura at 2007-7-12 20:13:55 >
Save As within Excel?
ejpa at 2007-7-12 20:13:55 >
what if it ought to done in java only? or shell script
mpanga at 2007-7-12 20:13:55 >
What's the reason for that restriction? Does someone prefer writing new code to using code that already exists?
ejpa at 2007-7-12 20:13:55 >
> what if it ought to done in java only? - I need to tighten a screw.- Use a screwdriver.- What if it ought to be done with pliers only?Which answer do you expect?> or shell scriptWell, VB can be run from the shell.
CeciNEstPasUnProgrammeura at 2007-7-12 20:13:55 >
> i would like to know what would be the best way to
> convert an excel file to csv format (automatically),
yes.
> besides reading in the file (via POI) row by row, and
> process cell by cell, then write to the plain text
> file? Please help!
that's the way.
jwentinga at 2007-7-12 20:13:55 >
The POI HSSF API is rather more powerful than that. But until the OP reads its Javadoc for himself he will never discover that.
ejpa at 2007-7-12 20:13:55 >
Java Essentials New Topic
Java Essentials Hot Topic
Java Essentials
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding