Excel to C++

[RamziSaab]

Is there a program that can compile and excel spreadsheet into C++ automatically?

 

[Scott24x7]

No, there is nothing like that... what are you trying to accomplish?


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[RamziSaab]

i am trying to automatically convert my excel spreadsheet to c++ using a compiler. i.e. the program will rewurite the program in C with inputs the user chooses and output the required data

 

[Scott24x7]

Ramzi,
Sorry mate, that's still too vague. What are you REALLY trying to accomplish? Leave the Excel/C++ argument out of it, and tell me what you are trying to achieve for your user.


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[RamziSaab]

i am the user i need to run 1 million + simulations, excel takes a day (the excel spreadsheet if very well built but acnnot handle the sheer amount of calculations) i am looking for a way to speed it up...hence c++

 

[Scott24x7]

Well, if you know C++, why not just write something that will do the calculation? If you could "compile" the spreadsheet, it would still not be able to hold 1,000,000 itterations... so you'll need another solution.
Have you considered something like SQL Server and OLAP? Or, Access or VFP sound like better tools than using Excel for what you are trying to do. You need to find the right tool for your job here...


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[RamziSaab]

i dont need it to hold the iterations just ouput the data in excel

 

[Scott24x7]

Well, VFP can write data out to Excel tables... it sounds like the ideal thing for you. It has some powerful number crunching too, as long as the numbers do not exceed about 15 - 20 digits in length per number.


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[RamziSaab]

ok but i dont want to write the program myself i want it to work out the calculation itself and just use it as an addin

 

[Scott24x7]

Well, I still don't really understand what you are trying to accomplish... can you give me any more detail about what you are doing, otherwise, I don't think anyone here will be able to help you. Feel free to provide me an e-mail address and I will corresond on this issue that way with you if you wish.

Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[RamziSaab]

ok can you check out

http://www.turboexcel.com/

i think it will explain what i want ... just wondering if there are other programs out there like it

 

[Scott24x7]

So you are trying to replicate what Turboexcel does??? Why not just buy it then?


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."