Displaying data from an excel sheet...

[mike55]

Hi all

Now know how to get data from an xml file and insert data into an xml file. Does anyone know of either a vb.net tool or a third party tool that will allow me to display all the data I selected from the .xml file in an excel type table.

Mike55

 

[PlausiblyDamp]

Could you not just display the data in a DataGrid?

 

[mike55]

Could you not just display the data in a DataGrid?

That would be the right way to do it and the cheap way to do it, however I was told not to use the datagrid as the person wanted a display unit that is similar in appearence to the excel program.

Mike.

 

[PlausiblyDamp]

In that case you could probably either buy a 3rd party grid control with a more excel like appearance or even just display it in excel.

 

[Mike_R]

If you wish to embed an Excel-like control within a Form, then the usual control is an Office Web Components (OWC) Spreadsheet Control. Ive never tried it in .Net, however, but other than the usual Interop quirkyness that can be expected, I would think that it should work fine.

In .Net you need to look within the COM Components (of course), looking for "Microsoft Office Spreadsheet 11.0".

 

[mike55]

If you wish to embed an Excel-like control within a Form, then the usual control is an Office Web Components (OWC) Spreadsheet Control. Ive never tried it in .Net, however, but other than the usual Interop quirkyness that can be expected, I would think that it should work fine.

In .Net you need to look within the COM Components (of course), looking for "Microsoft Office Spreadsheet 11.0".

Hi Mike_R

Thanks for the suggestion, there is such a component and I am just after adding it to my toolbar. From first looks it seems that it is a nice component, the only catch is that I cant seem to specify an existing database. Any suggestions??

Mike55

 

[mike55]

Important question...

Important question, is the Microsoft Office 2003 Spreadsheet component usable in Web Applications or is it only limited to Windows applications????

Mike55

 

[Mike_R]

It is designed as an ActiveX Web component. (Its full name is "Office Web Components (OWC) Spreadsheet Control" and shows up like this in VB 6.0. In VB.Net it seems to show up as "Microsoft Office Spreadsheet 11.0".

However, it does not automatically data-bind to any database, not even to Excel. So to put data within it, you must iterate through the cells placing the data as you like. The syntax to manipulate it looks much like Excel, although, to be honest, I have really not used it much.