Daqing Chu At WordPress

April 10, 2011

Two Useful Excel Functions

Filed under: Programming Notes — David Chu @ 10:18 pm
Tags:

I often use Excel as a tool for some tests or data analysis. For example, last week I tried to comparing two columns in data base to see their difference. I found out that I had an Excel as a tool to do that. This file contains some formula for column comparison. Here is summary what I did for my future reference.

[Read more…]

April 3, 2011

Broken MSCOMRT2.OCX Caused Excel Add-in Exception

Filed under: Programming Notes — David Chu @ 1:40 am
Tags:

Last week I spent almost two days to resolve one issue. Excel add-in throw exceptions after an enterprise application update was installed. This happened initially in a product our team supports. The product is from a third party application suite by company C, where one Excel add-in is part of.

[Read more…]

February 13, 2011

.Net Project to Copy Excel Data

Filed under: Programming Notes — David Chu @ 2:56 am
Tags: ,

In the past weeks, I have been working on a project to copy Excel data between worksheets. The source worksheet contains some formulas with links to other worksheets and add-ins. The problem is that the API functions defined in add-ins take long time to get data from a remote service. When there are hundreds and even thousands of rows in Excel, it will take to long time to refresh data. That’s the reason to have a scheduled job to copy the daily data from source excel file to another one with only values. Since the output put excel file contains only values, the show time is much responsive.

[Read more…]

November 6, 2010

Using Excel to Compare SQL Database Tables

Filed under: Programming Notes — David Chu @ 6:03 pm
Tags: ,

It is a very common task to compare data content between two SQL database tables. If two tables are within a SQL database, I normally use TSQL EXCEPT and UNION to get difference, detail in my previous blog: Comparing Two Tables By SQL Stored Procedure.

[Read more…]

Blog at WordPress.com.