There are many ways to do this. You can find a lot of classes and object around the internet. My approach is to use Excel XML feature.
The first step is to create a template using excel and to save it as XML using Excel “Save AS”.
The next step is to open the XML file with some notepad and to analyze the structure.
The last step is to generate the structure using programming language and XML parser.
Donâ€™t forget to use right “content-type” if your application is a web project and an excel file should by downloaded and handled by the Microsoft excel and not by some xml editor. “content-type” in this case should be “application/vnd.ms-excel”
download: xml-excel.xml ()
description: example of excel xml file
Decided to look through a free content management (CMS) system – DotNetNuke (www.dotnetnuke.com). Downloaded the package and did the steps described in readme.txt.
The first problem i faced was sql exception on adding a Store Account module.
[code]An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005,this failure may be caused by the fact
that under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error:
26 – Error Locating Server/Instance Specified)[/code]
After some time of experimentation i’ve found out that there are two connectionstring properties administrator should set. One is under “connectionstrings” and the other is under “appsettings”.
The other problem i faced was an application exception adding new product to a product list useing Store Products module
[code]object refference not set to an instance of an object.[/code]
After some time of searches I’ve found that the problem is because of Store Catalog Module whitch was not added to the portal. After adding this module new product was added successfully.