VB.NET Excel All Versions

March 4, 2007

Ever wonder how do write a .Net Excel app that allows deployments in all platforms. (Excel 97, 2000, 2002, 2003)? Microsoft made a huge changes in office 2007 including the extension of the excel. It is now .xlsx, no longer. xls.  I am uncertain whether my solution works for Excel 2007. Anyway the answer to make it works in all version is late binding.

One of the disadvantage of late binding is you lose all the intellisence. Use early binding to use the intellisence and change the code to late binding syntax before deployment.
Early binding example:

excel early binding

Before deployment, change it to late binding as follow.

excel latebinding

Entry Filed under: .NET Excel. .

Leave a Comment

Required

Required, hidden

Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Trackback this post  |  Subscribe to the comments via RSS Feed


Calendar

March 2007
M T W T F S S
     
 1234
567891011
12131415161718
19202122232425
262728293031  

Most Recent Posts