Last Modified Date of the Workbook by 'LastModifiedBy' property.Name of the Company by 'Company' property.Comments in the Workbook by 'Comments' property.Category of the Workbook by 'Category' property.Name of the Author by 'Author' property.Version of the Application by 'AppVersion' property.Name of the Application by 'Application' property.The Useful properties which you can set are: Int totalCols = ĭataTable dt = new DataTable(oSheet.Name) įor ( int i = 1 i 1) dr = dt.Rows.Add() ĭt.Columns.Add(()) ĭr = () Private DataTable WorksheetToDataTable(ExcelWorksheet oSheet) Then add these namespace into your C# file like this:.After adding the reference you'll see the following scene in your 'Solution Explorer'.Add the following library into your peoject by adding reference to that library.Or you can download the library DLL from the above link. To run the library code you need to have the.To compile the library, you need a C# 2010 Compiler or better, such as Visual Studio.To shared few samples with the community, so if any one is interested in using this For further detailsĮasily create reports with charts, graphs and other drawing objects. And after going through many tools I found EP Plus. Recently I was looking for an Advance tool through which I can generate complexĮxcel Reports. Adding 'Named Range' in the Excel Sheet.Adding 'R1C1' Formula in the Excel Cell.Create a New Excel Sheet from an Existing Excel Sheet or Template.To do some Basic Works of Excel with EPPlus Library, See this.įollowing 4 New Contents are added in this Release: Reading a simple excel sheet that contains only text and numbers into.Download Previous Release Demo - 8.5 KB.Download Previous Release Source - 314.7 KB.Download Current Release Source - 265.8 KB.Download Current Releaase Demo - 4.9 KB.
0 kommentar(er)
