mike55 Posted November 18, 2004 Posted November 18, 2004 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 Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
Administrators PlausiblyDamp Posted November 18, 2004 Administrators Posted November 18, 2004 Could you not just display the data in a DataGrid? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
mike55 Posted November 18, 2004 Author Posted November 18, 2004 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. Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
Administrators PlausiblyDamp Posted November 18, 2004 Administrators Posted November 18, 2004 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. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
Mike_R Posted November 18, 2004 Posted November 18, 2004 If you wish to embed an Excel-like control within a Form, then the usual control is an Office Web Components (OWC) Spreadsheet Control. I've 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". Quote Posting Guidelines Avatar by Lebb
mike55 Posted November 19, 2004 Author Posted November 19, 2004 (edited) If you wish to embed an Excel-like control within a Form, then the usual control is an Office Web Components (OWC) Spreadsheet Control. I've 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 can't seem to specify an existing database. Any suggestions?? Mike55 Edited November 19, 2004 by mike55 Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
mike55 Posted November 19, 2004 Author Posted November 19, 2004 Important question... Important question, is the Microsoft Office 2003 Spreadsheet component usable in Web Applications or is it only limited to Windows applications???? Mike55 Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
Mike_R Posted November 21, 2004 Posted November 21, 2004 It is designed as an ActiveX Web component. (It's 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. Quote Posting Guidelines Avatar by Lebb
Recommended Posts