• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Devaka Cooray
  • Ron McLeod
  • paul wheaton
Saloon Keepers:
  • Tim Moores
  • Piet Souris
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Frits Walraven
  • Scott Selikoff

need to filter data from log files and insert into xl sheet using POI?

 
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Rancher
Posts: 43028
76
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 ]
 
(instanceof Sidekick)
Posts: 8791
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What's keeping you from using the TableModel? You can use the model without building a GUI.
 
Their achilles heel is the noogie! Give them noogies tiny ad!
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic