need to filter data from log files and insert into xl sheet using POI? how Is there any interface between these two which can support this feature. Earlier i was getting data from database and one by one kept it in POI so that xl sheet can be generated easily, there resulset.getcolumn() helped getting data one by one. Now someone has filtered data using some logic and kept it in GUI format using TableModel i.e. javax.swing.table.TableModel; here it able to hold values easily. But i don't have option to use anything like TableModel. If anyone has worked on any similar stuff please suggest me something useful. any supporting API. thanks. vijendra
I don't know of anything supporting this directly, but if the log file has a somewhat regular format then you might be able to use the java.util.Scanner or java.util.BreakIterator classes to loop over the fields of an entry. That would allow you to insert data into the sheet row by row. [ November 24, 2006: Message edited by: Ulf Dittmer ]
What's keeping you from using the TableModel? You can use the model without building a GUI.
A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
subject: need to filter data from log files and insert into xl sheet using POI?
0
