formview导出到word

Question

formview导出到word,formview带分页功能,要求全部导出数据分页wordformview

Answer 1

你肯定有内存表吧。datatable.循环导出即可。
protected void WriteToExcel(DataTable table, string filepath)//查询结果导出Execl
        {
            try
            {
                System.IO.StreamWriter sw = new System.IO.StreamWriter(filepath, true, System.Text.Encoding.Default);
                object[] values = new object[table.Columns.Count];
                for (int i = 0; i < table.Columns.Count; ++i)
                {
                    sw.Write(table.Columns[i].Caption.ToString());
                    sw.Write('\t');
                }
                sw.Write("\r\n");
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    for (int j = 0; j < values.Length; ++j)
                    {
                        string xx = table.Rows[i][j].ToString();
                        sw.Write(xx);
                        sw.Write('\t');
                    }
                    sw.Write("\r\n");
                }
                sw.Flush();
                sw.Close();
                MessageBox.Show("成功导出[" + table.Rows.Count + "]行到！" + filepath);
            }
            catch
            {
                MessageBox.Show("导出Execl失败！");
            }
        }

Answer 2

SaveFileDialog sfd = new SaveFileDialog();
            sfd.Filter = "Excel(*.xls)|*.xls";
            if (sfd.ShowDialog() == DialogResult.OK)
            {
                WriteToExcel(exportdt, sfd.FileName.ToString());
            }
上面是从打开到保存