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]
