|
In my asp.net dynamic data project I want to read an excel file using suitable Microsoft technology (Not Excel). Someone said their was a server side tool for this? I want to read the first few columns of data from a table?
Any suggestions or directions on where to go?
|
|
|
|
|
Yes, Excel files are encoded in XML.
So to get started you can include following namespaces in the codebehind of your page:
System.Xml (work with XML objects)
System.IO (read/write to files)
The Internet is full of code example that show you how to use them.
http://support.microsoft.com/kb/301228[^]
.
|
|
|
|
|
It depends on the version of Excel format the file is saved in. If it's in 2003 and below, it's a multiple stream binary file that will be just about impossible to decipher. If it's 2007 and above, it'll be a .ZIP format file with multiple XML files inside of it. Again, a royal pain to decipher without the SDK. Seriously, save yourself MONTHS of work and use the Visual Studio Tools for Office to do this.
|
|
|
|