Hi,
i wanted a code in java where we can export the text file with delimiters to an excel sheet

Well you could write a program to convert the column delimiters to 'commas' and row delimiter to line feed i.e. convert the file to a CSV format, which Excel can read.

However if you want to convert the file to the Excel Proprietary format (XLS) take a look at Apache POI.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.