Excel sheet parsing

Question

I'm trying to parse one Excel spreadsheet which has a field named "Status" (possible values PASS/FAIL). I want the total no. of records for PASS status and that of FAIL status.

Can anyone help me?

specifying which language may help.. – Ben Jan 12 '11 at 06:22 — Ben, Jan 12 '11 at 06:22

score 0 · Answer 1 · answered Jan 12 '11 at 06:27

0

Try apache POI http://poi.apache.org

answered Jan 12 '11 at 06:27

lweller

11,077
3
34
38

cant't we write a simple macro for this? – Anupriya Jan 12 '11 at 06:51
You mean a formula in a cell? – lweller Jan 12 '11 at 07:00
so I'm sorry but a can't help you further – lweller Jan 12 '11 at 07:44

Excel sheet parsing

1 Answers1