你的位置:首页 > ASP.net教程

[ASP.net教程]Csharp: Create Excel Workbook or word from a Template File using aspose.Word 14.5 and aspose.Cell 8.1


winform:

/// <summary>    ///     /// </summary>    /// <param name="sender"></param>    /// <param name="e"></param>    private void btnGenWord_Click(object sender, EventArgs e)    {      Dictionary<string, string> dictSource = new Dictionary<string, string>();      dictSource.Add("NO", "T0001");      dictSource.Add("INDUSTRY", "捷为工作室");      dictSource.Add("NAME", "塗聚文");      string templateFile =("Templates/Templates.doc");      Aspose.Words.Document doc = new Aspose.Words.Document(templateFile);      //使用文本方式替换      foreach (string name in dictSource.Keys)      {        doc.Range.Replace(name, dictSource[name], true, true);      }      #region 使用书签替换模式      Aspose.Words.Bookmark bookmark = doc.Range.Bookmarks["SEX"];      if (bookmark != null)      {        bookmark.Text = "男";      }      bookmark = doc.Range.Bookmarks["TEL"];      if (bookmark != null)      {        bookmark.Text = "13824350518*";      }      #endregion            doc.Save("testAdvice"+DateTime.Now.ToString("yyyyMMddHHmmssfff")+".docx",Aspose.Words.SaveFormat.Docx);    }    /// <summary>    ///     /// </summary>    /// <param name="sender"></param>    /// <param name="e"></param>    private void btnGenExcel_Click(object sender, EventArgs e)    {      Dictionary<string, string> dictSource = new Dictionary<string, string>();      dictSource.Add("NO", "T0001");      dictSource.Add("INDUSTRY", "捷为工作室");      dictSource.Add("NAME", "塗聚文");      string templateFile = ("Templates/Templates.xls");      WorkbookDesigner designer = new WorkbookDesigner();      //designer.Workbook.FileName=templateFile;      Aspose.Cells.Workbook work = new Workbook(templateFile);      designer.Workbook.Copy(work);        Aspose.Cells.Worksheet worksheet = designer.Workbook.Worksheets[0];      worksheet.Name = "geovindu";      //使用文本替换      foreach (string name in dictSource.Keys)      {        worksheet.Replace(name, dictSource[name]);      }      //使用绑定数据方式替换      designer.SetDataSource("SEX", "男");      designer.SetDataSource("TEL", "13824350518*");      designer.Process();         designer.Workbook.Save("testAdvice.xlsx",Aspose.Cells.SaveFormat.Xlsx);    }

  

webform:

/// <summary>    /// https://github.com/aspose-words/Aspose.Words-for-.NET    /// https://asposewords.codeplex.com/    /// https://asposednn.codeplex.com/    /// </summary>    /// <param name="sender"></param>    /// <param name="e"></param>    protected void btnGenWord_Click(object sender, EventArgs e)    {      Dictionary<string, string> dictSource = new Dictionary<string, string>();      dictSource.Add("NO", "T0001");      dictSource.Add("INDUSTRY", "捷為工作室");      dictSource.Add("NAME", "涂聚文");      string templateFile = Server.MapPath("./Templates/Templates.doc");      Aspose.Words.Document doc = new Aspose.Words.Document(templateFile); //veb: 14.5      //使用文本方式替换      foreach (string name in dictSource.Keys)      {        doc.Range.Replace(name, dictSource[name], true, true);      }      #region 使用书签替换模式      Aspose.Words.Bookmark bookmark = doc.Range.Bookmarks["SEX"];      if (bookmark != null)      {        bookmark.Text = "男";      }      //书签方式      bookmark = doc.Range.Bookmarks["TEL"];      if (bookmark != null)      {        bookmark.Text = "13824350518*";      }      #endregion      string savefile = Server.MapPath("./DuFile/geovindu.docx");      doc.Save(savefile, Aspose.Words.SaveFormat.Docx);      Response.Clear();      Response.Buffer = true;      //以字符流的形式下载文件         string fileName = "geovindu.docx"; //下載文件名稱      FileStream fs = new FileStream(savefile, FileMode.Open);      byte[] bytes = new byte[(int)fs.Length];      fs.Read(bytes, 0, bytes.Length);      fs.Close();      Response.ContentEncoding = System.Text.Encoding.UTF8;      Response.HeaderEncoding = System.Text.Encoding.UTF8;           Response.ContentType = "application/octet-stream";      //通知浏览器下载文件而不是打开         Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8));      //Response.AddHeader("Content-Length", fs.Length.ToString());      Response.BinaryWrite(bytes);      Response.Flush();      Response.End();    }    /// <summary>    /// http://aspose.github.io/    /// https://github.com/asposemarketplace/Aspose_for_Open