using Spire.Xls;
namespace SplitData_XLS
{
class Program
{
static void Main(string[] args)
{
//创建Workbook，加载Excel测试文档
Workbook book = new Workbook();
book.LoadFromFile("sample.xlsx");
//获取第一个工作表
Worksheet sheet = book.Worksheets[0];
//从第2行数据遍历到最后一行
string[] splitText = null;
string text = null;
for (int i = 1; i < sheet.LastRow; i++)
{
text = sheet.Range[i + 1, 1].Text;
//分割按逗号作为分隔符的数据列
splitText = text.Split(',');
//保存被分割的数据到数组，数组项写入列
for (int j = 0; j < splitText.Length; j++)
{
sheet.Range[i + 1, 1 + j + 1].Text = splitText[j];
}
}
//保存并打开文档
book.SaveToFile("result.xlsx", ExcelVersion.Version);
System.Diagnostics.Process.Start("result.xlsx");
}
}
}
