using System;
using System.Collections.Generic;
using System.IO;
using Microsoft.Office.Interop.Excel;
using OfficeOpenXml;
namespace demo1
{
class Program
{
static void Main(string[] args)
{
//定义字符串
string input = "艾伦,17,男"; // 将这里替换为包含字符串的长字符串
List<string> list = ExtractStrings(input);
SaveToExcel(list);
Console.WriteLine("保存成功");
}
private static void SaveToExcel(List<string> list)
{
//允许在非商业用途的情况下使用Excelpackage
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
int rowSize = 3;
int rows = (int)Math.Ceiling((double)list.Count / rowSize);
ExcelPackage package = new ExcelPackage();
ExcelWorksheet workSheet = package.Workbook.Worksheets.Add("ExtractedStrings");
int rowIndex = 1;
wor
c#提取字符串到Excel中深度解析
于 2023-07-26 10:35:20 首次发布