Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting an analysis toolpak function in a Cell with C#
First of all, greetings to every one.
I have to say that I'm new to the Microsoft Office programming. I use Excel 2003 US with analysis toolpak loaded and VS.net 2005. I'm making a little programme in C# to write formulas into Excel sheet cells. It works just fine with the basics formulas but with the formulas from the analysis toolpak they are not understood, I get the #NAME? message. The thing that I don't understand is that when I write the formula (=ISODD(3) for exemple) with my programe and open the xls file with excel, double click on the cell and press "enter" the cell is recalculated and put correctly the "false" indication. What should I do have the cell with the analysis toolpak correctly writen or evaluated ? Many thank's for the help and for your answers Clair PS : this is the methode I use the modify a Cell : private Excel.Range excelRange = null; .. .. .. public void modifCell(int line, int row, string value) { excelRange = (Excel.Range)excelCurrentSheet.Cells[line, row]; excelRange.Cells.Clear(); excelRange.Cells.FormulaLocal = value; excelRange.Cells.Calculate(); } |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting an analysis toolpak function in a Cell with C#
Up !
I realy need help on this |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting an analysis toolpak function in a Cell with C#
No one know's ?
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting an analysis toolpak function in a Cell with C#
I'm still looking for informations, I don't understand what is happening
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting an analysis toolpak function in a Cell with C#
up ! :o)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
Yield() function missing from XL2007 SP1 ATPVBAEN Analysis ToolPak | Excel Worksheet Functions | |||
Inserting a analysis toolpak function with C# | Excel Programming | |||
My XIRR function has dropped out, analysis toolpak doesn't fix. | Excel Worksheet Functions |