Npoi Exporting word2007 helper Classes

Source: Internet
Author: User

Download Npoi2.0npoi: Click the open link Word template based on word2007 and above. Template Final Effect
Replace paragraph 1, open Word template
            Word.openword (context. Server.MapPath (@ "~/test/wordhelper/template/template. docx"));
2. Paragraph replacement
Dictionary<string, object> d = new dictionary<string, object> ();            Paragraph            d = new dictionary<string, object> ();            D.add ("No", DateTime.Now.ToString ());            Word.setcellvalueparagraphs (d);
Cell partial text substitution in table
            Table interior cell layout replace            d = new dictionary<string, object> ();            D.add ("Tableusername", "Zhengzhou Zhang San");            Word.setcellvaluettables (d, 0);
This feature is primarily used to replace a cell part. For example, the contents of the template cell are: "Name: Tableusername", just replace Tableusername Note: There is a bug here and the placeholder cannot be found if it cannot be parsed by Npoi as a run unit. For example tableusername may be parsed into Table+user+name 3 run the last parameter is the table index, you can get all the tables in the Word template by Word.tables ()
Cell full text substitution in table
Table inside cell Gecquan Replace            d = new dictionary<string, object> ();            D.add ("#tableuserid $", "001");            D.add ("#tableusername $", "Zhengzhou Zhang San");            D.add ("#img $", "$img {" + context.) Server.MapPath (@ "~/test/wordhelper/cat. jpg") + "} (5000000,5000000)"); Insert Picture (width, height)            word.setcellvaluettables1 (d, 1);
This feature replaces the value of the entire cell. Therefore, only placeholders in the cell are required, and no other text can be left. The placeholder is also added with the # placeholder $ to guarantee uniqueness and readability of the cell placeholder

Insert a picture in a table
D.add ("#img $", "$img {" + context.) Server.MapPath (@ "~/test/wordhelper/cat. jpg") + "} (5000000,5000000)"); Insert Picture (width, height)            word.setcellvaluettables1 (d, 1);
Placeholders for inserting pictures can be used with a table operation. Parameter description: $img {picture absolute position} (width, height). $img {} is used to indicate that this is a picture operation

Table Loops Insert Multiple rows

Final effect
Circular table            DataSet ds_table = new DataSet ();            DataTable dt_table = new DataTable ();            Dt_table. Columns.Add ("Itemid");            Dt_table. Columns.Add ("ItemName");            for (int i = 0; i < 5; i++)            {                DataRow dr = Dt_table. NewRow ();                dr["itemid"] = i.ToString ();                dr["ItemName"] = i.tostring () + "name";                Dt_table. Rows.Add (DR);            }            Ds_table. Tables.add (dt_table);            Word.setcellvaluettables (ds_table, 1, word.tables[2]);

Similar to Excel, the order in which a multiline loop inserts records from a dataset into a table,dataset column can be inconsistent with the column order of the template, and the program automatically matches the corresponding column according to its name.Sample Download

Resource Address

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Npoi Exporting word2007 helper Classes

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.