您好,登錄后才能下訂單哦!
今天就跟大家聊聊有關使用OpenXml怎么合并Table單元格,可能很多人都不太了解,為了讓大家更加了解,小編給大家總結了以下內容,希望大家根據這篇文章可以有所收獲。
using DocumentFormat.OpenXml; using DocumentFormat.OpenXml.Packaging; using DocumentFormat.OpenXml.Wordprocessing; using OpenXML.Model; using System; using System.Collections.Generic; namespace OpenXML { class Program { //表格數據 public static List<List<string>> _tabData; public Program(List<List<string>> tabData) { _tabData = tabData; } static void Main(string[] args) { List<string> dataTitle = new List<string>() { "序號","姓名","性別"}; List<string> data1 = new List<string>() { "1", "張三", "男" }; List<string> data2 = new List<string>() { "2", "王五", "男" }; List<string> data3 = new List<string>() { "3", "李四", "女" }; _tabData = new List<List<string>>(); _tabData.Add(dataTitle); _tabData.Add(data1); _tabData.Add(data2); _tabData.Add(data3); CreateTable(_tabData, @"C:\Users\dzw159\Desktop\WT\VS\OpenXMLFile\openXMLTest.docx",300); //CreateOpenXMLFile(@"C:\Users\dzw159\Desktop\WT\VS\OpenXMLFile\openXMLTest.docx"); Console.WriteLine("Hello World!"); Console.Read(); } /// <summary> /// 創建Word /// </summary> /// <param name="filePath"></param> public static void CreateOpenXMLFile(string filePath) { using (WordprocessingDocument objWordDocument = WordprocessingDocument.Create(filePath, WordprocessingDocumentType.Document)) { MainDocumentPart objMainDocumentPart = objWordDocument.AddMainDocumentPart(); objMainDocumentPart.Document = new Document(new Body()); Body objBody = objMainDocumentPart.Document.Body; //創建一些需要用到的樣式,如標題3,標題4,在OpenXml里面,這些樣式都要自己來創建的 //ReportExport.CreateParagraphStyle(objWordDocument); SectionProperties sectionProperties = new SectionProperties(); PageSize pageSize = new PageSize(); PageMargin pageMargin = new PageMargin(); Columns columns = new Columns() { Space = "220" };//720 DocGrid docGrid = new DocGrid() { LinePitch = 100 };//360 //創建頁面的大小,頁距,頁面方向一些基本的設置,如A4,B4,Letter, //GetPageSetting(PageSize,PageMargin); //在這里填充各個Paragraph,與Table,頁面上第一級元素就是段落,表格. objBody.Append(new Paragraph()); objBody.Append(new Table()); objBody.Append(new Paragraph()); //我會告訴你這里的順序很重要嗎?下面才是把上面那些設置放到Word里去.(大家可以試試把這下面的代碼放上面,會不會出現打開openxml文件有誤,因為內容有誤) sectionProperties.Append(pageSize, pageMargin, columns, docGrid); objBody.Append(sectionProperties); //如果有頁眉,在這里添加頁眉. //if (IsAddHead) //{ //添加頁面,如果有圖片,這個圖片和上面添加在objBody方式有點不一樣,這里搞了好久. //ReportExport.AddHeader(objMainDocumentPart, image); //} objMainDocumentPart.Document.Save(); } } /// <summary> /// 創建Tab /// </summary> /// <param name="tabData"></param> /// <param name="filePath"></param> /// <param name="width"></param> public static void CreateTable(List<List<string>> tabData, string filePath,int width) { //打開Word文件 using (WordprocessingDocument d = WordprocessingDocument.Open(filePath,true)) { //聲明表格 Table tab = new Table(); //表格樣式 TableProperties tblProp = new TableProperties(new TableBorders( new TableBorders( new TopBorder() { Val = new EnumValue<BorderValues>(BorderValues.Single),Size = 4}, new BottomBorder() { Val = new EnumValue<BorderValues>(BorderValues.Single), Size = 4 }, new LeftBorder() { Val = new EnumValue<BorderValues>(BorderValues.Single), Size = 4 }, new RightBorder() { Val = new EnumValue<BorderValues>(BorderValues.Single), Size = 4 }, new InsideHorizontalBorder() { Val = new EnumValue<BorderValues>(BorderValues.Single), Size = 4 }, new InsideVerticalBorder() { Val = new EnumValue<BorderValues>(BorderValues.Single), Size = 4 } ) )); //設置表格寬度 tblProp.TableWidth = new TableWidth() { Width = width.ToString(), Type = TableWidthUnitValues.Dxa }; //樣式添加 tab.Append(tblProp); int j = 0; //循環生成單元格 foreach (var item in tabData) { //聲明Tab行 TableRow row = new TableRow(); for (var i = 0; i < item.Count; i++) { //申明單元格 TableCell cell = new TableCell(); TableCellProperties tableCellProperties = new TableCellProperties(); //單元格樣式設置 TableCellMargin margin = new TableCellMargin(); margin.LeftMargin = new LeftMargin() { Width="100", Type = TableWidthUnitValues.Dxa }; margin.RightMargin = new RightMargin() { Width = "100", Type = TableWidthUnitValues.Dxa }; tableCellProperties.Append(margin); Paragraph par = new Paragraph(); Run run = new Run(); //如果同一列的參數相同(合并單元格) if (j < (tabData.Count - 1) && item[i] == tabData[j + 1][i]) { VerticalMerge verticalMerge = new VerticalMerge() { Val = MergedCellValues.Restart }; //RunProperties rpr = new RunProperties(); //rpr.Append(new Bold()); //run.Append(rpr); //verticalMerge.Val = MergedCellValues.Restart; //Text t = new Text(item[i]); //t.Space = new EnumValue<SpaceProcessingModeValues>(SpaceProcessingModeValues.Preserve); //run.Append(t); TableCellProperties tableCellProperties2 = new TableCellProperties(); tableCellProperties2.Append(verticalMerge); cell.Append(tableCellProperties2); Text t = new Text(item[i]); t.Space = new EnumValue<SpaceProcessingModeValues>(SpaceProcessingModeValues.Preserve); run.Append(t); } //和上一行比較(合并單元格) else if (j>0 && j < (tabData.Count) && item[i] == tabData[j -1][i]) { VerticalMerge verticalMerge = new VerticalMerge() { Val = MergedCellValues.Continue }; TableCellProperties tableCellProperties2 = new TableCellProperties(); tableCellProperties2.Append(verticalMerge); cell.Append(tableCellProperties2); Text t = new Text(item[i]); t.Space = new EnumValue<SpaceProcessingModeValues>(SpaceProcessingModeValues.Preserve); run.Append(t); } else { //RunProperties rPr = new RunProperties(); //rPr.Append(new Bold()); //run.Append(rPr); //單元格內容添加(由內向外順序) Text t = new Text(item[i]); t.Space = new EnumValue<SpaceProcessingModeValues>(SpaceProcessingModeValues.Preserve); run.Append(t); } par.Append(run); cell.Append(tableCellProperties); cell.Append(par); row.Append(cell); } j++; //表格添加行 tab.Append(row); } //objBody.Append(new Paragraph()); //objBody.Append(new Table()); d.MainDocumentPart.Document.Body.Append(new Paragraph(new Run(tab))); d.MainDocumentPart.Document.Save(); } } } }
看完上述內容,你們對使用OpenXml怎么合并Table單元格有進一步的了解嗎?如果還想了解更多知識或者相關內容,請關注億速云行業資訊頻道,感謝大家的支持。
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。