privatevoidbutton3_Click(objectsender,EventArgse){//弹出保存文件对话框if(listBox1.Text!=null){SaveFileDialogsavefdalog=newSaveFileDialog();savefdalog.DefaultExt="xls";sav...
private void button3_Click(object sender, EventArgs e)
{ //弹出保存文件对话框
if (listBox1.Text != null)
{
SaveFileDialog savefdalog = new SaveFileDialog();
savefdalog.DefaultExt = "xls";
savefdalog.Filter = "Excel文件|*.xls";
savefdalog.Title = "保存为表格";
savefdalog.ShowDialog();
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Excel.Workbooks workbooks = (Excel.Workbooks)xlApp.Workbooks;
Excel.Workbook workbook = (Excel.Workbook)workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets (1);
for (int i = 0; i < listBox1.Items.Count; i++)
{
string sh;
sh = listBox1.Items[i].ToString ();
worksheet.Cells(i, 1) = sh.ToString();
}
}
展开