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. >
