The rest of the program can also open excel, insert into the cells and close it. I have checked that the data analysis tab is usable in excel and i can successfully execute the regression function within excel itself manually. The macro may not be available in this workbook or all macros may be disabled. Throws the following error: Exception thrown: '' in Īn unhandled exception of type '' occurred in Ĭannot run the macro 'Regress'. True, false, false, false, Type.Missing, false) Currently i am following this tutorial to automate regression in excel:Įverything works fine, but the function that i am using (x1 in the tutorial as the variable): sheet.Range($"$A$1:$A$"), false, true, Type.Missing, sheet.Range("$D$1"), I would like to know how to run the regression function in microsoft excel using c#.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |