Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.dotnet.languages.csharp,microsoft.public.excel.programming
|
|||
|
|||
Import Excel data with .NET
Hi
Before I start coding I need to be sure that nobody else has not done it yet and that I can use it. I need an import utility which import data from Excel to a database or some object in .NET. The data in Excel is not in structured columns but can exist everywhere in the workbook. For example if I am supposed to import a person and all his/her cars which exist in a workbook I want to be able to create an import protocol and specify that the first name exist in cell Sheet1!C4, the last name in Sheet1!F4, telephone in Sheet1!E10 and all cars in in column Sheet2!B4. The resulting table to a database could look something like this Agnes|Carlsson|123456|Subaru Agnes|Carlsson|123456|Volvo Agnes|Carlsson|123456|Ford Are their any Open Source projects, Frameworks and/or components which I can use or have a look at? Regards /Niklas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Import external data, data includes Excel function | Excel Worksheet Functions | |||
import data into excel | Excel Discussion (Misc queries) | |||
how to Import data in excel office2003 with data more 65000 rows | Excel Worksheet Functions |