How to write into excel file using ant script

Question

I have a excel file, with some column like this Name DateTime (if value datetime existing then do not thing) Jonh 16/07/2015 9:30 (dd/MM/yyyy hh:mm) => date in system Jonh 16/07/2015 10:30

The question : are there any way to write some sciprt ant to update excel file with two properties : Name and DateTime When i run script ant, it's could be write new next row Jond 16/07/2015 11:30 Thanks.

Jonh 16/07/2015 9:30 (dd/MM/yyyy hh:mm) => date in system – Phai Vv Jul 16 '15 at 03:48 — Phai Vv, Jul 16 '15 at 03:48

score 1 · Answer 1 · answered Jul 16 '15 at 14:56

1

I would suggest using an Excel manipulation library such as Apache POI called from a custom task or a JDBC driver for Excel, using the SQL task to update the XLS file.

answered Jul 16 '15 at 14:56

Stavr00

3,219
1
16
28

score 1 · Answer 2 · edited May 23 '17 at 11:51

1

This is not a trivial problem to solve. The following example uses a groovy script leveraging Apache POI to read/write Excel files:

edited May 23 '17 at 11:51

Community

1
1

answered Jul 16 '15 at 21:00

Mark O'Connor

76,015
10
139
185

How to write into excel file using ant script

2 Answers2