C# winform 导出导入Excel/Doc 完整实例教程 使用Aspose.Cells.dll——第二篇

C# winform 导出导入Excel/Doc 完整实例教程 使用Aspose.Cells.dll——第二篇

http://hi.baidu.com/%BA%CE%B3%B1/blog/item/6e6eae2f56ed70331e308966.html

 

Word导出

            //设置文件类型

            // saveFileDialog为一个对话框控件

            //如果没有人工具栏中拉，

//可以：SaveFileDialog saveFileDialog1=new SaveFileDialog();

            saveFileDialog1.Filter = "导出Excel (*.xls)|*.xls|Word (*.doc)|*.doc";

            saveFileDialog1.FilterIndex = 1;

            saveFileDialog1.RestoreDirectory = true;

            saveFileDialog1.CreatePrompt = true;

            saveFileDialog1.Title = "导出文件保存路径";

            //saveFileDialog1.ShowDialog();

            //string strName = saveFileDialog1.FileName;

 

            //设置默认文件类型显示顺序

            //saveFileDialog1.FilterIndex = 2;  

 

            //保存对话框是否记忆上次打开的目录

            saveFileDialog1.RestoreDirectory = true;

 

            //点了保存按钮进入

            if (saveFileDialog1.ShowDialog() == DialogResult.OK)

            {

                //获得文件路径

                string localFilePath = saveFileDialog1.FileName.ToString();

 

                //获取文件名，不带路径

                string fileNameExt = localFilePath.Substring(localFilePath.LastIndexOf("//") + 1);

 

                //获取文件路径，不带文件名

                string FilePath = localFilePath.Substring(0, localFilePath.LastIndexOf("//"));

 

                //给文件名前加上时间

                string newFileName = DateTime.Now.ToString("yyyyMMdd") + fileNameExt;

 

                //在文件名里加字符

                //saveFileDialog1.FileName.Insert(1,"dameng");  

                saveFileDialog1.FileName = FilePath + "//" + newFileName;

                System.IO.FileStream fs = (System.IO.FileStream)saveFileDialog1.OpenFile();//输出文件

                StreamWriter writer = new StreamWriter(fs);

                writer.Write("tttt");//这里就是你要导出到word的内容，内容是你什么你自已DIY

                writer.Flush();

                writer.Close();

                fs.Close();

}

导出datatable到excel

DataTable dt = null;

            if (ds_all.Tables[0] != null)

            {

                dt = ds_all.Tables[0];

            }

            else {

                MessageBox.Show("没有数据记录", "*^_^* 温馨提示信息", MessageBoxButtons.OK);

                return;

            }

//上面只是取datatable，你自己diy

            AsposeExcel tt = new AsposeExcel(saveFileDialog1.FileName, "");//不用模板, saveFileDialog1是什么？上面已经说过

            bool OK_NO = tt.DatatableToExcel(dt);

            if (OK_NO)

            {

                MessageBox.Show("导出成功", "*^_^* 温馨提示信息", MessageBoxButtons.OK);

 

            }

            else

            {

         }

 

下一篇，说导入。