Tag Archives: Java API to Split Text to Column in Excel

MS Excel provides the Text to Columns feature to split the text into multiple columns. The splitting can be based on a blank space, a comma, a special character, etc. In order to automate the feature, this article covers how to perform Excel's Text to Columns from within your Java applications. The step-by-step guide and code sample will show you how to split text in a column in an Excel worksheet.