Home › Community › Control Gallery › Data & XML › .NET xPorter V 3.0.1000

.NET xPorter V 3.0.1000



(5) Submit a Review

1,024 Downloads

20,971 Views

Author
Company xPortTools Inc.
Source Code Available No
License Type Commercial
Submitted On December 01, 2008
Updated on December 10, 2008
.NET Framework 1.x, 2.0, 3.5
Cost $79

Description

xPort Tools for .NET.NET xPorter is 100% managed .NET component that provides extremely fast export of the data from ADO.NET DataSet/DataTable/DataView into the native Microsoft Excel, Microsoft Excel 2007 XLSX, Microsoft Excel XML, CSV or HTML formats without using Excel itself or any additional tools and providers. .NET xPorter provides fast and simple way to transfer your data with the minimum efforts.

Syntax Example

VB.NET (ASP.NET application) Private Sub SaveDataSetIntoBinaryExcel(ByVal loDataSet As DataSet) Dim loXPort As VM.xPort.DS2XL Dim lcExportFile As String Dim loFileInfo As FileInfo If Not loDataSet Is Nothing Then loXPort = New DS2XL() 'Generate temporary file name lcExportFile = System.IO.Path.GetTempFileName & ".xls" loXPort.Export(loDataSet, lcExportFile, xpOutputFormat.Excel8, True, True) loFileInfo = New FileInfo(lcExportFile) If loFileInfo.Exists AndAlso Response.IsClientConnected Then 'Write Excel content into the Response Response.ContentType = "application/vnd.ms-excel" Response.AddHeader("Content-Disposition", "attachment; filename=" & lcExportFile) Response.WriteFile(lcExportFile) Response.Flush() End If End If End Sub VB.NET (Windows application) Private Sub SaveDataSetIntoBinaryExcel(ByVal loDataSet As DataSet) Dim loXPort As VM.xPort.DS2XL Try If Not loDataSet Is Nothing Then loXPort = New DS2XL() loXPort.Export(loDataSet, "Authors.xls", xpOutputFormat.Excel8, True, True) loXPort.Dispose() loXPort = Nothing End If MessageBox.Show("Export Completed!") Catch loEx As Exception MessageBox.Show(loEx.Message) End Try End Sub

Reviews

Submit a review

Great control and great support

Reviewed by: Russ_Araujo on Tuesday, June 12, 2007

5 Stars

xPort Tools is just right for my application's needs. It has the right features at the right level of detail, and is easy to use. Additionally, the author's responsiveness to a technical issue I had was outstanding.

So easy to use and does the job perfectly

Reviewed by: Aion on Saturday, March 17, 2007

5 Stars

I have been searching the web for many hours for a .NET control that coult export a query from my MSSQL database to an native Excel file. After several downloads and disapointments i stumbled across xPort Tools for .NET. I was surprised how easy it was to use and the functionality was just what I was looking for.

Easy, Fast, Reliable, Great Support

Reviewed by: jeffwillis on Thursday, July 27, 2006

5 Stars

I am a commercial developer and have evaluated several to-XLS objects. After trying the xPortTools, I was surprised how easy it was to implement. In just a few lines of code I am able to create multi-page excel files for my clients. It is fast, reliable and reasonably priced.. The ability to writ to streams or files from a single overloaded function, makes this product standout from all the others I have evaluated. It is currently deployed at several Government agencies where it is used to create reports. The support is phenomenal. I have questions answered and issues resolved within a few hours. I wish all software companies were as equally responsive.

Works Great

Reviewed by: seoff on Wednesday, June 08, 2005

5 Stars

I purchased the control for one of my contracts and it was so easy to setup and get it going! The guy who built this is also very supportive! You have a question, he responds very quickly. Those are 2 things that mean allot to me when looking for a 3rd party control, usability, and support! A++

XPort Tools for .NET

Reviewed by: bboffin on Tuesday, May 03, 2005

5 Stars

I was looking for a simple .NET component that would allow me to export data from ADO.NET datasets and tables to an Excel spreadsheet file, preferably without invoking Excel itself. After trying a number of feature rich Excel components that did far more than I needed and didn't do what I wanted very well I came across xPort Tools for .NET. This component does one job and does it extremely well. There is only one method in the class that is overloaded to provide the ability to export from a dataset, a datatable or a dataview to either an Excel .xls file or to a CSV file. It is very easy to use and very fast. The author provides excellent support and it's inexpensive especially when compared to the more feature rich Excel components. If you have the same requirement as me I can't recommend it more highly. Try it. You won't be disappointed. PS - Ive just seen the enhancements in v2.0 that allow output to a stream and the HTML format and they will really help on web sites