求最简洁的的把数据导出到Excel的方法 用户点击导出按钮弹出一个对话框,给用户新建一个excel文件名,然后把"abc123"写入到该文件的第一行第一列中。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 那么你就建一个文本文件, 写入abc123, 然后把文件名存成*.xls就行 我是要导出DataTable,只是对导出excel不熟,所以要个简洁的好上手 System.Reflection.Missing miss = null; ; Excel.ApplicationClass m_objExcel = null; ; Excel.Workbooks m_objBooks = null; Excel.Workbook m_objBook = null; Excel.Worksheet m_objSheet = null; Excel.Range ER = null; this.Refresh(); try { miss = System.Reflection.Missing.Value; m_objExcel = new Excel.ApplicationClass(); m_objExcel.Visible = false; m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks; m_objBook = (Excel.Workbook)(m_objBooks.Add(miss)); m_objSheet = (Excel.Worksheet)m_objBook.ActiveSheet; ER = m_objSheet.get_Range((object)"A1", System.Reflection.Missing.Value); ER.Value2 = "Last Name"; ER.ColumnWidth = 12; ER = m_objSheet.get_Range((object)"B1", System.Reflection.Missing.Value); ER.Value2 = "Frst Name"; ER.ColumnWidth = 15; ER = m_objSheet.get_Range((object)"C1", System.Reflection.Missing.Value); ER.Value2 = "Address"; ER.ColumnWidth = 35; ER = m_objSheet.get_Range((object)"D1", System.Reflection.Missing.Value); ER.Value2 = "City/County"; ER.ColumnWidth = 15; ER = m_objSheet.get_Range((object)"E1", System.Reflection.Missing.Value); ER.Value2 = "State"; ER.ColumnWidth = 10; ER = m_objSheet.get_Range((object)"F1", System.Reflection.Missing.Value); ER.Value2 = "ZipCode"; ER.ColumnWidth = 12; ER = m_objSheet.get_Range((object)"G1", System.Reflection.Missing.Value); ER.Value2 = "Phone"; ER.ColumnWidth = 15; m_objSheet.get_Range("A1", "G1").Font.Bold = true; //m_objExcel.get_Range("G",miss).Font. m_objSheet.get_Range("A1", "G1").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter; //m_objBook.SaveAs(SaveFile.FileName.Trim(), miss, miss, miss, miss, miss, Excel.XlSaveAsAccessMode.xlNoChange, miss, miss, miss, miss, miss); for (int i = 2; i < this.lvResult.Items.Count + 2; i++) { //m_objExcel.Cells[i, 1] = this.lvResult.Items[i - 2].SubItems[0].Text.ToString(); m_objExcel.Cells[i, 1] = this.lvResult.Items[i - 2].SubItems[1].Text.ToString().Trim(); m_objExcel.Cells[i, 2] = this.lvResult.Items[i - 2].SubItems[2].Text.ToString().Trim(); m_objExcel.Cells[i, 3] = this.lvResult.Items[i - 2].SubItems[3].Text.ToString().Trim(); m_objExcel.Cells[i, 4] = this.lvResult.Items[i - 2].SubItems[4].Text.ToString().Trim(); m_objExcel.Cells[i, 5] = this.lvResult.Items[i - 2].SubItems[5].Text.ToString().Trim(); m_objExcel.Cells[i, 6] = "'" + this.lvResult.Items[i - 2].SubItems[6].Text.ToString().Trim(); m_objExcel.Cells[i, 7] = this.lvResult.Items[i - 2].SubItems[7].Text.ToString().Trim(); } try { m_objBook.SaveAs(SavePath, miss, miss, miss, miss, miss, Excel.XlSaveAsAccessMode.xlNoChange, miss, miss, miss, miss, miss); } 工作流引擎的实质是什么 请教高手,如何用C#做QQ头象来信息时的闪动? 不知道这个代码对吗?请指教 类内容的比较 关于一个正则表达式的问题!!提取url后缀参数? string输出后这样的字符“↑┓”是何编码? 高手幫幫忙呀,一個很棘手的關於DATAGRID的問題(web) c#FTP收集数据,求集思广益 怎样把char类型转换成两个byte 谁用c/s(Socket)结构,上传文件到服务器,把文件保存到服务器硬盘的C#源代码?多谢,给50分!:) 急急急....进来帮帮忙啊!~~~~ 50分相赠,一道面试题!
Excel.ApplicationClass m_objExcel = null; ;
Excel.Workbooks m_objBooks = null;
Excel.Workbook m_objBook = null;
Excel.Worksheet m_objSheet = null;
Excel.Range ER = null;
this.Refresh(); try
{
miss = System.Reflection.Missing.Value;
m_objExcel = new Excel.ApplicationClass();
m_objExcel.Visible = false;
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel.Workbook)(m_objBooks.Add(miss));
m_objSheet = (Excel.Worksheet)m_objBook.ActiveSheet; ER = m_objSheet.get_Range((object)"A1", System.Reflection.Missing.Value);
ER.Value2 = "Last Name";
ER.ColumnWidth = 12;
ER = m_objSheet.get_Range((object)"B1", System.Reflection.Missing.Value);
ER.Value2 = "Frst Name";
ER.ColumnWidth = 15;
ER = m_objSheet.get_Range((object)"C1", System.Reflection.Missing.Value);
ER.Value2 = "Address";
ER.ColumnWidth = 35;
ER = m_objSheet.get_Range((object)"D1", System.Reflection.Missing.Value);
ER.Value2 = "City/County";
ER.ColumnWidth = 15;
ER = m_objSheet.get_Range((object)"E1", System.Reflection.Missing.Value);
ER.Value2 = "State";
ER.ColumnWidth = 10;
ER = m_objSheet.get_Range((object)"F1", System.Reflection.Missing.Value);
ER.Value2 = "ZipCode";
ER.ColumnWidth = 12;
ER = m_objSheet.get_Range((object)"G1", System.Reflection.Missing.Value);
ER.Value2 = "Phone";
ER.ColumnWidth = 15;
m_objSheet.get_Range("A1", "G1").Font.Bold = true;
//m_objExcel.get_Range("G",miss).Font.
m_objSheet.get_Range("A1", "G1").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
//m_objBook.SaveAs(SaveFile.FileName.Trim(), miss, miss, miss, miss, miss, Excel.XlSaveAsAccessMode.xlNoChange, miss, miss, miss, miss, miss); for (int i = 2; i < this.lvResult.Items.Count + 2; i++)
{
//m_objExcel.Cells[i, 1] = this.lvResult.Items[i - 2].SubItems[0].Text.ToString();
m_objExcel.Cells[i, 1] = this.lvResult.Items[i - 2].SubItems[1].Text.ToString().Trim();
m_objExcel.Cells[i, 2] = this.lvResult.Items[i - 2].SubItems[2].Text.ToString().Trim();
m_objExcel.Cells[i, 3] = this.lvResult.Items[i - 2].SubItems[3].Text.ToString().Trim();
m_objExcel.Cells[i, 4] = this.lvResult.Items[i - 2].SubItems[4].Text.ToString().Trim();
m_objExcel.Cells[i, 5] = this.lvResult.Items[i - 2].SubItems[5].Text.ToString().Trim();
m_objExcel.Cells[i, 6] = "'" + this.lvResult.Items[i - 2].SubItems[6].Text.ToString().Trim();
m_objExcel.Cells[i, 7] = this.lvResult.Items[i - 2].SubItems[7].Text.ToString().Trim();
} try
{
m_objBook.SaveAs(SavePath, miss, miss, miss, miss, miss, Excel.XlSaveAsAccessMode.xlNoChange, miss, miss, miss, miss, miss);
}