Thanks, Jim. Actually the data file with .rpt as suffix I want to read into Java is automatically generated by some mesurement tool, and it looks like a report with head and some statistical information of the measurement data. This data file(.rpt) can be opened by Excel or wordpad. (the seperator between each data point in the data session is |)
By manually importing the .rpt file into excel spreadsheet(choosing | as seperator) we can let each data point and string sit in one cell, and POI's HSSF can read this kind of Excel spreadsheet. So my problem boils down to how to automate the reading of .rpt file into Java without any manual preprocessing.( can we automate the step of importing .rpt file into Excel by choosing | as seperator?) Really appreciate your kind help. (I can send you the .rpt file if it is appropriate) Thanks again, Best, Charlie On Sun, 29 Aug 2004 12:04:15 -0400, Jim Cobban <[EMAIL PROTECTED]> wrote: > You should not use the .xls file suffix for anything other than a file in > Excel format. If you need a different file format you need to give it a > different file suffix. There are already two standard text formats for > representing spreadsheets: > > Comma Separated Values (.csv) > Tab Separated Values (.txt) > > If you have control over the creation of the text input files I would > recommend that you use one of the above formats instead of inventing your > own. All spreadsheet programs are capable of importing and exporting those > two formats. > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
