web based data analysis tool for stocks
-
our application would need: 1.import data(stock prices) from websites into a database(excel sheets) 2.interfacing excel sheets with the asp application 3.performing manipulations on the data and draw corresponding graphs(line,bar,..) 4.make the application accessible on a network are asp.net and C# apt for the application? can someone please help us with relevant code? regards ps:please reply asap besides our email add are: funwithsiddartha@gmail.com lovelyritesh_in@yahoo.com shobhit.samaria@gmail.com abhinavsharma0507@gmail.com
-
our application would need: 1.import data(stock prices) from websites into a database(excel sheets) 2.interfacing excel sheets with the asp application 3.performing manipulations on the data and draw corresponding graphs(line,bar,..) 4.make the application accessible on a network are asp.net and C# apt for the application? can someone please help us with relevant code? regards ps:please reply asap besides our email add are: funwithsiddartha@gmail.com lovelyritesh_in@yahoo.com shobhit.samaria@gmail.com abhinavsharma0507@gmail.com
Do You basically going to manipulate a excel by .net application?
-
Do You basically going to manipulate a excel by .net application?
-
yes that is what we had in mind. if it is possible to call the functions of excel from .net then nothin like it or else we would like to develop similar functions in our program. thnx
Yes, is possible In your project you need add reference COM Microsoft Office XX Object Library where XX is the version of MSOffice that you'll work. The namespace is Microsoft.Office.Interop.Excel If you look in for this namespace you going to find many examples. Isn't too easy, but isn't impossible ;)
-
Yes, is possible In your project you need add reference COM Microsoft Office XX Object Library where XX is the version of MSOffice that you'll work. The namespace is Microsoft.Office.Interop.Excel If you look in for this namespace you going to find many examples. Isn't too easy, but isn't impossible ;)
-
hi alex! thnx for helping us. if u can send us some sample code of such interfacing it would be much easier to understand :) by the way where r u from and wat do u do? this is part of our engg project that we are seeking help for. regards
;) Well, I'm going to send a example for you with copy for emails in the first post I'm from Brazil, I'm .net developer, my english is poor but I can communicate...:laugh:
-
;) Well, I'm going to send a example for you with copy for emails in the first post I'm from Brazil, I'm .net developer, my english is poor but I can communicate...:laugh:
-
hi alex, u said u wud b sending us a sample code for calling the functions of excel from asp.net. if u have the code plz send it to us asap. we r waiting. regards
Sorry... But these days I'm in vocation Now I came back See the code below to open a Excel App.
ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass(); Workbooks oBooks = excel.Workbooks; object nulo = System.Reflection.Missing.Value; //here u have open method, there's many parameteres, but they can be null. oBooks.Open("C:\\file.xls",nulo,false,nulo,nulo,nulo,nulo,nulo,nulo,true,nulo,nulo,nulo,nulo,nulo); //A _workbook where the sheet lives _Workbook b = oBooks.get_Item(1);;P