Thread
:
Import Excel data with .NET
View Single Post
#
2
Posted to microsoft.public.dotnet.languages.csharp,microsoft.public.excel.programming
Nicholas Paldino [.NET/C# MVP]
external usenet poster
Posts: 1
Import Excel data with .NET
Niklas,
There is really no need for such a thing really. You can use the Excel
automation model to access the sheet directly and then get the values in
those sheets/cells.
Basically, you should set a reference to the Microsoft Office Primary
Interop Assemblies in your project.
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
-
"Niklas" wrote in message
...
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
Reply With Quote
Nicholas Paldino [.NET/C# MVP]
View Public Profile
Find all posts by Nicholas Paldino [.NET/C# MVP]