private void button6_Click(object sender, EventArgs e)
{
string outdat = "1234.火柴";
string[] outarry = new string[50];
string[] intdat = new string[50];
string[] number = new string[50];
string[] letter = new string[50];
byte[] bytes;
OpenFileDialog exceldat = new OpenFileDialog();
exceldat.Filter = "Text File(*.txt)|*.txt";
if (exceldat.ShowDialog() != DialogResult.OK)
{
return;
}
string pathname = exceldat.FileName;
StreamReader sr = new StreamReader(pathname);
string strLine = sr.ReadLine();
string[] colors = Convert.ToString(strLine).Split(',');
//int rowNum = 1;
object missing = System.Reflection.Missing.Value;
Excel.Application app = new Excel.Application();
app.Application.Workbooks.Add(true);
Workbook book = (Workbook)app.ActiveWorkbook;
Worksheet sheet = (Worksheet)book.ActiveSheet;
string[] tempArr = new string[colors.Length];
string[] oldarr = new string[colors.Length];
try
{
if (colors.Length != 0)
{
for (int k = 0; k < colors.Length; k++)
{
outdat = colors[k].ToString();
number[k] = System.Text.RegularExpressions.Regex.Replace(outdat, @"[^0-9]+", "");
letter[k] = (System.Text.RegularExpressions.Regex.Replace(outdat, @"[^A-Za-z]", "")).ToLower();//将大写字母转小字母
for (int i = 0; i < colors[k].Length; i++)
{
bytes = Encoding.Default.GetBytes(outdat.Substring(i, 1));
if (bytes.Length == 2)
{
intdat[k] = intdat[k] + outdat.Substring(i, 1);
}
}
}
}
else
{
return;
}
for (int numbers = 1; numbers <= colors.Length; numbers++)//numbers=1,只能设置为1
{
sheet.Cells[1, 1] = "序号";
sheet.Cells[1, 2] = "中药名称";
sheet.Cells[1, 3] = "重量";
sheet.Cells[1, 4] = "单位";
sheet.Cells[numbers+1, 1] = numbers;
sheet.Cells[numbers+1 ,2] = intdat[numbers-1];
sheet.Cells[numbers+1, 3] = number[numbers-1];
sheet.Cells[numbers+1, 4] = letter[numbers-1];
}
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Excel Workbook(*.xlsx)|*.xlsx";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
//book.Save();
book.SaveAs(saveFileDialog.FileName);
book.Close();
app.Quit();
MessageBox.Show("转化成功!");
}
else
{
book.Close();
app.Quit();
MessageBox.Show("转化失败!");
}
}
catch
{
MessageBox.Show("数据读取失败!");
}
}
生成效果图