Formatting a Negative Number with Parentheses in Microsoft Excel. Spreadsheet. You can merge cells, give background color and can format the cell text in excel using EPPlus. while reading date column EPPlus is giving the OADate int value for the date. Each value is a field (or column in a spreadsheet), and each line is a record (or row in a spreadsheet). On the Ribbon, click the Home tab, and then in the Styles group, click Conditional Formatting. It have no third library dependence and almost can run any. Excel Table Formatting using Epplus. 0 package as it has a package dependency on SemVer 2. I wanted text format for only. 38 characters and the default row height is 12. EVERYDAY BE CODING: EPPlus Library Part-15. Format = "dd/MM/yyyy HH:mm"; if I set like this other columns which use numeric values are getting. In this post I will show how we can use it to write these files. Now, somewhere later during execution, probably during serialization, EPPlus will try to match this format property with current dictionary of styles in workbook. Top of Page. i gave the range specifically for column B, but once the excel is generated this formatting is applied for all other columns. Having the proper setting can ensure that your message is accurate. NET Following example shows how to apply various kinds of Conditional Formatting rules to cell ranges of an Excel worksheet with C# and VB. dll we can easily export datatable or dataset data to excel. I have formatting, sorting, column sizing, and as many pages as I need. C# (CSharp) OfficeOpenXml. In this video, we will perform column filter, the visible header of excel table, the visible footer of excel table, apply formula and function in excel table, table custom cell formatting. EPPlus Console App - Excel File with Multiple Worksheets This article describes how to create a. Max so I can set individual column widths with the function. 2 Console Application to create an Excel file using EPPlus. I have one Cell with Text that I want to Span Multiple (3) Columns. $FileNameCSV = "h:\t. net I have a large excel file with ten columns containing date format. //Format the header for column 1-3 Reading Excel using EPPlus; EPPlus Sample for writing 2011 (2) December (1) February (1) About Me. Numberformat. Basically my wrapper contains a few helpers for common formatting, an ActionResult, and a column definition. On the Home tab, in the Cells group, click Format > Column Width. I have a structure with information for the date. EPPLUS Library - Beginners Guide Part-14(A) How to Create a Table in an Excel Worksheet & Insert data into the Excel Table Cells Using EPPlus Library (. Read in/write out to/from Micrsoft excel 2010 to go to the next row or column when reading in or writing to the file. EPPlus is a. csv" $FileNameExcel = "h:\file. I am using OpenPopUpPage() to display GridView reports in modal popups. ExcelPackage. In the Column width box, type 10 (75 pixels wide), and then click OK. https://stackoverflow. Format, Style, should be normal and no shading Colors are only missing on monitor, due to High Contrast Accessibility option. Excel Image Assistant for Mac 1. This property is responsible for applying a filter to every column of Excel table. I this post we will look at a more advanced topic, how to create a graph on an Excel worksheet. Unfortunately you still haven't provided any information about your implementation, which makes our effort to help you very difficult. 0 package(s). Copy Formatting from One Cell or Range to Another in C#, VB. NET library. So, the first column with field values would be designated with PivotColumnAxis. As the name suggestions, a CSV file is simply a plain text file that contains one or more values per line, separated by commas. [Example: If the number format is 0\!, and the value 3 is in the cell, the value 3! is displayed. :I want to know if there is a way to read date from console in format dd. Dimension is as close as you can get, but rows are included in the Dimension if any column contains data or if any row above or below contains data. Numberformat. Again, we need to hack our way into Open XML. From there you can use. net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx). xlsb), reduce the size of your file around 40%. This class provides formatting capabilities that ASP. Width = 15; Set Two Different Colour For Two Differennt Text I. University of Virginia, [email protected] These are the top rated real world C# (CSharp) examples of OfficeOpenXml. It's writing the data with the EPPlus. Creating report files in Excel format is a feature that many users need out of their software applications. This package will only be available to download with SemVer 2. * Section-formatting properties, such as the number of columns. You can programmatically create a worksheet, read worksheet, formatting cell etc. EPPlus is a. This is the easiest and most efficient way of reducing your file size. net library that reads and writes Excel files using the Open Office Xml format (xlsx). [Example: If the number format is 0\!, and the value 3 is in the cell, the value 3! is displayed. Recommend:c# - Export DataTable to excel with EPPlus h int type,so i want to in excel file,the same format will be. Hi, I am using EPPlus to convert datatable to excel sheet. You can also create your own named styles, using the Workbook. EPPlus Console App - Excel File with Multiple Worksheets This article describes how to create a. Once you have the checkbox in place, you may want to format it. I have an excel sheet generated with Epplus, I am experiencing some pain points and i wish to be directed by someone who have solved a similar challenge. Then: The table could be persisted to disk, displayed, or stored in memory. EPPlus how to change color of bar chart in excel Situation: Column chart for comparing month and year data. Do NOT include any row or column totals. In this video, we will perform column filter, the visible header of excel table, the visible footer of excel table, apply formula and function in excel table, table custom cell formatting. I decided to use a framework that wraps the OpenXML framework and allows reading of the Excel file to be very easy. By default this property is false. 0 compatible NuGet clients, such as Visual Studio 2017 (version 15. There is a documentation file available. NET Core library and helps reads and writes Excel files using the Office OpenXML format. What I need to do is counting how many cells in the column I contain the value, ID #4818104. Explicitly, we read o that u 4 = 2u 1 u 2 + u 3 and u 5 = 3u 1. The blog posts will only cover the most important functionality. NET Core project, you can choose any project template. By using EPPlus. This property is responsible for applying a filter to every column of Excel table. but i am not able to get the hyperlink values with links and displayname. The dll also has methods to load an array of objects or a DataTable at once which is much faster, I can get the DataTable method to work but I can't figure out how to load an array with "LoadFromArrays" Example:. PivotLines( 1 ), the second with PivotColumnAxis. Create Temporary Headings Here are the steps that I used, to sort the date columns in the Excel list. This class provides formatting capabilities that ASP. Doing this will freeze whatever rows or columns you wish to have locked in place while viewing the worksheet. Technique 2: Convert text-formatted numbers by using Paste Special. November 4, 2014February 1, 2014. Grid data page export; Multiple grids; DataTable source; Grid custom partial; Switching normal grid to ajax grid; Column header title; Column value rendering; Column value formatting; Column html encoding; Column filter options; Column value filtering; Column multi value filtering; Column default filter method; Column value sorting; Column. EPPlus Throwing Argument Exception (Negative Row And Column Numbers Are Not Allowed) Oct 31, 2011 I'm using EPPlus 2. Format = "MM-dd-yyyy"; You cannot access the columns by their "letter" so far as I know, you will have to use a number e. GitHub Gist: instantly share code, notes, and snippets. C# (CSharp) OfficeOpenXml ExcelPackage. Here I am showing how you can generate excel using DataTable. EPPlus is a. In the below blog, I would like to explain how we can overcome the above problems using OPENXML/ EPPlus third party as EPPlus is a free tool to create the spreadsheet using C#. Min = column. Create Excel 2007/2010 spreadsheets with C# and EPPlus EPPlus is a really good library to help you generate Excel spreadsheets together with C#! I had by the time I stumbled upon the EPPlus library tried quite a few different third party libraries. Writing Large Datasets to Excel Files Using EPPlus in C# Recently, I had to resolve an issue of a corrupt report file of an enterprise application in production. 1 ExcelPackage类. 1 with Visual Basic. Net Blog This Blog dedicated to Microsoft Technologies specially ASP. Each of these formatting definitions can be turned on or off. 导出Excel之Epplus使用教程1(基本介绍)1、前言目前Epplus的介绍中文资料很少,我也一直在摸索中使用它,以下是我在使用过程中得到的经验,写出来供大家参考。2、Epplus介绍EPPlus 博文 来自: 舞我程序. Unfortunately you still haven't provided any information about your implementation, which makes our effort to help you very difficult. University of Virginia, [email protected] Save and close. end example] * Repeats the next character in the format enough times to fill the column to its current width. NET Core Project template. anything we have tried so far will just copy the formula in column H, not the value. Apply auto-fit property to multiple columns simultaneously. I am using EPPlus to read excel data. 2 Console Application to create an Excel file using EPPlus. So when you merge a. Width = 15; Set Two Different Colour For Two Differennt Text I. Syntax of Excel Address Function ADDRESS( row, column, [abs_num], [a1], [sheet_text] ) Example. To get cell content with a given row and column number, you can use the ADDRESS function together with INDIRECT. Assume that you have a column number 4, you want to convert to letter D. I decided to use a framework that wraps the OpenXML framework and allows reading of the Excel file to be very easy. xlsx) using Epplus Export DataSet, DataTable to Excel File (. How to read a Range of cells (e. Requirement: Change chart series color instead of using Excel default color s. Grid data page export; Multiple grids; DataTable source; Grid custom partial; Switching normal grid to ajax grid; Column header title; Column value rendering; Column value formatting; Column html encoding; Column filter options; Column value filtering; Column multi value filtering; Column default filter method; Column value sorting; Column. I want to know if I am repeating myself and if I can make it better and faster. The Excel Range is also a Worksheet property that returns a subset of its cells. How to set the column width in inches. ExcelPackage - 17 examples found. 0 epplus epplus-4 |. 1 (reporting 5 extra columns). Writing Excel Files using EPPLus In my last post I introduced the EPPLus library and showed how to use it to read Microsoft Excel XLSX files. To display a Negative Number with Parentheses, we can use Excel Custom Formatting. // For example if you link to this workbook from another workbook or you will open the workbook in a program that hasn't a calculation engine or. 6m developers to have your questions answered on How can I specify a format for a grid column of Kendo UI for jQuery Grid. In this post I will show how we can use it to write these files. Find the code below for the cs file in my App_Code public class ImportXL { pu. used a formula in Column H to strip a digit from column A, but now i want to copy the values and paste over A. 4) Apply formula & Function in Excel Table 5) Table Custom Cell Formatting. Numberformat. Understanding Date-Based Axis Versus Category-Based Axis in Trend Charts. Application Developer RichTextFormat report generation in side window using column/row format). It turns out that EPPlus has a built-in function for doing that on the Worksheet object itself called FreezePanes. EPPlus is a. The College of New Jersey, [email protected] I still get a few cast errors with this method, that I did not spend time tracking down, as the solution doesn't seem to give a correct result anyway. (Column Période is a DateTime in the DataSource, Column PériodeStr is a String) Watching the e. In Column A I have numbers, and in Column B there may or may not be a letter. Net Libary 1) Column Filter 2) Visible Header of excel table. Having the proper setting can ensure that your message is accurate. i gave the range specifically for column B, but once the excel is generated this formatting is applied for all other columns. Select CSV as the the format you want to convert your XLS file to. For example, when exporting to Excel or PDF, you can select a worksheet layout: If necessary, you can select columns, from which data is to be exported. Libraries: JQuery DataTables, EPPlus Excel for C#, NewtonSoft JSON Serializer/Deserializer. In this technique, you multiply each selected cell by 1 in order to force the conversion from a text-formatted number to a regular number. EPPlusではどう実現するのか探してみると、ExcelHeaderFooterTextクラスに InsertPictureメソッドが用意されていました。 InsertPicture(Image Picture, PictureAlignment Alignment);. On the Layout & Format tab, in the Format options, remove the check mark from Autofit Column Widths On Update. I am working on excel 2007 add ins using vb. Quick tutorial about creating xlsx Excels with C# and the EPPlus nuget package. I'm using csharp to insert data into excel sheet into 7 columns. Create Excel 2007/2010 spreadsheets with C# and EPPlus EPPlus is a really good library to help you generate Excel spreadsheets together with C#! I had by the time I stumbled upon the EPPlus library tried quite a few different third party libraries. On the Excel worksheet, select the cells with numbers that you want to format. Here, I try to set Datetime column's date value to certain format like "DD-MM-YYYY" using the below code. This function has 2 parameters, both of which are int: Row and Column. Format = " @ "; // Format as text // There is actually no need to calculate, Excel will do it for you, but in some cases it might be useful. 1 with Visual Basic. Here we will go over when and how to auto expand multiple columns in Excel. NET Core library and helps reads and writes Excel files using the Office OpenXML format. Requirement: Change chart series color instead of using Excel default color s. Just select a column and choose a number format from the. NET examples Posted on Wednesday, November 13th, 2013 at 8:46 am by Pieter van der Westhuizen. Unfortunately you still haven't provided any information about your implementation, which makes our effort to help you very difficult. How do you read the Excel file using EPPlus? EPPlus is available on nuget. Each table style is made up of a collection of formatting definitions, each of which corresponds to a particular region of the table--e. I am trying to use Custom Format to put the letter (if any) from Column B into Column A (after the number), but have had no success. You can read and modify existing Excel spreadsheets, even though SpreadsheetLight is optimised for creating brand new spreadsheets. From there you can use. Now for the first time we can create native Excel files on the server using standard tools. Excel allows you to group rows or columns so that they can be hidden or displayed with a single mouse click. By default, all numeric values should align to the right. It may depend on exact library version, but for example for EPPlust 4. SELECT FORMAT(1234567890, '###,###,###') AS 'FormattedNumber'. Then: The table could be persisted to disk, displayed, or stored in memory. Here I am showing how you can generate excel using DataTable. 0 epplus epplus-4 |. XLSX Template with EPPlus and Web API, save as XLSX or PDF I've been using NPOI for years to create/edit XLS documents via C#, and it works perfect. An archive of the CodePlex open source hosting site. Min = column. , [DisplayFormat(DataFormatString="{0:d}")]) format date or time values as dates or times, instead formatting them as integers To address these issues, I created a class EpplusExcelPackage which has. Assume that you have a column number 4, you want to convert to letter D. Can anybody help me to export data from Data Table to existing Excel spreadsheet by using EPPlus. I just used an instance of StreamWriter to write the CSV but if you want a copy of that I will post it as well. For example, to prefix each salary summary with a dollar sign, change your report statement as follows: SELECT DeptNo, Name, Salary FROM Employee WHERE DeptNo IN. I would like to give brief introduction to the developers who don’t know about it. I have a structure with information for the date. This is the equivalent to using the hide column or hide row feature. In this ArticleUsedRange – Find Last Used Cell, Column or RowVBA Coding Made EasyFind First Empty CellCount Used Columns In WorksheetLast Used Cell – Problems UsedRange – Find Last Used Cell, Column or Row The following code will return in a message box the total number of rows used in a worksheet. The wrong date data will be imported to Google Excel, we will need to select 2 columns which having wrong date format. NET, we always look for third-party libraries or component. These are the top rated real world C# (CSharp) examples of OfficeOpenXml. I want to know if I am repeating myself and if I can make it better and faster. To highlight unique or distinct values in a column, select the data without a column header (you don't want the header to get highlighted, do you?), and create a conditional formatting rule with one of the following formulas. We use cookies for various purposes including analytics. PowerShell and Excel: Adding Some Formatting To Your Report Posted on December 20, 2012 by Boe Prox Continuing from my previous Excel article , I will now take the report that I created and make more pleasant to the eyes and really show why this is different from just piping the output into Export-CSV to a CSV file. University of Virginia, [email protected] This fantastic, easy to use (and free) library enables the use of Excel in ASP. By default, all numeric values should align to the right. It is so good when you want to read and write Excel files (2007/2010), it makes life easy in a fast paced development requirement. You can merge cells, give background color and can format the cell text in excel using EPPlus. Just select a column and choose a number format from the. Each of these formatting definitions can be turned on or off. Click "Convert" to convert your XLS file. Cell styling is accessed by the Style property. Displays the next character in the format. Would you know if there is a fix for this?. I hope it's more clear now. Writing Excel Files using EPPLus In my last post I introduced the EPPLus library and showed how to use it to read Microsoft Excel XLSX files. Re: Convert from 'text' or 'general' to 'date' format select column use text to columns (data/text to columns)skip through it until you see column data format choose date and select ymd "Unless otherwise stated all my comments are directed at OP". I also understand ExcelToLinQ is managed to do that but it can't recognize table. Bold = true ; range. The main issues are that Epplus does not: read MVC model annotations (e. Formatting a Negative Number with Parentheses in Microsoft Excel. dll we can easily export datatable or dataset data to excel. Requirement: Change chart series color instead of using Excel default color s. Each of these formatting definitions can be turned on or off. Min = column. This library offers several features and methods to help the user to generate Excel sheet. Now for the first time we can create native Excel files on the server using standard tools. It have no third library dependence and almost can run any. Assume that you have a column number 4, you want to convert to letter D. Join a community of over 2. PivotLines( 1 ), the second with PivotColumnAxis. net library that reads and writes Excel files using the Open Office Xml format (xlsx). Now, how can I programmatically copy three existing rows into these new rows, which will include cell format (font, backcolor, border) and formula, but preferably not cell values? If cell values have to be copied all together, that's acceptable too. NET Application + Avoid the File Format Differ Prompt in Excel 2007 using EPPlus (Header just column headings and data. This document contains a description of the binary file format of Microsoft Excel, including all available Excel versions (for Windows) from Excel 2. Syntax of Excel Address Function ADDRESS( row, column, [abs_num], [a1], [sheet_text] ) Example. How to create stacked column chart from a pivot table in Excel? In this article, I introduce a way about how to create a stacked column chart from a pivot table step by step in Excel, if you are interested in this operation, please follow below for details. 0 package as it has a package dependency on SemVer 2. Address will give you a string containing the worksheet dimensions in the traditional Excel range format (e. This package is considered a SemVer 2. Just select a column and choose a number format from the. I am trying to format a Excel 2010 Worksheet. I have already looked a bunch of articles, try a million solutions, but nothing had worked. If you can’t find any sample code here to do what you want, and you’re on a tight schedule, just contact me and I’ll show you how to accomplish your specific requirement. EPPlus doesn't support "Show Value As" feature for pivot data fields. an extremely complicated format and it. In the example shown, the formula in G6 is: =INDIRECT(ADDRESS(G4,G5)) How this formula works The Excel. NET, we always look for third-party libraries or component. The dll also has methods to load an array of objects or a DataTable at once which is much faster, I can get the DataTable method to work but I can't figure out how to load an array with "LoadFromArrays" Example:. The file can export normally but i have some problem with setting column format. Another solution is to put a single quote in front of a number and Excel will treat it as text, allowing it to display in the adjacent cell. Requirement: Change chart series color instead of using Excel default color s. How to format excel cells to text while exporting data grid to excel? i suggest you using epplus (free) download it with nuget. There are 4 methods by which we can format the Negative Number with Parentheses:. EPPlus is a. from your c# application. In this post I will show how we can use it to write these files. Here, I try to set Datetime column's date value to certain format like "DD-MM-YYYY" using the below code. 00"; Is this a bug or am I missing something? c# export-to-excel epplus numeric-format |. Customize the columns. The column space of R0 is not the same as the column space of A; however, Theorem 5. Nevertheless I didn't give up and found the answer in a code snippet in your other thread, How to use the excel functions in d365fo using x++. Writing Excel Files using EPPLus In my last post I introduced the EPPLus library and showed how to use it to read Microsoft Excel XLSX files. How to format an Excel file using C# When programming with Microsoft Office Excel, you can interact with the objects provided by the Excel object model. Excel Graphs with EPPlus In my last post I showed how to write data to an Excel file using the EPPlus library. The console application uses the EPPlus package in the Repository to generate the Byte Stream and output SQL Server data into a MultiSheet Excel File. Hi, I am using EPPlus to convert datatable to excel sheet. Grid data page export; Multiple grids; DataTable source; Grid custom partial; Switching normal grid to ajax grid; Column header title; Column value rendering; Column value formatting; Column html encoding; Column filter options; Column value filtering; Column multi value filtering; Column default filter method; Column value sorting; Column. This API has been very useful for me. EPPlus เป็นคลาสไลบรารี่ที่ใช้สำหรับการอ่านและเขียน (Read/Write) ไฟล์ Excel ด้วย. 0 running on Microsoft® Excel® 2011 B rochure, newsletter or product catalog in Excel If your business requires to frequently provide the product details (including images)of your merchandise to your customers, distributors or dealers then you are on right place. I have one Cell with Text that I want to Span Multiple (3) Columns. I have a structure with information for the date. i'm hoping me, @ least, answer 1 of 2 questions asked here, looking how create pivotcache in epplus / openxml , can't find online / in documentation shows how it. For Test02. PivotLines( 3 ), and so on. They are explained in depth in part 3 Import. Excel allows you to group rows or columns so that they can be hidden or displayed with a single mouse click. I also understand ExcelToLinQ is managed to do that but it can't recognize table. Format = "$#,###. NET for Visual Studio 2012 This site uses cookies for analytics, personalized content and ads. This property is responsible for applying a filter to every column of Excel table. There are 4 methods by which we can format the Negative Number with Parentheses:. How to read a Range of cells (e. How To Format Excel Table Using EPPlus Library Part Fifteen - C#. You can merge cells, give background color and can format the cell text in excel using EPPlus. SpreadsheetLight is an open source Open XML spreadsheet library for. I set column. At several places the remark “2do” indicates an incomplete section of the documentation. The Columns window opens. EVERYDAY BE CODING: EPPlus Library Part-14a. 1 with Visual Basic. A extension version of Tim Schmelter's answer. A range is a collection of two or more cells. Using C# to load csv to excel using EPPlus. And in Excel, it is difficult for you to set the row height or column width in inches or centimeters. Display only the last few digits of Social Security numbers. NET library. You can create new Open XML spreadsheets, or work with existing Open XML spreadsheets that are compatible with Microsoft Excel 2007/2010/2013 and LibreOffice Calc. This snippet of code will give you a couple of scenarios where you can protect a worksheet but allow users to adjust the formatting to rows and columns. dll cell by cell so it's slow. In this blog post I will be discussing the steps involved in Excel Upload and Download (Export and Import of Excel Data) For SharePoint List Items with EPPlus in SharePoint 2013. Share on Facebook; Share on Google+; Tweet; Pin it; Share on LinkedIn; Share epplus. EPPlus is a. xlsb loading time ║ 165s │ 43s saving time ║ 115s │ 61s file size ║ 91 MB │ 65 MB. Tag: c#,epplus. Requirement: Change chart series color instead of using Excel default color s. x to the current Excel 2003. Ensuring specific columns in an ExcelWorksheet format as ShortDate the Nuget Epplus package to export MVC models to fresh Excel documents. Please help :( I have spent long hours searching for sample code regarding this so that I can learn from it but to no avail. People suggested I use EPPlus, and. Add(hasHeaderRow ?. * Character-formatting properties, such as bold or italic. I am using EPPlus to read excel data. You can distribute text in one of two ways: • Evenly. 38 characters and the default row height is 12. Select Format > Number > Date Time and all date column will be formatted accordingly. EPPlus is a. On a worksheet, the default units for the row height and column width are preset, and the default column width is 8. If I know the boundaries in row/column format, how do I get this as a range?. On the Format menu, point to Column, and then click Width. The problem is, while it's formatting the column correct, it's also formatting other columns with the format and not just the column I specified. Share on Facebook; Share on Google+; Tweet; Pin it; Share on LinkedIn; Share epplus. Apply auto-fit property to multiple columns simultaneously. Format = "MM-dd-yyyy"; You cannot access the columns by their "letter" so far as I know, you will have to use a number e. xlsx (Excel files) in ASP. There is no built-in way of indicating that a row shouldn't be accounted for when only deleting data in some cells. This class provides formatting capabilities that ASP. net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx). Again, we need to hack our way into Open XML. but i am not able to get the hyperlink values with links and displayname. EPPlus与Excel完美的结合. Top of Page. This is the easiest and most efficient way of reducing your file size. This fantastic, easy to use (and free) library enables the use of Excel in ASP. Use of Format, Style can seem like a template was used to set up colors, but can't find any such format. We already talked about EPPlus in this post, where we described it as one of the best open-source libraries to programmatically read, create and edit MS Excel files in XLS and XLSX format: a great alternative to the Microsoft. https://stackoverflow. 2 Console Application to create an Excel file using EPPlus. Right-click on the column heading for B and choose Column Width. In the example shown, the formula in G6 is: =INDIRECT(ADDRESS(G4,G5)) How this formula works The Excel. NET applications without the need to install the Access Database Engine (ACE) or having to mess about with unsupported Office Automation on the web server. We are going to use EPPLus library in this article. Here, GetTable generates a table with 4 columns of different types. Does anyone know a way to export a DataTable to Excel with these c# excel datatable export epplus share | improve this question asked Dec 2 '12 at 13:31 Davood Hanifi 462 1 5 1. Hi, I am using EPPlus to convert datatable to excel sheet. if user is Admin he can see all fields in excel, if he is normal user he only see selected fields. If they select all 7, all the 7 columns in spreadhseet will have data, if they select one checkbox then only one column will have data. Copy Formatting from One Cell or Range to Another in C#, VB.
Post a Comment