Typo, in the last sentence, should be "if the *are* simple ...."
On Thu, Jan 30, 2014 at 11:09 AM, Richard Kettelerij < [email protected]> wrote: > Hi, > > Welcome to the Camel community! > > Depending on where the Excel files resides you can use the Camel file > component (http://camel.apache.org/file2) or FTP, SFTP, SMB etc > components to pickup the Excel file. > > Now you need to process the file. Currently there's no out-of-the-box > dataformat (http://camel.apache.org/dataformat) in Camel for parsing > Excel files. But you can still do it by using a processor (e.g. > http://camel.apache.org/tutorial-business-partners.data/ExcelConverterBean.java). > Take a look at Apache POI for parsing Excel files (http://poi.apache.org > ). > > After parsing you end up with a bunch of POJO's that you can route through > Camel an persist in the database using the Camel JDBC, JPA or MyBatis > components. > > Note: If the Excel files aren't simple (just one worksheet) you might want > to consider just exporting the Excel files to CSV (easily done from Excel) > and processing the CSV with Camel. CSV is just a text format and Camel has > multiple components to process it (Bindy, or CSV > http://camel.apache.org/csv.html). > > Kind regards, > Richard > > > On Thu, Jan 30, 2014 at 9:12 AM, Wolpe1990 <[email protected]> wrote: > >> Hi, >> at first sry for my bad english... >> I have a little problem. >> I`m a trainee in a german company because i`m in a education... >> Ok now let's talk about my little problem. >> I have to write a program who imports a Excelfile (in the Excelfile are >> customerdatas (adress,name,etc) >> After the import i have to write the datas in a database.... >> Ok thats my job. >> I'm a beginner, so my question is what jar files i need from camel? Or at >> all what exactly i need of the Apache Camel? >> It would be gratefull if you can help me!! >> Thank you very much in advance! >> >> >> >> -- >> View this message in context: >> http://camel.465427.n5.nabble.com/Excelfile-import-in-java-and-transfer-in-a-Database-tp5746612.html >> Sent from the Camel - Users mailing list archive at Nabble.com. >> > >
