i have tried lots of different methods to achieve the end result which is a text file that is the same as that produced by microsoft excel 2007
initially i have an application that creates spreadsheets (xls) using the jxl library which works fine i then have to open the xls and save it as other types e.g. tab delimited, the aim is to do away with this necessary step and just create a text file directly and be able to save these files should i need to check anything they would need to be opened by excel
so i set about placing \t in the
string by supply a string with it in it like this fileloader("anotherTest","abc\t"+"def");
the result is abc def written to the anotherTest file on the C drive. if you observe the results using microsoft
word the tab is displayed as the little arrow as you might expect, however if you attempt to open the file with excel the data is displayed in one cell with a small question mark in between the two strings instead of two adjacent cells, i have also reversed the process by typing the data into two adjacent cells and saving it and then displaying in word only to see a perfect match so why does the
java generated file not open in excel correctly?
i have look at lots of examples and as yet none have shown me how to create the same type of file that excel creates
i need to have tab files that excel can read and a tab delimited file that can be uploaded to a website this is a simplified version as the real data occupies several columns on the spreadsheet