Best way to deal with Excel in VB is by using 3rd party component. It's much faster and easier way then Excel Automation. Try using GemBox
spreadsheet component for exporting Excel. Component is free for commercial use but with limit of 150 rows.
Here you can see a list of reason why GemBox.Spreadsheet is much better tool to work with Excel then
Excel Automation.
BarbaMarioli...
Member
208 Points
136 Posts
Re: How to Read Excel File AT VB.NET
Jul 29, 2009 01:34 PM|LINK
Hi,
Best way to deal with Excel in VB is by using 3rd party component. It's much faster and easier way then Excel Automation. Try using GemBox spreadsheet component for exporting Excel. Component is free for commercial use but with limit of 150 rows.
Here you can see a list of reason why GemBox.Spreadsheet is much better tool to work with Excel then Excel Automation.
Filip
GemBox.Spreadsheet - easiest way to create, read and write Excel files in .NET