请高人看下这段代码 c# 在创建excel sheet时为什么会失败? 单步调一下.把相应的sql语句考到SQL2000里面试试,可以成功执行吗? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 摘录:《程序员秘书》--源代码--目录及文件--读取Excel文件--生成一个Exel文件你直接用就行了立即成为编程经验丰富的程序员不是梦,详见:http://www.psec.net.cnprivate void button1_Click(object sender, EventArgs e){ try { SaveFileDialog SaveFileDialog1 = new SaveFileDialog(); SaveFileDialog1.Filter = "Excel文件(*.xls)|*.xls"; if (SaveFileDialog1.ShowDialog() == DialogResult.OK) { string[,] myData = { {"车牌号","类 型","品 牌","型 号","颜 色","附加费证号","车架号"}, {"浙KA3676","危险品","货车","铁风SZG9220YY","白","1110708900","022836"}, {"浙KA4109","危险品","货车","解放CA4110P1K2","白","223132","010898"}, {"浙KA0001A","危险品","货车","南明LSY9190WS","白","1110205458","0474636"}, {"浙KA0493","上普货","货车","解放LSY9190WS","白","1110255971","0094327"}, {"浙KA1045","普货","货车","解放LSY9171WCD","蓝","1110391226","0516003"}, {"浙KA1313","普货","货车","解放9190WCD","蓝","1110315027","0538701"}, {"浙KA1322","普货","货车","解放LSY9190WS","蓝","24323332","0538716"}, {"浙KA1575","普货","货车","解放LSY9181WCD","蓝","1110314149","0113018"}, {"浙KA1925","普货","货车","解放LSY9220WCD","蓝","1110390626","00268729"}, {"浙KA2258","普货","货车","解放LSY9220WSP","蓝","111048152","00320"}}; Excel.Application m_Excel = new Excel.Application();//创建一个Excel对象(同时启动EXCEL.EXE进程) m_Excel.SheetsInNewWorkbook = 2;//工作表为两个 Excel._Workbook m_Book = (Excel._Workbook)(m_Excel.Workbooks.Add(Missing.Value));//添加新工作簿 Excel._Worksheet m_Sheet = (Excel._Worksheet)(m_Book.Worksheets.get_Item(1));//读取工作表1 m_Sheet.Name = "车牌表";//给工作表1命名 m_Sheet.Cells[1, 4] = "普通报表";//第一行为报表名称 for (int i = 0; i < 11; i++)//逐行写入数据 { for (int j = 0; j < 7; j++) { m_Sheet.Cells[2 + i, 1 + j] = "'" + myData[i, j];//以单引号开头,表示该单元格为纯文本 } } m_Book.SaveAs(SaveFileDialog1.FileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); m_Book.Close(false, Missing.Value, Missing.Value); m_Excel.Quit(); m_Book = null; m_Sheet = null; m_Excel = null; MessageBox.Show(this, "Excel文件已经生成。", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception Mye) { MessageBox.Show(this, Mye.Message, "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } GC.Collect();//强制垃圾回收,否则EXCEL.EXE进程不能及时退出} 删除操作都失败了 应该和excel没有关系 确认一下你的文件位置 去掉你的try和catch,看一看系统提示的错误信息 自己跟踪调试一下吧..应该和excel没有什么关系.. 1.看看你的Excel文件是否生成2.看看你的Excel文件格式是否是纯Excel格式文件导入Excel可以查看http://www.wsoft.net/Index/Catalog53/225.aspx 如果文件生成了,你直接用企业管理器导入Excel文件,看能否成功!不成功说明格式有问题。 为什么不允许在winform中直接跨线程访问控件 VS2012 ,今天在 Win7 上试着安装,结果无数次失败! 请高人指点: 请问在WPF中如何给动态按钮添加单击事件呢?有什么快捷方式吗? 从stringbuilder中读取xml,里面有中文,怎么办? 门禁系统中的SN是做什么用的 DataGridView改Column名的问题 求正则表达式替换方法 如何获取ExecuteNonQuery里Select语句的值? 在form2保存的照片当时显示FORM2中 线程---数据采集----队列 foxpro dbf 转换foxpro 2.x dbf 用oledb报错 幫忙解決一個觸發器的問題
你直接用就行了
立即成为编程经验丰富的程序员不是梦,详见:http://www.psec.net.cnprivate void button1_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog SaveFileDialog1 = new SaveFileDialog();
SaveFileDialog1.Filter = "Excel文件(*.xls)|*.xls";
if (SaveFileDialog1.ShowDialog() == DialogResult.OK)
{
string[,] myData = {
{"车牌号","类 型","品 牌","型 号","颜 色","附加费证号","车架号"},
{"浙KA3676","危险品","货车","铁风SZG9220YY","白","1110708900","022836"},
{"浙KA4109","危险品","货车","解放CA4110P1K2","白","223132","010898"},
{"浙KA0001A","危险品","货车","南明LSY9190WS","白","1110205458","0474636"},
{"浙KA0493","上普货","货车","解放LSY9190WS","白","1110255971","0094327"},
{"浙KA1045","普货","货车","解放LSY9171WCD","蓝","1110391226","0516003"},
{"浙KA1313","普货","货车","解放9190WCD","蓝","1110315027","0538701"},
{"浙KA1322","普货","货车","解放LSY9190WS","蓝","24323332","0538716"},
{"浙KA1575","普货","货车","解放LSY9181WCD","蓝","1110314149","0113018"},
{"浙KA1925","普货","货车","解放LSY9220WCD","蓝","1110390626","00268729"},
{"浙KA2258","普货","货车","解放LSY9220WSP","蓝","111048152","00320"}}; Excel.Application m_Excel = new Excel.Application();//创建一个Excel对象(同时启动EXCEL.EXE进程)
m_Excel.SheetsInNewWorkbook = 2;//工作表为两个
Excel._Workbook m_Book = (Excel._Workbook)(m_Excel.Workbooks.Add(Missing.Value));//添加新工作簿
Excel._Worksheet m_Sheet = (Excel._Worksheet)(m_Book.Worksheets.get_Item(1));//读取工作表1
m_Sheet.Name = "车牌表";//给工作表1命名
m_Sheet.Cells[1, 4] = "普通报表";//第一行为报表名称
for (int i = 0; i < 11; i++)//逐行写入数据
{
for (int j = 0; j < 7; j++)
{
m_Sheet.Cells[2 + i, 1 + j] = "'" + myData[i, j];//以单引号开头,表示该单元格为纯文本
}
}
m_Book.SaveAs(SaveFileDialog1.FileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
m_Book.Close(false, Missing.Value, Missing.Value);
m_Excel.Quit();
m_Book = null;
m_Sheet = null;
m_Excel = null;
MessageBox.Show(this, "Excel文件已经生成。", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception Mye)
{
MessageBox.Show(this, Mye.Message, "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
GC.Collect();//强制垃圾回收,否则EXCEL.EXE进程不能及时退出
}
2.看看你的Excel文件格式是否是纯Excel格式文件
导入Excel可以查看
http://www.wsoft.net/Index/Catalog53/225.aspx