Excel Reader .NET is a professional component that enables .NET developers to read
Excel files ( XLSX , XLS ,
CSV ) from .NET applications or website projects (C#, VB.NET). The Excel spreadsheet is represented as a tree structure. Root of the tree is a
ExcelWorkbook object that has different Worksheets and so on.
Excel Reader .NET component requires only .NET Framework and is many times faster than Excel automation objects. The code of Excel Reader .NET component is fully managed and works under .NET Framework started from 1.1 version. Developers
can create C# / VB.NET applications or deploy website on servers with medium-trust level
without needing to rely on Microsoft Excel.
Excel Reader .NET key features:
* Various cell data types (numbers, strings, dates, floating point etc.)
* Multiple excel worksheets.
* Number formatting (number,currency, date, time, fraction etc.)
* Font formatting (size, color, font type, italic and strikeout properties, boldness, underlining, subscript and superscript).
* Cell alignment (vertical, horizontal).
* Cell Background and Fill Pattern.
* Cell borders (color, style).
* Merged cells.
* Export XLSX XLS files to/from DataTable, DataSet.
* Read CSV files (delimited with comma, tab, semicolon or any other separator).
* Read Excel files XLSX XLS.
To read Excel XLSX XLS files from .NET project use the code below. Example of use Excel Reader .NET in C#:
using DTG.Spreadsheet;
ExcelWorkbook Wbook = new ExcelWorkbook();
Wbook.ReadXLS(@"../../../ReadExcel.xls");
ExcelCell A5 = Wbook.Worksheets[0].Cells["A5"];
string s = A5.Value.ToString();
Color c = A5.Style.Font.Color;
Example of use Excel Reader .NET in VB.NET:
Imports DTG.Spreadsheet
Dim Wbook As ExcelWorkbook = New ExcelWorkbook()
Wbook.ReadXLSX("../../../ReadExcel.xlsx")
Dim WSheet As ExcelWorksheet = Wbook.Worksheets(0)
Dim A5 As ExcelCell = WSheet.Cells("A5")
Dim s As String = A5.Value.ToString()
Dim c As Color = A5.Style.Font.Color;
Do not purchase this component, the trial version work (with some limitation). But the full version does not work. And the company does not answer any support request.
Update, the updated component works really good, reads xls files fast. recommended!
New version of Excel Reader .NET has new reading engine for all Excel file formats XLS and XLSX.
New engine consists of updated algorithm of reading OLE2 Stream in Excel file and updated algorithm of parsing Excel Stream.
What else new in the Excel Reader .NET component:
* Supported Excel file formats XLSX, XLS, CSV.
* Added new types of cell hyperlink.
* Added Page Header/Footer.
* Added Pagebreaks lines for Excel printing.
* Improved exception treatment.
* New function restructuring.
* New algorithm of parsing Excel Stream.
* New algorithm of reading OLE2 Stream in Excel file.
* Added methods to Read/Write all Excel sheets to DataSet.
New version of Excel Reader .NET has new features such as Column and Row styles, Gradient filling of sheet cells, Hyperlink and Pictures in XLSX Excel files.
New learning resources:
Excel C# VB.NET Samples - the fastest way to get started with Excel Reader .NET component. Excel User Experience - different tasks that users have resolved with help of Excel Reader .NET component.
What else new in the Excel Reader .NET component:
* New samples.
* New user experience.
* Picture position.
* Fixed issue in formula with comma.
* Fixed error of reading DataTable.
* Fixed References after deleting.
* Column parameters were combined in XLSX.
* Header/footer errors on different pages.
* Fixed issue in Column styles at deleting.
* Added styles for Column and Row.
* Gradient filling for Excel cells.
* Header Footer in XLSX. [v] Fixed bugs in formula calculation.
* Added converter from RPN to string formula.
* Fixed bugs in Merged Cells
* Hyperlinks in XLSX.
* Pictures in XLSX.
* Fixed resaving in XLSX.
* New exceptions for user functions.
* Fixed border issues.
I feel that I have to warn people about this company, I have for several times tried to get them to send me the latest version of the product (both excel Reader and Excel Jetcell). They do not reply at all and do not send me the product that I'm entitled
to. They do not have any way of downloading the full version as a licensed user, therefore I have to send a request by email every time an updated version is out. when they as in my case just ignore this, you cannot get the latest version.
I wish I didnt have to post this message, but thats no way to treat customers.
DTG
Member
2 Points
21 Posts
Read Excel XLS XLSX files in C# VB.NET
Oct 11, 2010 07:54 AM|LINK
Devtrio GROUP is proud to announce the new Excel Reader .NET component.
Excel Reader .NET is a professional component that enables .NET developers to read Excel files ( XLSX , XLS , CSV ) from .NET applications or website projects (C#, VB.NET). The Excel spreadsheet is represented as a tree structure. Root of the tree is a ExcelWorkbook object that has different Worksheets and so on.
Excel Reader .NET component requires only .NET Framework and is many times faster than Excel automation objects. The code of Excel Reader .NET component is fully managed and works under .NET Framework started from 1.1 version. Developers can create C# / VB.NET applications or deploy website on servers with medium-trust level without needing to rely on Microsoft Excel.
Excel Reader .NET key features:
* Various cell data types (numbers, strings, dates, floating point etc.)
* Multiple excel worksheets.
* Number formatting (number,currency, date, time, fraction etc.)
* Font formatting (size, color, font type, italic and strikeout properties, boldness, underlining, subscript and superscript).
* Cell alignment (vertical, horizontal).
* Cell Background and Fill Pattern.
* Cell borders (color, style).
* Merged cells.
* Export XLSX XLS files to/from DataTable, DataSet.
* Read CSV files (delimited with comma, tab, semicolon or any other separator).
* Read Excel files XLSX XLS.
To read Excel XLSX XLS files from .NET project use the code below. Example of use Excel Reader .NET in C#:
Example of use Excel Reader .NET in VB.NET:
Imports DTG.Spreadsheet Dim Wbook As ExcelWorkbook = New ExcelWorkbook() Wbook.ReadXLSX("../../../ReadExcel.xlsx") Dim WSheet As ExcelWorksheet = Wbook.Worksheets(0) Dim A5 As ExcelCell = WSheet.Cells("A5") Dim s As String = A5.Value.ToString() Dim c As Color = A5.Style.Font.Color;For more information about Excel Reader .NET component please visit home page:
http:\\www.devtriogroup\ExcelReader
excel vb.net c# XLS excel file read excel net XLSX
modig
Member
475 Points
420 Posts
Re: Read Excel XLS files in C# VB.NET
Nov 03, 2010 09:42 PM|LINK
Do not purchase this component, the trial version work (with some limitation). But the full version does not work. And the company does not answer any support request.
Update, the updated component works really good, reads xls files fast. recommended!
DTG
Member
2 Points
21 Posts
Re: Read Excel XLS files in C# VB.NET
Nov 08, 2010 11:25 AM|LINK
Hi Modig,
We are sorry for inconvenience. We've rebuilt the full version of Excel Reader .NET component and sent you.
Have you read the Excel file with help of the full version?
If you will have other questions regarding Excel Reader .NET component our support team will be glad to assist you!
Excel Reader .NET Excel Reader support Excel Reader updates
DTG
Member
2 Points
21 Posts
Re: Read Excel XLS files in C# VB.NET
Dec 28, 2010 05:02 PM|LINK
New version 2.0 is available.
New version of Excel Reader .NET has new reading engine for all Excel file formats XLS and XLSX.
New engine consists of updated algorithm of reading OLE2 Stream in Excel file and updated algorithm of parsing Excel Stream.
What else new in the Excel Reader .NET component:
* Supported Excel file formats XLSX, XLS, CSV.
* Added new types of cell hyperlink.
* Added Page Header/Footer.
* Added Pagebreaks lines for Excel printing.
* Improved exception treatment.
* New function restructuring.
* New algorithm of parsing Excel Stream.
* New algorithm of reading OLE2 Stream in Excel file.
* Added methods to Read/Write all Excel sheets to DataSet.
For more information about the component please visit the product page:
http://www.devtriogroup.com/ExcelReader
If you have any questions or concerns about Excel Reader .NET component, let us know:
http://www.devtriogroup.com/ContactUs.aspx
Excel files
DTG
Member
2 Points
21 Posts
Re: Read Excel XLS XLSX files in C# VB.NET
Apr 11, 2011 08:06 AM|LINK
New version 2.3 is available.
New version of Excel Reader .NET has new features such as Column and Row styles, Gradient filling of sheet cells, Hyperlink and Pictures in XLSX Excel files.
New learning resources:
Excel C# VB.NET Samples - the fastest way to get started with Excel Reader .NET component.
Excel User Experience - different tasks that users have resolved with help of Excel Reader .NET component.
What else new in the Excel Reader .NET component:
* New samples.
* New user experience.
* Picture position.
* Fixed issue in formula with comma.
* Fixed error of reading DataTable.
* Fixed References after deleting.
* Column parameters were combined in XLSX.
* Header/footer errors on different pages.
* Fixed issue in Column styles at deleting.
* Added styles for Column and Row.
* Gradient filling for Excel cells.
* Header Footer in XLSX. [v] Fixed bugs in formula calculation.
* Added converter from RPN to string formula.
* Fixed bugs in Merged Cells
* Hyperlinks in XLSX.
* Pictures in XLSX.
* Fixed resaving in XLSX.
* New exceptions for user functions.
* Fixed border issues.
For more information about the component please visit the product page:
http://www.devtriogroup.com/ExcelReader
If you have any questions or concerns about Excel Reader .NET component, let us know:
http://www.devtriogroup.com/ContactUs.aspx
modig
Member
475 Points
420 Posts
Re: Read Excel XLS files in C# VB.NET
Aug 22, 2011 09:26 AM|LINK
I feel that I have to warn people about this company, I have for several times tried to get them to send me the latest version of the product (both excel Reader and Excel Jetcell). They do not reply at all and do not send me the product that I'm entitled to. They do not have any way of downloading the full version as a licensed user, therefore I have to send a request by email every time an updated version is out. when they as in my case just ignore this, you cannot get the latest version.
I wish I didnt have to post this message, but thats no way to treat customers.
Excel Reader .NET Excel Reader support Excel Reader updates
vijaychanne
Member
2 Points
2 Posts
Re: Read Excel XLS XLSX files in C# VB.NET
Sep 16, 2011 07:29 AM|LINK
Error using this component on server.
"Could not load file or assembly Windowsbase Version=3.0.0.0 culture=neutral,
PublickeyToken=31bf3856ad364e35 or one of its dependencies.The system can not findthe file specified"
And no one given the answer yet after sending mail.