.net 把数据导出word

Question

具体要求就是 点击导出，自动打开word显示数据

Answer 1

 #region 导入excel 验证及导入方法
        //加载Excel 读取sheet表单
        public DataSet LoadDataSheetExcel(string filePath)
        {
            string strConn;
            strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";
            OleDbConnection OleConn = new OleDbConnection(strConn);
            OleConn.Open();
            System.Data.DataTable OleDsExcle = OleConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new[] { null, null, null, "Table" });
            OleConn.Close();
            DataSet ds = new DataSet();
            ds.Tables.Add(OleDsExcle);
            return ds;
        }
        //加载Excel 读取sheet表单数据
        public DataSet LoadDataSheetExcel(string filePath, string SheetName)
        {
            string strConn;
            strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";
            OleDbConnection OleConn = new OleDbConnection(strConn);
            OleConn.Open();
            String sql = "SELECT * FROM  [" + SheetName + "$]";//可是更改Sheet名称，比如sheet2，等等 
            OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);
            DataSet OleDsExcle = new DataSet();
            OleDaExcel.Fill(OleDsExcle, SheetName);
            OleConn.Close();
            return filterDs(OleDsExcle);        }
        public bool SaveDataTableToExcel(System.Data.DataTable excelTable, string filePath)
        {
            Microsoft.Office.Interop.Excel.Application app =
                new Microsoft.Office.Interop.Excel.ApplicationClass();
            try
            {
                app.Visible = false;
                Workbook wBook = app.Workbooks.Add(true);
                Worksheet wSheet = wBook.Worksheets[1] as Worksheet;
                if (excelTable.Rows.Count > 0)
                {
                    int row = 0;
                    row = excelTable.Rows.Count;
                    int col = excelTable.Columns.Count;
                    for (int i = 0; i < row; i++)
                    {
                        for (int j = 0; j < col; j++)
                        {
                            string str = excelTable.Rows[i][j].ToString();
                            wSheet.Cells[i + 2, j + 1] = str;
                        }
                    }
                }                int size = excelTable.Columns.Count;
                for (int i = 0; i < size; i++)
                {
                    wSheet.Cells[1, 1 + i] = excelTable.Columns[i].ColumnName;
                }
                //设置禁止弹出保存和覆盖的询问提示框    
                app.DisplayAlerts = false;
                app.AlertBeforeOverwriting = false;
                //保存工作簿    
                wBook.Save();
                //保存excel文件    
                app.Save(filePath);
                app.SaveWorkspace(filePath);
                app.Quit();
                app = null;
                return true;
            }
            catch (Exception err)
            {
                return false;
            }
            finally
            {
            }
        }        /// <summary>
        /// 过滤无用数据
        /// </summary>
        private DataSet filterDs(DataSet ds)
        {
            ArrayList NullClums = new ArrayList();
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                if (ds.Tables[0].Rows[0][i].ToString() == "")
                {
                    NullClums.Add(ds.Tables[0].Columns[i]);
                }
            }
            //过滤空列
            foreach (DataColumn dc in NullClums)
            {
                ds.Tables[0].Columns.Remove(dc);
            }            ArrayList FullClums = new ArrayList();
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                if (ds.Tables[0].Rows[0][i].ToString() != "")
                {
                    FullClums.Add(ds.Tables[0].Rows[0][i].ToString());
                }
            }
            System.Data.DataTable dt = fullDataDs(FullClums);
            //过滤空行
            ds.Tables[0].Rows.RemoveAt(0);
            for (int i = 0; i < FullClums.Count; i++)
            {
                ds.Tables[0].Columns[i].ColumnName = FullClums[i].ToString();
            }            List<DataRow> removelist = new List<DataRow>();
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                bool rowdataisnull = true;
                for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
                {                    if (ds.Tables[0].Rows[i][j].ToString().Trim() != "")
                    {                        rowdataisnull = false;
                    }                }
                if (rowdataisnull)
                {
                    removelist.Add(ds.Tables[0].Rows[i]);
                }            }
            for (int i = 0; i < removelist.Count; i++)
            {
                ds.Tables[0].Rows.Remove(removelist[i]);
            }            return ds;
        }        private System.Data.DataTable fullDataDs(ArrayList Cloums)
        {
            System.Data.DataTable dt = new System.Data.DataTable();
            for (int i = 0; i < Cloums.Count; i++)
            {
                DataColumn dc = new DataColumn(Cloums[i].ToString());
                dt.Columns.Add(dc);
            }            return dt;
        }        #endregion可以直接用

Answer 2

看你对导出word 的格式是否要求严谨，
然后你的导出word 的模版是不是一样的~
方法都是不同的

Answer 3

http://kb.cnblogs.com/a/1274987/

Answer 4

或者是这样子，我做一个word模版有很多格子，点击按钮，直接打开word我的模版，把数据显示在相应的位置上

Answer 5

点击按钮后， 打开word 不是下载那种，下载我会

Answer 6

<script type="text/javascript">
    function ExportExcel(tid) {
        var curTbl = document.getElementById(tid);        
        var oXL = new ActiveXObject("Excel.Application"); //创建ActiveXObject对象excel        
        var oWB = oXL.Workbooks.Add(); //获取workbook对象 
        var oSheet = oWB.ActiveSheet; //激活当前sheet 
        var sel = document.body.createTextRange(); 
        sel.moveToElementText(curTbl); //把表格中的内容移到TextRange中 
        sel.select(); //全选TextRange中内容 
        sel.execCommand("Copy"); //复制TextRange中内容 
        oSheet.Paste(); //粘贴到活动的EXCEL中 
        oXL.Visible = true; //设置excel可见属性 
    }
</script>