I'd like to say that you're able to achieve almost the same functionality what Excel does have. Let's say, you need to create editable gridview. That's all!
It's bad idea to use third party application (like Excel), because of many factors:
1) you can't (fully) control it,
2) you need to export data to Excel than to import them to your database, which means unnecessary data movement,
3) etc.
Have a look at my previous answer:
Replace string in statment[
^]. There is a lonk to very interesting article abour "calculation engine".
If you want to know how to achieve Sum column, please use a
SearchBox[
^].
To create pivot table, use SQL
PIVOT[
^] statement.
Simple Way To Use Pivot In SQL Query[
^]
Pivots with Dynamic Columns in SQL Server 2005[
^]
Pivot tables in SQL Server. A simple sample.[
^]
Try!
Good luck!
Submit an article or tip