canvas教程

C# /windowForm/WPF/SilverLight里面操作Word帮助类提供给大家

字号+ 作者:H5之家 来源:H5之家 2016-07-25 10:01 我要评论( )

很多的程序都需要用到对word的操作,数据库里面的表需要一书面的形式展示出来,最近在的一个项 目里面用到了打印表单,在网上找了写资料整理出来和大家分废话不

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Drawing; using Word = Microsoft.Office.Interop.Word; using Microsoft.Office.Interop.Word; using System.Windows.Forms; namespace jiankong { public class WorldToos { #region - 属性 - private Microsoft.Office.Interop.Word._Application oWord = null; private Microsoft.Office.Interop.Word._Document odoc = null; private Microsoft.Office.Interop.Word._Document oDoc { get { if (odoc == null) { odoc = oWord.Documents.Add(ref Nothing, ref Nothing, ref Nothing, ref Nothing); } return odoc; } set { if (value != null) { odoc = value; } } } private object Nothing = System.Reflection.Missing.Value; public enum Orientation { 横板, 竖板 } public enum Alignment { 左对齐, 居中, 右对齐 } #endregion #region - 添加文档 - #region - 创建并打开一个空的word文档进行编辑 - public void OpenNewWordFileToEdit() { oDoc = oWord.Documents.Add(ref Nothing, ref Nothing, ref Nothing, ref Nothing); } - 创建新Word - public bool CreateWord(bool isVisible) { try { oWord = new Microsoft.Office.Interop.Word.Application(); oWord.Visible = isVisible; return true; } catch (Exception) { return false; } } public bool CreateWord() { return CreateWord(false); } #endregion #region - 打开文档 - public bool Open(string filePath, bool isVisible) { try { oWord.Visible = isVisible; object path = filePath; oDoc = oWord.Documents.Open(ref path, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing); return true; } catch (Exception) { return false; } } #endregion #region - 插入表格 - public bool InsertTable(DataTable dt, bool haveBorder, double[] colWidths) { try { object Nothing = System.Reflection.Missing.Value; int lenght = oDoc.Characters.Count - 1; object start = lenght; object end = lenght; //表格起始坐标 Microsoft.Office.Interop.Word.Range tableLocation = oDoc.Range(ref start, ref end); //添加Word表格 Microsoft.Office.Interop.Word.Table table = oDoc.Tables.Add(tableLocation, dt.Rows.Count, dt.Columns.Count, ref Nothing, ref Nothing); if (colWidths != null) { for (int i = 0; i < colWidths.Length; i++) { table.Columns[i + 1].Width = (float)(28.5F * colWidths[i]); } } ///设置TABLE的样式 table.Rows.HeightRule = Microsoft.Office.Interop.Word.WdRowHeightRule.wdRowHeightAtLeast; table.Rows.Height = oWord.CentimetersToPoints()); table.Range.Font.Size = 10.5F; table.Range.Font.Name = ; table.Range.Font.Bold = 0; table.Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter; table.Range.Cells.VerticalAlignment = Microsoft.Office.Interop.Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter; if (haveBorder == true) { //设置外框样式 table.Borders.OutsideLineStyle = Microsoft.Office.Interop.Word.WdLineStyle.wdLineStyleSingle; table.Borders.InsideLineStyle = Microsoft.Office.Interop.Word.WdLineStyle.wdLineStyleSingle; //样式设置结束 } for (int row = 0; row < dt.Rows.Count; row++) { for (int col = 0; col < dt.Columns.Count; col++) { table.Cell(row + 1, col + 1).Range.Text = dt.Rows[row][col].ToString(); } } return true; } catch (Exception e) { MessageBox.Show(e.ToString(), , MessageBoxButtons.OK, MessageBoxIcon.Error); return false; } finally { } } public bool InsertTable(DataTable dt, bool haveBorder) { return InsertTable(dt, haveBorder, null); } public bool InsertTable(DataTable dt) { return InsertTable(dt, false, null); } #endregion #region - 插入文本 - public bool InsertText(string strText, System.Drawing.Font font, Alignment alignment, bool isAftre) { try { Word.Range rng = oDoc.Content; int lenght = oDoc.Characters.Count - 1; object start = lenght; object end = lenght; rng = oDoc.Range(ref start, ref end); if (isAftre == true) { strText += ; } rng.Text = strText; rng.Font.Name = font.Name; rng.Font.Size = font.Size; if (font.Style == FontStyle.Bold) { rng.Font.Bold = 1; } //设置单元格中字体为粗体 SetAlignment(rng, alignment); return true; } catch (Exception) { return false; } } public bool InsertText(string strText) { , 10.5F, FontStyle.Bold), Alignment.左对齐, false); } #endregion #region - 设置对齐方式 - private Microsoft.Office.Interop.Word.WdParagraphAlignment SetAlignment(Range rng, Alignment alignment) { rng.ParagraphFormat.Alignment = SetAlignment(alignment); return SetAlignment(alignment); } private Microsoft.Office.Interop.Word.WdParagraphAlignment SetAlignment(Alignment alignment) { if (alignment == Alignment.居中) { return Word.WdParagraphAlignment.wdAlignParagraphCenter; } else if (alignment == Alignment.左对齐) { return Word.WdParagraphAlignment.wdAlignParagraphLeft; } else { return Word.WdParagraphAlignment.wdAlignParagraphRight; } } #endregion #region - 页面设置 - public void SetPage(Orientation orientation, double width, double height, double topMargin, double leftMargin, double rightMargin, double bottomMargin) { oDoc.PageSetup.PageWidth = oWord.CentimetersToPoints((float)width); oDoc.PageSetup.PageHeight = oWord.CentimetersToPoints((float)height); if (orientation == Orientation.横板) { oDoc.PageSetup.Orientation = Microsoft.Office.Interop.Word.WdOrientation.wdOrientLandscape; } oDoc.PageSetup.TopMargin = (float)(topMargin * 25);//上边距 oDoc.PageSetup.LeftMargin = (float)(leftMargin * 25);//左边距 oDoc.PageSetup.RightMargin = (float)(rightMargin * 25);//右边距 oDoc.PageSetup.BottomMargin = (float)(bottomMargin * 25);//下边距 } public void SetPage(Orientation orientation, double topMargin, double leftMargin, double rightMargin, double bottomMargin) { SetPage(orientation, 21, 29.7, topMargin, leftMargin, rightMargin, bottomMargin); } public void SetPage(double topMargin, double leftMargin, double rightMargin, double bottomMargin) { SetPage(Orientation.竖板, 21, 29.7, topMargin, leftMargin, rightMargin, bottomMargin); } #endregion #region - 插入分页符 - public void InsertBreak() { Word.Paragraph para; para = oDoc.Content.Paragraphs.Add(ref Nothing); object pBreak = (int)WdBreakType.wdSectionBreakNextPage; para.Range.InsertBreak(ref pBreak); } #endregion #region - 关闭当前文档 - public bool CloseDocument() { try { object doNotSaveChanges = Word.WdSaveOptions.wdDoNotSaveChanges; oDoc.Close(ref doNotSaveChanges, ref Nothing, ref Nothing); oDoc = null; return true; } catch (Exception) { return false; } } #endregion #region - 关闭程序 - public bool Quit() { try { object saveOption = Word.WdSaveOptions.wdDoNotSaveChanges; oWord.Quit(ref saveOption, ref Nothing, ref Nothing); return true; } catch (Exception) { return false; } } #endregion #region - 保存文档 - public bool Save(string savePath) { return Save(savePath, false); } public bool Save(string savePath, bool isClose) { try { object fileName = savePath; oDoc.SaveAs(ref fileName, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing); if (isClose) { return CloseDocument(); } return true; } catch (Exception) { return false; } } #endregion #region - 插入页脚 - public bool InsertPageFooter(string text, System.Drawing.Font font, WorldToos.Alignment alignment) { try { oWord.ActiveWindow.View.SeekView = Word.WdSeekView.wdSeekCurrentPageFooter;//页脚 oWord.Selection.InsertAfter(text); GetWordFont(oWord.Selection.Font, font); SetAlignment(oWord.Selection.Range, alignment); return true; } catch (Exception) { return false; } } public bool InsertPageFooterNumber(System.Drawing.Font font, WorldToos.Alignment alignment) { try { oWord.ActiveWindow.View.SeekView = WdSeekView.wdSeekCurrentPageHeader; oWord.Selection.WholeStory(); oWord.Selection.ParagraphFormat.Borders[WdBorderType.wdBorderBottom].LineStyle = WdLineStyle.wdLineStyleNone; oWord.ActiveWindow.View.SeekView = Word.WdSeekView.wdSeekMainDocument; oWord.ActiveWindow.View.SeekView = Word.WdSeekView.wdSeekCurrentPageFooter;//页脚 oWord.Selection.TypeText(); object page = WdFieldType.wdFieldPage; oWord.Selection.Fields.Add(oWord.Selection.Range, ref page, ref Nothing, ref Nothing); oWord.Selection.TypeText(); object pages = WdFieldType.wdFieldNumPages; oWord.Selection.Fields.Add(oWord.Selection.Range, ref pages, ref Nothing, ref Nothing); oWord.Selection.TypeText(); GetWordFont(oWord.Selection.Font, font); SetAlignment(oWord.Selection.Range, alignment); oWord.ActiveWindow.View.SeekView = Word.WdSeekView.wdSeekMainDocument; return true; } catch (Exception) { return false; } } #endregion #region - 字体格式设定 - public void GetWordFont(Microsoft.Office.Interop.Word.Font wordFont, System.Drawing.Font font) { wordFont.Name = font.Name; wordFont.Size = font.Size; if (font.Bold) { wordFont.Bold = 1; } if (font.Italic) { wordFont.Italic = 1; } if (font.Underline == true) { wordFont.Underline = Microsoft.Office.Interop.Word.WdUnderline.wdUnderlineNone; } wordFont.UnderlineColor = Microsoft.Office.Interop.Word.WdColor.wdColorAutomatic; if (font.Strikeout) { wordFont.StrikeThrough = 1;//删除线 } } #endregion #region - 获取Word中的颜色 - public WdColor GetWordColor(Color c) { UInt32 R = 0x1, G = 0x100, B = 0x10000; return (Microsoft.Office.Interop.Word.WdColor)(R * c.R + G * c.G + B * c.B); } #endregion XAML 文件: <Window x:Class= xmlns= xmlns:x= Title=Height=Width=> <Canvas Name=> <Canvas Height=Width=> <Canvas.Background> <ImageBrush ImageSource=Stretch=/> </Canvas.Background> <Ellipse Width=Height=Stroke=Canvas.Left=Canvas.Top=> </Ellipse> <Image Panel.ZIndex=Width=Source=Canvas.Left=Canvas.Top=/> <Label Canvas.Left=Canvas.Top=Content=Height=Name=FontSize=Width=/> <TextBox Canvas.Left=Canvas.Top=Height=Name=Width=Text=Background=Foreground=FontSize=/> <TextBlock Canvas.Left=Canvas.Top=Height=Name=Text=/> <TextBox Canvas.Left=Canvas.Top=Height=Name=Width=Text=Background=Foreground=FontSize=/> <TextBlock Canvas.Left=Canvas.Top=Height=Name=Text=/> <TextBox Canvas.Left=Canvas.Top=Height=Name=Width=Text=Background=Foreground=FontSize=/> <TextBlock Canvas.Left=Canvas.Top=Height=Name=Text=/> <TextBox Canvas.Left=Canvas.Top=Height=Name=Width=Text=Foreground=Background=FontSize=/> <TextBlock Canvas.Left=Canvas.Top=Height=Name=Text=/> </Canvas> <Canvas Background=> <Label Canvas.Left=Canvas.Top=Content=Height=Name=/> <Label Canvas.Left=Canvas.Top=Content=Height=Name=/> <Label Canvas.Left=Canvas.Top=Content=Height=Name=/> <Label Canvas.Left=Canvas.Top=Content=Height=Name=/> <TextBox Canvas.Left=Canvas.Top=IsReadOnly=Height=Name=Width=Text=/> <Label Canvas.Left=Canvas.Top=Content=Height=/> <Label Canvas.Left=Canvas.Top=Content=Height=Name=/> <Label Canvas.Left=Canvas.Top=Content=Height=Name=/> <Label Canvas.Left=Canvas.Top=Content=Height=Name=Width=/> <Button Canvas.Left=Canvas.Top=Content=Height=Name=Width=/> <Label Canvas.Left=Canvas.Top=Content=Height=Name=Width=/> </Canvas> <Label Canvas.Left=Canvas.Top=Content=Height=Name=Visibility=/> <Label Canvas.Left=Canvas.Top=Content=Height=Name=Visibility=/> <Label Canvas.Left=Canvas.Top=Content=Height=Name=Visibility=/> <TextBox Canvas.Left=Canvas.Top=Height=Name=Width=Text=Visibility=/> <Button Canvas.Left=Canvas.Top=Content=Height=Name=Width=Click=/> </Canvas> </Window> 后台cs 文件 [只是个测试Dome] private void button2_Click(object sender, RoutedEventArgs e) { penName = label3.Content.ToString();lastDate = label4.Content.ToString();begNUmber = Last.Content.ToString();spanNow = endNumber = shuiMoney = chkPenser = txtPenname.Text.ToString();dTime = DateTime.Now.Year.ToString() + + DateTime.Now.Month.ToString() + + ; WorldToos WordPlayer = new WorldToos(); if (WordPlayer.CreateWord() == false) { System.Windows.Forms. MessageBox.Show(, , System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); return; } DataTable storedt = new DataTable(); storedt.Columns.Add(); storedt.Columns.Add(); storedt.Columns.Add(); storedt.Columns.Add(); storedt.Rows.Add(, begNUmber, , endNumber); storedt.Rows.Add(, yongshui.ToString() + , , spanNow+); storedt.Rows.Add(, shuiMoney, , chkPenser); storedt.Rows.Add(, , , ""); WordPlayer.SetPage(WorldToos.Orientation.横板, 18.4, 26, 3, 2.4, 1.87, 2.1); WordPlayer.InsertText(dTime, , 14, System.Drawing.FontStyle.Bold), jiankong.WorldToos.Alignment.居中, true); WordPlayer.InsertText(biaoNumber, , 14, System.Drawing.FontStyle.Bold), jiankong.WorldToos.Alignment.居中, true); WordPlayer.InsertText( penName + " ", , 12, System.Drawing.FontStyle.Regular), jiankong.WorldToos.Alignment.左对齐, false); WordPlayer.InsertTable(storedt, true); WordPlayer.InsertText(+ DateTime.Now.ToString(), , 14, System.Drawing.FontStyle.Regular), jiankong.WorldToos.Alignment.右对齐, false); WordPlayer.Save(+ + dTime + , true); MessageBox.Show(+ dTime+); }

 

1.本站遵循行业规范,任何转载的稿件都会明确标注作者和来源;2.本站的原创文章,请转载时务必注明文章作者和来源,不尊重原创的行为我们将追究责任;3.作者投稿可能会经我们编辑修改或补充。

相关文章
  • 众创缘 web前端开发,ui设计,seo,网络营销互联网技术学习网站

    众创缘 web前端开发,ui设计,seo,网络营销互联网技术学习网站

    2017-03-29 14:00

  • HTML5游戏开发案例教程 -互联网+职业技能系列

    HTML5游戏开发案例教程 -互联网+职业技能系列

    2017-03-22 17:00

  • SVG学习入门:VML、SVG和Canvas兼容性

    SVG学习入门:VML、SVG和Canvas兼容性

    2017-01-21 12:05

  • 用canvas实现鼠标拖动绘制矩形框

    用canvas实现鼠标拖动绘制矩形框

    2016-12-24 13:05

网友点评