Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
3
Hi Guys,
I have a set of column data in excel sheet which I would like to manipulate and do matrix calculations. What would be the best approach to do this? Using C#/C++/Phyton/Java. I know all these do provide excel file read capabilities, but I just wanted to know what you guys think about the BEST way.
:confused:
4 replies to this topic
Back to top|
|
|
#2
Posted 04 December 2010 - 04:26 AM
Vladimir
-
- Members
-
- 79 posts
Learning Programmer
If you really know all listed languages, then it's a matter or taste. There is no official native Excel support in any of these languages.
I think you have to choose between C# and Python. C# should have better support for Excel (because they have one vendor), but Python have some scientific modules which can perfectly suite for your task (I mean maxtrix calculations).
There is a thead on forum how to work with Excel and C#: http://forum.codecal...data-excel.html. If you need help with Python feel free to create new thread in Python forum.
I think you have to choose between C# and Python. C# should have better support for Excel (because they have one vendor), but Python have some scientific modules which can perfectly suite for your task (I mean maxtrix calculations).
There is a thead on forum how to work with Excel and C#: http://forum.codecal...data-excel.html. If you need help with Python feel free to create new thread in Python forum.
#3
Posted 04 December 2010 - 07:04 AM
Ancient Dragon
-
- Members
-
- 400 posts
Programming Expert
If you want to read the *.xcl files directly then use VB Scripting. I've also hears CLI/C++ has support to read xcl files, but I've not used it. Otherwise, use Excel and export the data to a *.CVS file so that other programs can easily read it for whatever purposes.
Visit Grandpa's Forums, a social networking forum, with family-oriented arcade games, blogs, discussion forums, and photo albums.
#4
Posted 04 December 2010 - 10:12 AM
ask1net
-
- Members
-
- 3 posts
Newbie
Vladimir said:
If you really know all listed languages, then it's a matter or taste. There is no official native Excel support in any of these languages.
I think you have to choose between C# and Python. C# should have better support for Excel (because they have one vendor), but Python have some scientific modules which can perfectly suite for your task (I mean maxtrix calculations).
There is a thead on forum how to work with Excel and C#: http://forum.codecal...data-excel.html. If you need help with Python feel free to create new thread in Python forum.
I think you have to choose between C# and Python. C# should have better support for Excel (because they have one vendor), but Python have some scientific modules which can perfectly suite for your task (I mean maxtrix calculations).
There is a thead on forum how to work with Excel and C#: http://forum.codecal...data-excel.html. If you need help with Python feel free to create new thread in Python forum.
hey thanks for the input. I guess I will just go with C#, I'm not that good with phyton ..still learning.
#5
Posted 04 December 2010 - 01:42 PM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
- Location:Upstate, South Carolina
- Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
- Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others
Java also has a library for manipulating older MS files (xls, doc, etc). I've used it before, and it works quite well: Apache POI - the Java API for Microsoft Documents
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
