将文本转换为列

将文本转换为列

您可以使用 Microsoft Excel 将文本转换为列。此功能可从数据工具在下面数据标签。为了将一列的内容拆分为多列，数据应包含特定的分隔符，例如逗号（或任何其他字符），Microsoft Excel 将一个单元格的内容拆分为多个单元格。 Aspose.Cells 也通过[文本到列](https://reference.aspose.com/cells/python/asposecells.api/cells#textToColumns(int,%20int,%20int,%20com.aspose.cells.TxtLoadOptions)） 方法。下面的代码片段演示了使用[文本到列](https://reference.aspose.com/cells/python/asposecells.api/cells#textToColumns(int,%20int,%20int,%20com.aspose.cells.TxtLoadOptions)方法通过将文本转换为以空格作为分隔符的列。

output_directory = "Examples/SampleFiles/OutputDirectory/"

# Create Workbook
workbook = Workbook()

# Access the first worksheet
worksheet = workbook.getWorksheets().get(0)

# Add people name in column A. Fast name and Last name are separated by space.
worksheet.getCells().get("A1").putValue("John Teal")
worksheet.getCells().get("A2").putValue("Peter Graham")
worksheet.getCells().get("A3").putValue("Brady Cortez")
worksheet.getCells().get("A4").putValue("Mack Nick")
worksheet.getCells().get("A5").putValue("Hsu Lee")

# Create text load options with space as separator.
txtLoadOptions = TxtLoadOptions()
txtLoadOptions.setSeparator(' ')

# Split the column A into two columns using TextToColumns() method.
# Now column A will have first name and column B will have second name.
worksheet.getCells().textToColumns(0, 0, 5, txtLoadOptions)

# Save the excel file.
workbook.save(output_directory + "outputTextToColumns.xlsx")