StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Load data from excel file

Load data from excel file

Chan — Mon, 06 Aug 2007 16:44:55 GMT

Hi,
How could I load data excel into BO?

Thank you

RE: Load data from excel file

Kari Paukku — Mon, 06 Aug 2007 16:44:55 GMT

Hi,

we had the same type of problem (Excel to Oracle) and in the end decided to use a commercial tool/component from Syncfusion (http://www.syncfusion.com/products/xlsio/windows/default.aspx) together with SF in a VB.Net environment. That solution worked fine for us.

Kari

RE: Load data from excel file

Greg McGuffey — Mon, 06 Aug 2007 13:42:27 GMT

I thought there was a ADO.NET driver for excel (there was for ADO). If there is, you could just open excel via ADO.NET. As I recall the excel drivers are finicky.

RE: Load data from excel file

Trent L. Taylor — Sat, 04 Aug 2007 09:27:49 GMT

Well, this is obviously not a native function of the BO, so you will need to convert the Excel document into XML and then you can use the ADO.NET DataTable command to read in the XML document and finally you can use the CopyDataFrom on the BO to bring the data in in a known format.

I recommend using the MSOffice Interop classes to open and read the Excel document and dump it into an XML format. Once this is done you can bring it into a DataTable which can then be brought into the BO.