{"id":2265,"date":"2024-10-17T16:56:13","date_gmt":"2024-10-17T16:56:13","guid":{"rendered":"http:\/\/localhost:10003\/?p=2265"},"modified":"2025-08-04T13:55:31","modified_gmt":"2025-08-04T13:55:31","slug":"utilisation-des-styles-et-des-sheetviews-dans-les-classeurs-pour-net","status":"publish","type":"post","link":"https:\/\/xceed.com\/fr\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/","title":{"rendered":"Utilisation des styles et des SheetViews dans les classeurs pour .NET"},"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>Maintenant que nous avons couvert les bases de la cr\u00e9ation d'un document xlsx et que nous avons appris \u00e0 ajouter et \u00e0 modifier le contenu d'un document xlsx, nous sommes en mesure de le faire.&nbsp;<em>Feuille de travail<\/em>&nbsp;y compris&nbsp;<em>Cellules<\/em>&nbsp;et&nbsp;<em>Tableaux<\/em>Nous allons donc voir comment le rendre attrayant en tirant parti des Styles et des SheetViews !<\/p>\n\n\n\n<p><code data-no-translation=\"\">Note:<\/code><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code data-no-translation=\"\">At the time of this writing, more options have been added to the Style and SheetView classes and will be included in a future release of Xceed Workbooks for .NET.<br>We will cover these new options in a part 2 article once they are available.<\/code><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Qu'est-ce qu'un style ?<\/h2>\n\n\n\n<p>En d'autres termes, un&nbsp;<em>Style<\/em>&nbsp;est un groupe de param\u00e8tres permettant de modifier l'apparence des cellules.&nbsp;<em>Cellule<\/em>, les cellules d'un&nbsp;<em>Colonne<\/em>ou les cellules d'un&nbsp;<em>Rang\u00e9e<\/em>.<\/p>\n\n\n\n<p>Plus pr\u00e9cis\u00e9ment, ces param\u00e8tres sont actuellement les suivants<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code data-no-translation=\"\">Font: the Font to use for the current Style.<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">Alignment: the horizontal and vertical alignments used to align the content of a cell.<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">CustomFormat: the format used to display the content of a Cell (null by default, setting this property will overwrite the PredefinedNumberFormatId property)<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">PredefinedNumberFormatId: the predefined number format with an Id (0 by default, setting this property will overwrite the CustomFormat property)<\/code><\/li>\n<\/ul>\n\n\n\n<p>L'utilisation des styles est un excellent moyen d'assurer une mise en forme coh\u00e9rente dans vos classeurs et feuilles de calcul.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Application d'un style<\/h2>\n\n\n\n<p>Un style peut \u00eatre sp\u00e9cifi\u00e9 soit sur un&nbsp;<em>Cellule<\/em>, les cellules d'un&nbsp;<em>Colonne<\/em>ou des cellules d'un&nbsp;<em>Rang\u00e9e<\/em>.<\/p>\n\n\n\n<p>Cela soul\u00e8ve toutefois la question suivante : que se passe-t-il si une cellule est affect\u00e9e par plus d'un style ? Par exemple, nous avons un style sur la colonne B et \u00e9galement un style sur la 5\u00e8me ligne, dans cette situation, quel style serait utilis\u00e9 pour la cellule \"B5\" ? La priorit\u00e9 est d\u00e9termin\u00e9e dans l'ordre suivant : Cellule, Ligne, Colonne. Cela signifie que dans notre exemple, si aucun style n'est appliqu\u00e9 directement \u00e0 la cellule \"B5\", c'est le style au niveau de la ligne qui sera utilis\u00e9.<\/p>\n\n\n\n<p>Les exemples ci-dessous supposent la disposition initiale suivante du code :<\/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\t\t\n\t\/\/ Styling a specific Cell using its address\n\tworksheet.Cells&#91; \"B2\" ].Style. &#91;...]\n\n\t\/\/ Styling a specific Cell using its row and column index\n\tworksheet.Cells&#91; 1, 1 ].Style. &#91;...]\n\n\t\/\/ Styling the Cells of a Column\n\tworksheet.Columns&#91; 2 ].Style. &#91;...]\n\n\t\/\/ Styling the Cells of a Row\n\tworksheet.Rows&#91; 3 ].Style. &#91;...]\n\n\tdocument.Save();\n}\n<\/code><\/pre>\n\n\n\n<p>Police (propri\u00e9t\u00e9s disponibles)&nbsp;<a href=\"https:\/\/doc.xceed.com\/xceed-workbooks-for-net\/webframe.html#topic138.html\" target=\"_blank\" rel=\"noreferrer noopener\">ici<\/a>)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code data-no-translation=\"\">\/\/ Specific Cell\nworksheet.Cells&#91; \"B1\" ].Style.Font = new Font() { Bold = true, Size = 15.5d };\n\n\/\/ Column\nworksheet.Columns&#91; 2 ].Style.Font = new Font() { Name = \"Lucida Fax\", Italic = true, Underline = true, UnderlineType = UnderlineType.Double };\n\n\/\/ Row\nworksheet.Rows&#91; 3 ].Style.Font = new Font() { Strikethrough = true, Size = 18d };\n<\/code><\/pre>\n\n\n\n<p>Alignement (valeurs disponibles pour&nbsp;<a href=\"https:\/\/doc.xceed.com\/xceed-workbooks-for-net\/webframe.html#topic15.html\" target=\"_blank\" rel=\"noreferrer noopener\">Alignement horizontal<\/a>&nbsp;et&nbsp;<a href=\"https:\/\/doc.xceed.com\/xceed-workbooks-for-net\/webframe.html#topic21.html\" target=\"_blank\" rel=\"noreferrer noopener\">Alignement vertical<\/a>)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code data-no-translation=\"\">\/\/ Specific Cell\nworksheet.Cells&#91; \"B1\" ].Style.Alignment.Horizontal = HorizontalAlignment.Center;\nworksheet.Cells&#91; \"B1\" ].Style.Alignment.Vertical = VerticalAlignment.Center;\n\n\/\/ Column\nworksheet.Columns&#91; 2 ].Style.Alignment = new Alignment( HorizontalAlignment.Justify, VerticalAlignment.Center);\n\n\/\/ Row\nworksheet.Rows&#91; 3 ].Style.Alignment.Horizontal = HorizontalAlignment.CenterAcrossSelection;\n<\/code><\/pre>\n\n\n\n<p>Format personnalis\u00e9<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code data-no-translation=\"\">\/\/ Cell B2 contains 25.6 displayed as \"$25.6000\"\nworksheet.Cells&#91; 1, 1 ].Value = 25.6;\nworksheet.Cells&#91; 1, 1 ].Style.CustomFormat = \"$0.0000\";\n\n\/\/ Cell C3 contains a date formatted to display as \"10:22 AM\"\nworksheet.Cells&#91; 2, 2 ].Value = new DateTime( 2021, 7, 1, 10, 22, 33 );\nworksheet.Cells&#91; 2, 2 ].Style.CustomFormat = \"h:mm AM\/PM\";\n\n\/\/ Column\nworksheet.Columns&#91; 2 ].Style.CustomFormat = \"h:mm AM\/PM\";\n\n\/\/ Row\nworksheet.Rows&#91; 3 ].Style.CustomFormat = \"$0.0000\";\n<\/code><\/pre>\n\n\n\n<p>PredefinedNumberFormatId (valeurs disponibles)&nbsp;<a href=\"https:\/\/doc.xceed.com\/xceed-workbooks-for-net\/webframe.html#topic301.html\" target=\"_blank\" rel=\"noreferrer noopener\">ici<\/a>)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code data-no-translation=\"\">\/\/ Cell D4 contains 33.5 set to format \"0.00\" to display the value as \"33.50\"\nworksheet.Cells&#91; \"D4\" ].Value = 33.5;\nworksheet.Cells&#91; \"D4\" ].Style.PredefinedNumberFormatId = 2;\n\n\/\/ Column with dates formatted as mm-dd-yy\nworksheet.Columns&#91; 2 ].Style.PredefinedNumberFormatId = 14;\n\n\/\/ Row with time formatted as &#91;h]:mm:ss\nworksheet.Rows&#91; 3 ].Style.PredefinedNumberFormatId = 46;\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Qu'est-ce qu'un SheetView ?<\/h2>\n\n\n\n<p>Un SheetView est un moyen de cr\u00e9er des vues personnalis\u00e9es dans une base de donn\u00e9es.&nbsp;<em>Feuille de travail<\/em>.<\/p>\n\n\n\n<p>La classe SheetView repr\u00e9sente une vue d'une seule feuille \u00e0 partir d'un fichier&nbsp;<em>Feuille de travail<\/em>.<\/p>\n\n\n\n<p><code data-no-translation=\"\">Note:<\/code><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code data-no-translation=\"\">At the time of writing, only one SheetView per Worksheet is supported.<\/code><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Utilisation d'un SheetView<\/h2>\n\n\n\n<p>La classe SheetView prend actuellement en charge les propri\u00e9t\u00e9s suivantes :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code data-no-translation=\"\">ActiveCellAddress: the active Cell in the Worksheet, which is the one with focus.<\/code><\/li>\n\n\n\n<li><code data-no-translation=\"\">TopLeftCellAddress: the Cell to be displayed as the top left position in the Worksheet view.<\/code><\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code data-no-translation=\"\">\/\/ Setting a SheetView\n\tusing( var document = Workbook.Load( \"testDoc.xlsx\" ));\n\t{\n\t\tvar worksheet = doc.Worksheets&#91; 0 ];        \n\t\tworksheet.SheetView.ActiveCellAddress = \"C2\";\n\t\tworksheet.SheetView.TopLeftCellAddress = \"B1\";\n\t\tdocument.Save();\n\t}\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>","protected":false},"excerpt":{"rendered":"<p>Maintenant que nous avons couvert les bases de la cr\u00e9ation d'un document xlsx et que nous avons appris \u00e0 ajouter et \u00e0 modifier le contenu d'une feuille de calcul, y compris les cellules et les tableaux, voyons comment la rendre attrayante en tirant parti des Styles et des SheetViews !<\/p>","protected":false},"author":2,"featured_media":2236,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[141,60],"tags":[],"class_list":["post-2265","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.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Using Styles and SheetViews in Workbooks for .NET - 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\/utilisation-des-styles-et-des-sheetviews-dans-les-classeurs-pour-net\/\" \/>\n<meta property=\"og:locale\" content=\"fr_CA\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Styles and SheetViews in Workbooks for .NET - Xceed\" \/>\n<meta property=\"og:description\" content=\"Now that we have covered the basics of creating an xlsx document, and learned how to add to and modify the contents of a\u00a0Worksheet\u00a0including\u00a0Cells\u00a0and\u00a0Tables, let&#039;s look into how to make it look nice by taking advantage of Styles and SheetViews!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/xceed.com\/fr\/blog\/tutoriels\/utilisation-des-styles-et-des-sheetviews-dans-les-classeurs-pour-net\/\" \/>\n<meta property=\"og:site_name\" content=\"Xceed\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-17T16:56:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T13:55:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/xceed.com\/wp-content\/uploads\/2024\/10\/blog_WBN-1.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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/using-styles-and-sheetviews-in-workbooks-for-net\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/using-styles-and-sheetviews-in-workbooks-for-net\\\/\"},\"author\":{\"name\":\"Alain Jreij\",\"@id\":\"https:\\\/\\\/xceed.com\\\/fr\\\/#\\\/schema\\\/person\\\/2d9169e6fd8ae4a8f58a9e1cc9a73778\"},\"headline\":\"Using Styles and SheetViews in Workbooks for .NET\",\"datePublished\":\"2024-10-17T16:56:13+00:00\",\"dateModified\":\"2025-08-04T13:55:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/using-styles-and-sheetviews-in-workbooks-for-net\\\/\"},\"wordCount\":328,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/fr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/using-styles-and-sheetviews-in-workbooks-for-net\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/xceed.com\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/blog_WBN-1.png\",\"articleSection\":[\"All\",\"Tutorials\"],\"inLanguage\":\"fr-CA\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/using-styles-and-sheetviews-in-workbooks-for-net\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/using-styles-and-sheetviews-in-workbooks-for-net\\\/\",\"url\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/using-styles-and-sheetviews-in-workbooks-for-net\\\/\",\"name\":\"Using Styles and SheetViews in Workbooks for .NET - Xceed\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/fr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/using-styles-and-sheetviews-in-workbooks-for-net\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/using-styles-and-sheetviews-in-workbooks-for-net\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/xceed.com\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/blog_WBN-1.png\",\"datePublished\":\"2024-10-17T16:56:13+00:00\",\"dateModified\":\"2025-08-04T13:55:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/using-styles-and-sheetviews-in-workbooks-for-net\\\/#breadcrumb\"},\"inLanguage\":\"fr-CA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/using-styles-and-sheetviews-in-workbooks-for-net\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-CA\",\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/using-styles-and-sheetviews-in-workbooks-for-net\\\/#primaryimage\",\"url\":\"https:\\\/\\\/xceed.com\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/blog_WBN-1.png\",\"contentUrl\":\"https:\\\/\\\/xceed.com\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/blog_WBN-1.png\",\"width\":393,\"height\":392},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/xceed.com\\\/blog\\\/tutorials\\\/using-styles-and-sheetviews-in-workbooks-for-net\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/xceed.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Styles and SheetViews in Workbooks for .NET\"}]},{\"@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":"Utilisation des styles et des SheetViews dans les classeurs pour .NET - 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\/utilisation-des-styles-et-des-sheetviews-dans-les-classeurs-pour-net\/","og_locale":"fr_CA","og_type":"article","og_title":"Using Styles and SheetViews in Workbooks for .NET - Xceed","og_description":"Now that we have covered the basics of creating an xlsx document, and learned how to add to and modify the contents of a\u00a0Worksheet\u00a0including\u00a0Cells\u00a0and\u00a0Tables, let's look into how to make it look nice by taking advantage of Styles and SheetViews!","og_url":"https:\/\/xceed.com\/fr\/blog\/tutoriels\/utilisation-des-styles-et-des-sheetviews-dans-les-classeurs-pour-net\/","og_site_name":"Xceed","article_published_time":"2024-10-17T16:56:13+00:00","article_modified_time":"2025-08-04T13:55:31+00:00","og_image":[{"width":393,"height":392,"url":"https:\/\/xceed.com\/wp-content\/uploads\/2024\/10\/blog_WBN-1.png","type":"image\/png"}],"author":"Alain Jreij","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alain Jreij","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/xceed.com\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/#article","isPartOf":{"@id":"https:\/\/xceed.com\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/"},"author":{"name":"Alain Jreij","@id":"https:\/\/xceed.com\/fr\/#\/schema\/person\/2d9169e6fd8ae4a8f58a9e1cc9a73778"},"headline":"Using Styles and SheetViews in Workbooks for .NET","datePublished":"2024-10-17T16:56:13+00:00","dateModified":"2025-08-04T13:55:31+00:00","mainEntityOfPage":{"@id":"https:\/\/xceed.com\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/"},"wordCount":328,"commentCount":0,"publisher":{"@id":"https:\/\/xceed.com\/fr\/#organization"},"image":{"@id":"https:\/\/xceed.com\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/#primaryimage"},"thumbnailUrl":"https:\/\/xceed.com\/wp-content\/uploads\/2024\/10\/blog_WBN-1.png","articleSection":["All","Tutorials"],"inLanguage":"fr-CA","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/xceed.com\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/xceed.com\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/","url":"https:\/\/xceed.com\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/","name":"Utilisation des styles et des SheetViews dans les classeurs pour .NET - Xceed","isPartOf":{"@id":"https:\/\/xceed.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/xceed.com\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/#primaryimage"},"image":{"@id":"https:\/\/xceed.com\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/#primaryimage"},"thumbnailUrl":"https:\/\/xceed.com\/wp-content\/uploads\/2024\/10\/blog_WBN-1.png","datePublished":"2024-10-17T16:56:13+00:00","dateModified":"2025-08-04T13:55:31+00:00","breadcrumb":{"@id":"https:\/\/xceed.com\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/#breadcrumb"},"inLanguage":"fr-CA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/xceed.com\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/"]}]},{"@type":"ImageObject","inLanguage":"fr-CA","@id":"https:\/\/xceed.com\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/#primaryimage","url":"https:\/\/xceed.com\/wp-content\/uploads\/2024\/10\/blog_WBN-1.png","contentUrl":"https:\/\/xceed.com\/wp-content\/uploads\/2024\/10\/blog_WBN-1.png","width":393,"height":392},{"@type":"BreadcrumbList","@id":"https:\/\/xceed.com\/blog\/tutorials\/using-styles-and-sheetviews-in-workbooks-for-net\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/xceed.com\/"},{"@type":"ListItem","position":2,"name":"Using Styles and SheetViews in Workbooks for .NET"}]},{"@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\/2265","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=2265"}],"version-history":[{"count":0,"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/posts\/2265\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/media\/2236"}],"wp:attachment":[{"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/media?parent=2265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/categories?post=2265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xceed.com\/fr\/wp-json\/wp\/v2\/tags?post=2265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}