Excel Helper Utilities Library Part One(adronbhall.com)
submitted by 
adron(831) 2 years, 5 months ago
I'm kicking off a series that is a long time in the making. The series is 99% complete at this point, and will be published every couple days. Right now I?m aiming for a Monday, Wednesday, Friday type of frequency, but might throw in an extra one here or there. When completed the code will be posted to CodePlex for easy download & an additions that someone might want to contribute. Just hit me up at adron [at@] adronbhall [dot.] com.
Here?s a code file I've put together to help project using Excel 2007. These are just some small helper methods, etc., that remove some of the redundant Type.Missing and other insidious things one has to go through when developing with Excel.
This first class is a pure and simple utility class to help clean up strings for use in certain situations that come up with Excel. Some examples might be when trying to clean up a string for a worksheet name.
Of course, as usual, the first thing I hit where the unit tests. Since these methods are relatively simple, I just went ahead and wrote tests for each.
(click on article to see code and read more)
|category: C#
|Views: 63
tags:
C# another
Everyones tags:
Your Tags: