-3

Is there a program out there where I am able to open an excel file, change the value of one cell with the value going n to n+i, save the file and repeat this process?

Doesn't matter what language it is in. Just need it to work. If anyone knows of a program that will do that it would be greatly appreciated.

Best.

Its a list of 1200 tickers that I need to iterated though, the tickers come from another excel database.

RJava
  • 5
  • 1
  • 3
  • 3
    VBA would be the obvious choice - all the Office programs have it – Katana24 Sep 16 '13 at 18:13
  • If you want to have it be Java, there is the Poi library, otherwise, I agree with @Katana24, use VB. I think the hotkey is Alt-F11, and works in all Office products. – CodeChimp Sep 16 '13 at 18:21

2 Answers2

2

Judging by the provided requirements I'd say MS Excel should do the trick.

kooker
  • 363
  • 1
  • 5
  • 16
1

This Link should help. Same question.

This Link was provided as an answer to another question as well.

My advice: export from excel to a .csv file and have it either comma or space delimited based on your needs. Should be as easy as reading in a text file, which can be done in either c++ or java easily, from that point on. From what I know, working with excel files in c++ is not a fun place to be.

Edit: Or just use VBA in excel, tutorials are all over the place online.

Community
  • 1
  • 1
philhan
  • 590
  • 1
  • 6
  • 19