I created a servlet that queries a database and writes the output to an excel spread sheet. The problem I am having is that it appends the data instead of over writing the content. I am using CounterHome.seek(CounterHome.length());
CounterHome.writeBytes(data);
to hold the ResultSet and outputting the results. I wish to overwrite the data each time I am run the query. It sort of acts like a temporary storage. Please help if you can.
Thanks
Vic
CounterHome.writeBytes(data);
to hold the ResultSet and outputting the results. I wish to overwrite the data each time I am run the query. It sort of acts like a temporary storage. Please help if you can.
Thanks
Vic