Hello, I would like to convert all sheets of an Excel document into tab-delimited files via Java.
Something like what I have by doing "File"/"Save as"/"tab delimited" on every sheets in Excel. I don't want to do it manually because I will have really many sheets. Does-it exist a class able to do that? If no, I made one, but I have a problem. I've a loop iterating on the sheet. For every sheet, I've a loop iterating on the rows. For every row, I've a loop iterating on the cell. For every cell, I append the value and a \t in a StringBuffer and after that a \n. Let me explain the problem now. I don't want to know if it is a Numeric, Date or Formula. I just would like a String containing what the user see in Excel. I didn't find a way to do that. I know I can convert Numeric to String, Date to String but I will never retrieve exactly what the user wrote. And what about Formula? I don't thing to convert is the best solution. I need a POI less intelligent that will not interpret cell values :-) Best regards, Marc
