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. ----- Original Message ----- From: "Charlie" <[EMAIL PROTECTED]> To: "POI Users List" <[EMAIL PROTECTED]> Sent: Saturday, August 28, 2004 8:49 PM Subject: Reading excel file with "|" as the seperator > Hi, All, > > I am using POI to automate the reading of some data files in excel > format. It is > easy for the file with each data/string in one cell, but it seems not > straightforward to read some data file with | as the seperator(the > data/string do not sit in one cell, and the whole file format looks > like a plain text file with | as seperator between datas but the file > is still .xls). > > Do you guys know how to automate the reading of such data files > without pre-processing? (e.x. first change the .xls file to .txt file, > and import the .txt file to another .xls, then each data/string will > sit in one cell in the new .xls) > > Thanks in advance > > Best > Charlie > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
