{"id":2271,"date":"2024-10-17T17:15:06","date_gmt":"2024-10-17T17:15:06","guid":{"rendered":"http:\/\/localhost:10003\/?p=2271"},"modified":"2025-08-04T13:55:30","modified_gmt":"2025-08-04T13:55:30","slug":"version-1-2-mise-a-jour-des-cahiers-dexercices-pour-net-partie-iv","status":"publish","type":"post","link":"https:\/\/xceed.com\/fr\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/","title":{"rendered":"Mise \u00e0 jour de la version 1.2 dans les classeurs pour .NET - Partie IV"},"content":{"rendered":"<p>En savoir plus sur&nbsp;<a href=\"http:\/\/xceed.com\/en\/our-products\/product\/workbooks-for-net\" target=\"_blank\" rel=\"noreferrer noopener\">Xeed Workbooks pour .NET<\/a><\/p>\n\n\n\n<p>Nous concluons notre aper\u00e7u des changements apport\u00e9s par Workbooks for .NET v1.2.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Fusionner et d\u00e9fusionner des cellules<\/h2>\n\n\n\n<p>La possibilit\u00e9 de fusionner et de d\u00e9fusionner des cellules a \u00e9t\u00e9 ajout\u00e9e. Il est possible de le faire en utilisant la fonction&nbsp;<em>Ajouter()<\/em>&nbsp;et&nbsp;<em>RemoveAt()<\/em>&nbsp;sur les m\u00e9thodes de la feuille de calcul&nbsp;<em>Cellules fusionn\u00e9es<\/em>&nbsp;ou avec le&nbsp;<em>MergeCells()<\/em>&nbsp;et&nbsp;<em>UnmergeCells()<\/em>&nbsp;sur le site de l&nbsp;<em>Plage de cellules<\/em>&nbsp;fusionner\/dissocier<\/p>\n\n\n\n<p>La propri\u00e9t\u00e9 MergedCells d'une feuille de calcul est une propri\u00e9t\u00e9&nbsp;<em>Collection de cellules fusionn\u00e9es<\/em>qui repr\u00e9sente une collection de toutes les plages de cellules qui doivent \u00eatre fusionn\u00e9es.<\/p>\n\n\n\n<p>La classe MergedCellCollection poss\u00e8de les propri\u00e9t\u00e9s suivantes :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code data-no-translation=\"\">Count: the number of CellRange in the current collection (read-only)<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">Item: the CellRange object that represents all the Cells that will be merged at the given index (read-only)<\/code><\/li>\n<\/ul>\n\n\n\n<p>La classe MergedCellCollection poss\u00e8de les m\u00e9thodes suivantes :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code data-no-translation=\"\">Add: adds a CellRange element in the collection<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">RemoveAt: Removes an element from the collection<\/code><\/li>\n<\/ul>\n\n\n\n<p>La m\u00e9thode Add() dispose de deux surcharges permettant de sp\u00e9cifier les cellules de d\u00e9but et de fin soit par l'adresse de la cellule, soit en utilisant l'identifiant de la ligne et de la colonne :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code data-no-translation=\"\">Add(startingCellAddress, endingCellAddress, isCenter, isMergeAcross)<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">Add(startingRowId, startingColumnId, endingRowId, endingColumnId, isCenter, isMergeAcross)<\/code><\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code data-no-translation=\"\">\/\/ Using Worksheet.MergedCells\nusing( var document = Workbook.Load( \"testDoc.xlsx\" ));\n{\n\tvar worksheet = document.Worksheets&#91; 0 ];\n\n\t\/\/ Merge a range by adding it to the collection, using the cell address\n\tworksheet.MergedCells.Add(\"B5\", \"C8\", true, false);\n\n\t\/\/ Merge a range (B10:C13) by adding it to the collection, using the cell IDs this time\n\tworksheet.MergedCells.Add(9, 1, 12, 2, true, false);\n\n\t\/\/ Unmerging the first range currently in the collection\n\tworksheet.MergedCells.RemoveAt(0);\n\n\t\/\/ save the modifications\n\tdocument.Save();\n}\n<\/code><\/pre>\n\n\n\n<p>La m\u00e9thode MergeCells() de la classe CellRange a les param\u00e8tres suivants :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code data-no-translation=\"\">isCenter: centers the text horizontally and vertically; true by default.<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">isAcross: indicates if the merge is split per Row, for example \"A1 : B2\" will be merged as \"A1: B1\" and \"A2 : B2\"; false by default.<\/code><\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code data-no-translation=\"\">\/\/ Using the CellRange directly\nusing( var document = Workbook.Load( \"testDoc.xlsx\" ));\n{\n\tvar worksheet = document.Worksheets&#91; 0 ];\n\n\t\/\/ Merging\n\tCellRange range1 = worksheet.Cells&#91; \"B5, C8\" ];\n\trange1.MergeCells();\n\n\t\/\/ Unmerging\n\tCellRange range2 = worksheet.Cells&#91; \"E5, F8\" ];\n\trange2.UnmergeCells();\n\n\t\/\/ save the modifications\n\tdocument.Save();\n}\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Envelopper le contenu d'une cellule<\/h2>\n\n\n\n<p>Le&nbsp;<em>IsTextWrapped<\/em>&nbsp;a \u00e9t\u00e9 ajout\u00e9e \u00e0 la propri\u00e9t\u00e9&nbsp;<em>Alignement<\/em>&nbsp;pour sp\u00e9cifier si le contenu d'une cellule est envelopp\u00e9 ou non.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code data-no-translation=\"\">\/\/ Wrapping the content of a cell\nusing( var document = Workbook.Load( \"testDoc.xlsx\" ));\n{\n\tvar worksheet = document.Worksheets&#91; 0 ];\n\tworksheet.Cells&#91; \"C12\" ].Style.Alignment.IsTextWrapped = true;\n\n\t\/\/ save the modifications\n\tdocument.Save();\n}\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Modifier d'autres propri\u00e9t\u00e9s de l'image<\/h2>\n\n\n\n<p>Le&nbsp;<em>Photo<\/em>&nbsp;ne disposait auparavant que de l'option&nbsp;<em>Description<\/em>,&nbsp;<em>DrawingClientData<\/em>&nbsp;et&nbsp;<em>Verrous d'image<\/em>&nbsp;et a \u00e9t\u00e9 \u00e9tendu \u00e0 d'autres biens.<\/p>\n\n\n\n<p>La classe Picture poss\u00e8de d\u00e9sormais les propri\u00e9t\u00e9s suivantes :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code data-no-translation=\"\">AbsolutePosition: the absolute position of the Picture in the Worksheet, this value must be positive and is of type Position.<br><em>Note that setting this value will clear the value of AnchorPosition, as only one or the other can be used.<\/em><\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">AnchorPosition: the Anchor's position in the Worksheet, this value is of type CellRange.<br><em>Note that setting this value will clear the value of AbsolutePosition, as only one or the other can be used.<\/em><\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">AnchorType: the Anchor's type; can be either an AbsoluteAnchor, a OneCellAnchor or a TwoCellAnchor. (read-only)<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">BottomRightOffsets: offsets the bottom right corner of a TwoCellAnchor Picture.<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">Edit: affects the behavior of a TwoCellAnchor Picture when adding and deleting Rows and Columns using Excel's user interface.<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">Format: the file format of the uploaded media. (read-only)<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">Height: the height of an AbsoluteAnchor or OneCellAnchor Picture.<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">MeasureUnit: the unit used for measuring the Width and Height of the Picture.<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">Name: the name of the Picture in the Worksheet (must be unique across the whole Workbook).<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">TopLeftOffsets: offsets the top left corner of a TwoCellAnchor Picture.<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">Width: the width of an AbsoluteAnchor or OneCellAnchor Picture.<\/code><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Importation de donn\u00e9es<\/h2>\n\n\n\n<p>Les donn\u00e9es peuvent d\u00e9sormais \u00eatre import\u00e9es \u00e0 l'aide de la fonction&nbsp;<em>ImportData()<\/em>&nbsp;sur la m\u00e9thode&nbsp;<em>Feuille de travail<\/em>&nbsp;classe.<\/p>\n\n\n\n<p>La m\u00e9thode ImportData() prend en charge les donn\u00e9es des types suivants :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code data-no-translation=\"\">Array<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">2D-Array<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">ArrayList<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">ICollection<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">IDictionary<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">DataTable<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">DataView<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">CSV path\/stream<\/code><\/li>\n<\/ul>\n\n\n\n<p>La m\u00e9thode ImportData() a les param\u00e8tres suivants :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code data-no-translation=\"\">data: the data to import.<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">options: the options when importing the data<\/code><\/li>\n<\/ul>\n\n\n\n<p>Les options peuvent \u00eatre du type suivant :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code data-no-translation=\"\">ImportOptions: import option properties when importing data in a Worksheet<br>base class for DataTableImportOptions, UserObjectImportOptions and CSVImportOptions.<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">UserObjectImportOptions: import options for user objects when importing data in a Worksheet<br>derives from ImportOptions, useful when importing user object data, like a List, a Player[] or an Array<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">DataTableImportOptions: import options for DataTables when importing data in a Worksheet<br>derives from ImportOptions, useful when importing a DataTable<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">CSVImportOptions: import options for a CSV document or stream when importing data in a Worksheet<br>derives from ImportOptions, useful when importing CSV data<\/code><\/li>\n<\/ul>\n\n\n\n<p>Options d'importation<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code data-no-translation=\"\">using( var document = Workbook.Load( \"testDoc.xlsx\" ));\n{\n\tvar worksheet = document.Worksheets&#91; 0 ];\n\n\t\/\/ Define a list of strings, the import options(vertical by default) and call the ImportData function.\n\tvar stringData = new List() { \"First\", \"Second\", \"Third\", \"Fourth\" };\n\tvar stringImportOptions = new ImportOptions() { DestinationTopLeftAddress = \"B5\" };\n\tworksheet.ImportData( stringData, stringImportOptions );\n\n\t\/\/ save the modifications\n\tdocument.Save();\n}\n<\/code><\/pre>\n\n\n\n<p>Options d'importation d'objets d'utilisateur<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code data-no-translation=\"\">using( var document = Workbook.Load( \"testDoc.xlsx\" ));\n{\n\tvar worksheet = document.Worksheets&#91; 0 ];\n\n\t\/\/ Define a list of user objects, the import options (vertical by default, specify PropertyNames and show propertyNames) and call the ImportData function.\n\tvar userObjectData = new List()\n\t{\n\t\tnew Player() { Name = \"Tom Sawyer\", Team = Team.Miami_Ducks, Number = 9 },\n\t\tnew Player() { Name = \"Mike Smith\", Team = Team.Chicago_Hornets, Number = 18 },\n\t\tnew Player() { Name = \"Kelly Tomson\", Team = Team.LosAngelese_Raiders, Number = 33 },\n\t\tnew Player() { Name = \"John Graham\", Team = Team.NewYork_Bucs, Number = 7 },\n\t};\n\n\tvar userObjectImportOptions = new UserObjectImportOptions() { DestinationTopLeftAddress = \"H5\", PropertyNames = new string&#91;] { \"Name\", \"Team\" }, IsPropertyNamesShown = true };\n\tworksheet.ImportData( userObjectData, userObjectImportOptions );\n\n\t\/\/ save the modifications\n\tdocument.Save();\n}\n<\/code><\/pre>\n\n\n\n<p>Options d'importation de tables de donn\u00e9es<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code data-no-translation=\"\">using( var document = Workbook.Load( \"testDoc.xlsx\" ));\n{\n\tvar worksheet = document.Worksheets&#91; 0 ];\n\n\t\/\/ Define a dataTable, the import options(show specific ColumnNames) and call the ImportData function.\n\tvar dataTable = new DataTable( \"Employees\" );\n\tdataTable.Columns.Add( \"Name\", typeof( string ) );\n\tdataTable.Columns.Add( \"Position\", typeof( string ) );\n\tdataTable.Columns.Add( \"Experience\", typeof( double ) );\n\tdataTable.Columns.Add( \"Salary\", typeof( int ) );\n\tdataTable.Rows.Add( \"Jenny Melchuck\", \"Project Manager\", 11.5d, 77000 );\n\tdataTable.Rows.Add( \"Cindy Gartner\", \"Medical Assistant\", 1.3d, 56000 );\n\tdataTable.Rows.Add( \"Carl Jones\", \"Web Designer\", 4d, 66000 );\n\tdataTable.Rows.Add( \"Anna Karlweiss\", \"Account Executive\", 7.8d, 51000 );\n\tdataTable.Rows.Add( \"Julia Robertson\", \"Marketing Coordinator\", 17.6d, 65000 );\n\n\tvar dataTableImportOptions = new DataTableImportOptions() { DestinationTopLeftAddress = \"B5\", ColumnNames = new string&#91;] { \"Name\", \"Experience\", \"Position\" }, IsColumnNamesShown = true };\n\tworksheet.ImportData( dataTable, dataTableImportOptions );\n\n\t\/\/ save the modifications\n\tdocument.Save();\n}\n<\/code><\/pre>\n\n\n\n<p>CSVImportOptions<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code data-no-translation=\"\">using( var document = Workbook.Load( \"testDoc.xlsx\" ));\n{\n\tvar worksheet = document.Worksheets&#91; 0 ];\n\n\t\/\/ Define a path to a csv document, the import options(which separator to use) and call the ImportData function.\n\tvar stringSCVData = \"Book1.csv\";\n\tvar stringCSVImportOptions = new CSVImportOptions() { DestinationTopLeftAddress = \"C5\", Separator = \",\" };\n\tworksheet.ImportData( stringSCVData, stringCSVImportOptions );\n\n\t\/\/ save the modifications\n\tdocument.Save();\n}\n<\/code><\/pre>\n\n\n\n<p>Pour plus d'informations, veuillez vous r\u00e9f\u00e9rer \u00e0 la&nbsp;<a href=\"https:\/\/doc.xceed.com\/xceed-workbooks-for-net\/webframe.html#topic1.html\" target=\"_blank\" rel=\"noreferrer noopener\">la documentation<\/a>.<\/p>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Dans la quatri\u00e8me partie de cette s\u00e9rie de tutoriels, nous terminons notre aper\u00e7u des modifications apport\u00e9es \u00e0 Workbooks for .NET v1.2 en examinant les fonctionnalit\u00e9s suivantes : \"Fusionner et d\u00e9fusionner des cellules\", \"Envelopper le contenu d'une cellule\" et \"Modifier plus de propri\u00e9t\u00e9s sur l'image\"<\/p>","protected":false},"author":2,"featured_media":2235,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[141,60],"tags":[],"class_list":["post-2271","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-all","category-tutorials"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Version 1.2 Update in Workbooks for .NET - Part IV - Xceed<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/xceed.com\/fr\/blog\/tutoriels\/version-1-2-mise-a-jour-des-cahiers-dexercices-pour-net-partie-iv\/\" \/>\n<meta property=\"og:locale\" content=\"fr_CA\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Version 1.2 Update in Workbooks for .NET - Part IV - Xceed\" \/>\n<meta property=\"og:description\" content=\"In part four of this tutorial series, we conclude our overview of the changes in Workbooks for .NET v1.2 by examining the following features: &quot;Merging and unmerging cells&quot;, &quot;Wraping the content of a cell&quot; and &quot;Modifying more properties on Picture&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/xceed.com\/fr\/blog\/tutoriels\/version-1-2-mise-a-jour-des-cahiers-dexercices-pour-net-partie-iv\/\" \/>\n<meta property=\"og:site_name\" content=\"Xceed\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-17T17:15:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T13:55:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/xceed.com\/wp-content\/uploads\/2024\/10\/blog_WBN.png\" \/>\n\t<meta property=\"og:image:width\" content=\"393\" \/>\n\t<meta property=\"og:image:height\" content=\"392\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alain Jreij\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alain Jreij\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/version-1-2-update-in-workbooks-for-net-part-iv\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/version-1-2-update-in-workbooks-for-net-part-iv\\\/\"},\"author\":{\"name\":\"Alain Jreij\",\"@id\":\"https:\\\/\\\/xceed.com\\\/fr\\\/#\\\/schema\\\/person\\\/2d9169e6fd8ae4a8f58a9e1cc9a73778\"},\"headline\":\"Version 1.2 Update in Workbooks for .NET &#8211; Part IV\",\"datePublished\":\"2024-10-17T17:15:06+00:00\",\"dateModified\":\"2025-08-04T13:55:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/version-1-2-update-in-workbooks-for-net-part-iv\\\/\"},\"wordCount\":287,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/fr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/version-1-2-update-in-workbooks-for-net-part-iv\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/xceed.com\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/blog_WBN.png\",\"articleSection\":[\"All\",\"Tutorials\"],\"inLanguage\":\"fr-CA\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/version-1-2-update-in-workbooks-for-net-part-iv\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/version-1-2-update-in-workbooks-for-net-part-iv\\\/\",\"url\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/version-1-2-update-in-workbooks-for-net-part-iv\\\/\",\"name\":\"Version 1.2 Update in Workbooks for .NET - Part IV - Xceed\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/fr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/version-1-2-update-in-workbooks-for-net-part-iv\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/version-1-2-update-in-workbooks-for-net-part-iv\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/xceed.com\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/blog_WBN.png\",\"datePublished\":\"2024-10-17T17:15:06+00:00\",\"dateModified\":\"2025-08-04T13:55:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/version-1-2-update-in-workbooks-for-net-part-iv\\\/#breadcrumb\"},\"inLanguage\":\"fr-CA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/version-1-2-update-in-workbooks-for-net-part-iv\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-CA\",\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/version-1-2-update-in-workbooks-for-net-part-iv\\\/#primaryimage\",\"url\":\"https:\\\/\\\/xceed.com\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/blog_WBN.png\",\"contentUrl\":\"https:\\\/\\\/xceed.com\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/blog_WBN.png\",\"width\":393,\"height\":392},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/version-1-2-update-in-workbooks-for-net-part-iv\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/xceed.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Version 1.2 Update in Workbooks for .NET &#8211; Part IV\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/xceed.com\\\/fr\\\/#website\",\"url\":\"https:\\\/\\\/xceed.com\\\/fr\\\/\",\"name\":\"Xceed\",\"description\":\"Provides tools for .NET, Windows Forms, WPF, Silverlight, and ASP.NET developers to create better applications.\",\"publisher\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/fr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/xceed.com\\\/fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-CA\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/xceed.com\\\/fr\\\/#organization\",\"name\":\"Xceed\",\"url\":\"https:\\\/\\\/xceed.com\\\/fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-CA\",\"@id\":\"https:\\\/\\\/xceed.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/xceed.com\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/cropped-xceed-logo.png\",\"contentUrl\":\"https:\\\/\\\/xceed.com\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/cropped-xceed-logo.png\",\"width\":609,\"height\":150,\"caption\":\"Xceed\"},\"image\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/xceed.com\\\/fr\\\/#\\\/schema\\\/person\\\/2d9169e6fd8ae4a8f58a9e1cc9a73778\",\"name\":\"Alain Jreij\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-CA\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/87ff2d1efbe1a868809d8d554724877b76941f668176489a42238d867ab8bf06?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/87ff2d1efbe1a868809d8d554724877b76941f668176489a42238d867ab8bf06?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/87ff2d1efbe1a868809d8d554724877b76941f668176489a42238d867ab8bf06?s=96&d=mm&r=g\",\"caption\":\"Alain Jreij\"},\"url\":\"https:\\\/\\\/xceed.com\\\/fr\\\/blog\\\/author\\\/jreijaxceed-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mise \u00e0 jour de la version 1.2 dans les classeurs pour .NET - Partie IV - Xceed","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/xceed.com\/fr\/blog\/tutoriels\/version-1-2-mise-a-jour-des-cahiers-dexercices-pour-net-partie-iv\/","og_locale":"fr_CA","og_type":"article","og_title":"Version 1.2 Update in Workbooks for .NET - Part IV - Xceed","og_description":"In part four of this tutorial series, we conclude our overview of the changes in Workbooks for .NET v1.2 by examining the following features: \"Merging and unmerging cells\", \"Wraping the content of a cell\" and \"Modifying more properties on Picture\"","og_url":"https:\/\/xceed.com\/fr\/blog\/tutoriels\/version-1-2-mise-a-jour-des-cahiers-dexercices-pour-net-partie-iv\/","og_site_name":"Xceed","article_published_time":"2024-10-17T17:15:06+00:00","article_modified_time":"2025-08-04T13:55:30+00:00","og_image":[{"width":393,"height":392,"url":"https:\/\/xceed.com\/wp-content\/uploads\/2024\/10\/blog_WBN.png","type":"image\/png"}],"author":"Alain Jreij","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alain Jreij","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/xceed.com\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/#article","isPartOf":{"@id":"https:\/\/xceed.com\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/"},"author":{"name":"Alain Jreij","@id":"https:\/\/xceed.com\/fr\/#\/schema\/person\/2d9169e6fd8ae4a8f58a9e1cc9a73778"},"headline":"Version 1.2 Update in Workbooks for .NET &#8211; Part IV","datePublished":"2024-10-17T17:15:06+00:00","dateModified":"2025-08-04T13:55:30+00:00","mainEntityOfPage":{"@id":"https:\/\/xceed.com\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/"},"wordCount":287,"commentCount":0,"publisher":{"@id":"https:\/\/xceed.com\/fr\/#organization"},"image":{"@id":"https:\/\/xceed.com\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/#primaryimage"},"thumbnailUrl":"https:\/\/xceed.com\/wp-content\/uploads\/2024\/10\/blog_WBN.png","articleSection":["All","Tutorials"],"inLanguage":"fr-CA","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/xceed.com\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/xceed.com\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/","url":"https:\/\/xceed.com\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/","name":"Mise \u00e0 jour de la version 1.2 dans les classeurs pour .NET - Partie IV - Xceed","isPartOf":{"@id":"https:\/\/xceed.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/xceed.com\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/#primaryimage"},"image":{"@id":"https:\/\/xceed.com\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/#primaryimage"},"thumbnailUrl":"https:\/\/xceed.com\/wp-content\/uploads\/2024\/10\/blog_WBN.png","datePublished":"2024-10-17T17:15:06+00:00","dateModified":"2025-08-04T13:55:30+00:00","breadcrumb":{"@id":"https:\/\/xceed.com\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/#breadcrumb"},"inLanguage":"fr-CA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/xceed.com\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/"]}]},{"@type":"ImageObject","inLanguage":"fr-CA","@id":"https:\/\/xceed.com\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/#primaryimage","url":"https:\/\/xceed.com\/wp-content\/uploads\/2024\/10\/blog_WBN.png","contentUrl":"https:\/\/xceed.com\/wp-content\/uploads\/2024\/10\/blog_WBN.png","width":393,"height":392},{"@type":"BreadcrumbList","@id":"https:\/\/xceed.com\/blog\/tutorials\/version-1-2-update-in-workbooks-for-net-part-iv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/xceed.com\/"},{"@type":"ListItem","position":2,"name":"Version 1.2 Update in Workbooks for .NET &#8211; Part IV"}]},{"@type":"WebSite","@id":"https:\/\/xceed.com\/fr\/#website","url":"https:\/\/xceed.com\/fr\/","name":"Xceed","description":"Fournit des outils aux d\u00e9veloppeurs .NET, Windows Forms, WPF, Silverlight et ASP.NET pour cr\u00e9er de meilleures applications.","publisher":{"@id":"https:\/\/xceed.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/xceed.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-CA"},{"@type":"Organization","@id":"https:\/\/xceed.com\/fr\/#organization","name":"Xceed","url":"https:\/\/xceed.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-CA","@id":"https:\/\/xceed.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/xceed.com\/wp-content\/uploads\/2024\/04\/cropped-xceed-logo.png","contentUrl":"https:\/\/xceed.com\/wp-content\/uploads\/2024\/04\/cropped-xceed-logo.png","width":609,"height":150,"caption":"Xceed"},"image":{"@id":"https:\/\/xceed.com\/fr\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/xceed.com\/fr\/#\/schema\/person\/2d9169e6fd8ae4a8f58a9e1cc9a73778","name":"Alain Jreij","image":{"@type":"ImageObject","inLanguage":"fr-CA","@id":"https:\/\/secure.gravatar.com\/avatar\/87ff2d1efbe1a868809d8d554724877b76941f668176489a42238d867ab8bf06?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/87ff2d1efbe1a868809d8d554724877b76941f668176489a42238d867ab8bf06?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/87ff2d1efbe1a868809d8d554724877b76941f668176489a42238d867ab8bf06?s=96&d=mm&r=g","caption":"Alain Jreij"},"url":"https:\/\/xceed.com\/fr\/blog\/author\/jreijaxceed-com\/"}]}},"_links":{"self":[{"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/posts\/2271","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/comments?post=2271"}],"version-history":[{"count":0,"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/posts\/2271\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/media\/2235"}],"wp:attachment":[{"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/media?parent=2271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/categories?post=2271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/tags?post=2271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}