For most of January I have been working with an open source GIS mapping component called SharpMap. It's a cool tool, and very powerful, but being open source it - to some extent, -suffers from a lack of clear examples, particularly for programmers new to this type of programing (geospatial) .
Today I wanted to [...]
UPDATE!
hueymanchew, quite rightly points out that .text is read only, so the you can't write to that property of a cell! A case of not seeing the wood for the tree I think!
I'm writing a light wight class to use in VB.Net projects which will late bind to Excel and dump a load of data [...]
Right that should get a few people here!
XL Dennis has made public the first version of his code librarian - ".NET Co Library".
I've done a bit of testing for this addin and can personally vouch for how useful it is - keep all you VBA code in one place - copy the .mdb and [...]
Last night I downloaded Turbo Delphi, tonight I installed it, well, I tried to install it!
Looks like good old Delphi uses some parts of the .Net Framework and SKD - and why not really, but a little bit surprising?
Clearly I don't have 1.1 - so I'll have to install this in a few weeks(when [...]
The world of managed com addins is a mess. VSTO has not been received well and the story of unmanaged code (Excel) and managed code is of deployment and stability nightmares.
There are a quite a few things right from the off that cause problems for Office devs wanting to use .Net technology:
- .Net is inherently [...]
UPDATE - Check out the comments for a better solution! - boy I sure am glad I finished the post the way i did!
In VB.Net (well any dot net language really) you can add a “SplitContainer” control – I like to call it a splitter control. It’s good, it’s great for getting your .Net controls [...]
Here is a little .Net app that shows how you can get hold of an excel instance so that you can use that Excel object from code - but with out using IDT. This is useful when writing classes rather than managed addins. I will hopefully make a post about how we can use .net [...]
Ok, so this blog might be turning in to a social bookmarking site, but I'm busy working on other stuff, to wit, this might be worth a look if your struggling with the .Net name spaces!
.NET Namespace Toolbar
.
If you do want to download it you will have to sign up to the code project [...]
Here's a nice screencast video from Kathleen McGrath,
And heres the InteropForm Tool Kits
2 things need to be answered, can it be used from VBA/office, I'd guess yes,
does it need to be shimed? - did think yes again.
Anyway, if i get time I'll take a look!
Handy link for being more productive doing stuff in the VS IDE
http://www.codeproject.com/tips/VSnetIDETipsAndTricks.asp