使用 C# 和 VB.NET 在 Excel 中將文字拆分為列

Spread.NET by MESCIUS is a versatile spreadsheet component for .NET applications, enabling developers to integrate Excel-compatible functionalities into Windows Forms, WPF, ASP.NET, and Blazor. With features like advanced data visualization, pivot tables, conditional formatting, and customizable formulas, Spread.NET handles large data sets efficiently and allows seamless Excel import/export. This tool is ideal for applications needing robust data analytics and reporting, such as financial software and business intelligence solutions, enhancing user experience with a familiar spreadsheet interface.

In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz shows you how to use Spread.NET to efficiently manage data within your applications when you encounter text that needs to be split into columns. Steps include:

• Programmatically splitting Text to Columns in C# and VB.NET:
  • TextToColumns Method
  • TEXTSPLIT Function
• Invoking the Text to Columns Wizard in WinForms Apps:
  • Programmatically Invoking the Convert Text to Columns Wizard
  • No-Code Solution with Spread Designer and Ribbon Control

Detailed sample code is included that you can use as a foundation for your applications.

Read the full blog to get started using this powerful capability of Spread.NET.

Spread.NET is licensed per developer and is available as a Perpetual License with a 12 month support and maintenance subscription. We can supply any Spread.NET license including new licenses, maintenance renewals, and upgrade licenses. See our Spread.NET licensing page for full details.

For more information, visit our Spread.NET product page.