How to display Excel Data in vb.net

[Vishalbatta]

Hi all,


Plz tell me how to display the Excel data in vb.net.

Vishal

[TracyM]

Hi all,


Plz tell me how to display the Excel data in vb.net.

Vishal

Try using the Office Primary Interop Assemblies. You can get full automation control over Excel or other office app's for that matter. I used this to manipulate Excel files, Access files and finally Visio files and integrating all of them through a vb.net interface. Works nicely. You can download the interop assemblies for 2003 or 2005 for free.

For my needs I moved the Excel Data into an Access Table, Made a DataAdapter Connection, Filled a DataSet, Then Displayed through a DataGrid Bound to the DataSet to displayed it.

Otherwise you'll have to use un-managed code to access and read your Excel files (not perfect but it works).

Best of Luck, :)
TracyM