cmiles – blog

New version – I have worked through a few more features/fixes: Source Code Setup Files Changes: – Updated the application to correctly deal with multi-area selections (see screen shot for an example) [to me this is valuable for use with PivotTables where I do not want to turn off subtotals]. – Added a set of [...]

Filed under: .net, Excel | 1 Comment »

Just a quick note that I put up some updated files for this project (original post with download links and update notes here). Enjoy, CM

Filed under: .net, Excel | Leave a Comment »

[update 9/25/2006 - I have posted a new version (see links below) and noted changes below] I have been working on a small project in my free time for the past couple of weeks – The short version: I wanted to produce a .net program that would produce ‘in-cell’ visualizations. There are already a number [...]

Filed under: .net, Excel | 1 Comment »

I frequently encounter Excel Worksheets with Smart Tags scattered around wanting very badly to share their ‘Number Stored as Text’ warning. Sometimes this warning is completely incorrect – the cell value really is a string even though it looks like a number (UPCs and US Zip Codes come to mind); sometimes the cell value really [...]

Filed under: .net, Excel | 10 Comments »

This idea and code is super simple – but I use it multiple times each day and thought that someone might enjoy it. This routine loops thru each cell in the current selection, if the cell has a value it is skipped – if it does not have a value the value from the cell [...]

Filed under: .net, Excel | Leave a Comment »

PivotTables are a powerful tool in Excel – one interesting feature is the ability to use large sets of data without having the raw data present on an Excel Worksheet or available through the connection types that Excel/Microsoft provide. This expands the number of possible datasources and frees the PivotTable from the data storage limits [...]

Filed under: .net, Excel | 2 Comments »

This past week I have revisited some of the different techniques for moving Excel data into a .net datatable in an effort to improve the speed/reliability of my code. In a perfect world Excel would only be a destination for data, I think there is a certain amount of futility in using Excel as a [...]

Filed under: .net, Excel | 1 Comment »