Export to Excel (Full Version)

All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition



Message

Ramjet -> Export to Excel (12/12/2009 1:51:12 PM)

It would be great to have all this new data in excel. Has anyone merged all the CVS files into an excel spread sheet for the ships?



Kull -> RE: Export to Excel (12/12/2009 3:02:10 PM)

quote:

ORIGINAL: Ramjet

It would be great to have all this new data in excel. Has anyone merged all the CVS files into an excel spread sheet for the ships?


Get WitP Tracker (see sticky threads above). It will do that and much, much more!



Bradley7735 -> RE: Export to Excel (12/12/2009 5:35:14 PM)

Witploadae.exe in the SCEN folder will do it as well. You need to open a dos prompt. Here is the help that JuanG gave me a long while back.



Witploadae.exe requires additional commands to get it to do what you want.

The key ones are
/e is extract scenario -> csv (without this it is packaging from csv -> scenario)
/s## is scenario ID

As you are just typing witploadae.exe, it is assuming to be packaging scenario 1, which is why you get that error as there is no scenario 1 csv files.

So if you wanted to extract scenario 2 into csv, you would write witploadae.exe /e /s02

CSV files should open fine in excel, and unlike some other games, AEs csv files are well formatted and should read and save perfectly from excel.


Hope this helps, as its a very useful and powerful tool to use.

< Message edited by JuanG -- 8/27/2009 2:00:20 AM >



Buck Beach -> RE: Export to Excel (12/24/2009 2:27:21 PM)


quote:

ORIGINAL: Bradley7735

Witploadae.exe in the SCEN folder will do it as well. You need to open a dos prompt. Here is the help that JuanG gave me a long while back.



Witploadae.exe requires additional commands to get it to do what you want.

The key ones are
/e is extract scenario -> csv (without this it is packaging from csv -> scenario)
/s## is scenario ID

As you are just typing witploadae.exe, it is assuming to be packaging scenario 1, which is why you get that error as there is no scenario 1 csv files.

So if you wanted to extract scenario 2 into csv, you would write witploadae.exe /e /s02

CSV files should open fine in excel, and unlike some other games, AEs csv files are well formatted and should read and save perfectly from excel.


Hope this helps, as its a very useful and powerful tool to use.

< Message edited by JuanG -- 8/27/2009 2:00:20 AM >



I have followed all the instructions to the "T" (if you will excuse the expression), and I get a data dump, but, it is always Scenario 1 data, regardless of what "s" file I designate. I am running an old Excel 97 version.

I found this thread with its recent activity in trying to figure out what the hell I am doing wrong.



Bradley7735 -> RE: Export to Excel (12/24/2009 6:02:29 PM)

Hi Buck,

Here's exactly what I type to do a data dump, and a data import:

Open a DOS prompt by: clicking 'start', then run. On the 'run' prompt, I type cmd then click ok.

At the dos prompt, I type: CD C:\Games\WITP AE\SCEN (that's where I have it saved on my computer.)

Now, I type: WITPLOADAE.exe /e /s198 (Long ago, I opened Scenario 1 in the editor and saved it as scenario 198.)

That gives me CSV files that I can open in Excel and modify to my hearts extent.

To import, I go back to the DOS prompt and type: WITPLOADAE.exe /i /s198

this produces files that are saved in a different location and need to be copied back to the SCEN folder.
My location is C:\Matrix Games\War in the pacific admiral's edition\scen
I go there, highlight all the files, right click and choose copy, then go to my SCEN folder above and paste.

That's about all the help I can give. the spaces above are important, and it's case sensitive, I think.

Good luck, and Merry Christmas Eve.



Buck Beach -> RE: Export to Excel (12/24/2009 8:14:36 PM)

Thank's Bradley I have a tool "Open Command Prompt" in my Data Management program "Power Desk 7" that takes me to the Dos when I open it. C:/Matrix/WITPAE/SCEN. It is here it type Witploadae.exc/e/s111 (my saved file of DaBabes mod).

Maybe I am trying to do more than what I can. Here is basically what I am trying to accomplish. I had previously modify a scenario with a hundred or so entries (one by one using the Editor). I am trying to salvage my work by opening up that scenairo (saved to s110) and dumping it into the SCEN folder. I then want to swapped the info from one excel worksheet to another. However, when I dump it doesn't dump the info for the S110, it dumps it is the Scenario 1 data. As a matter of fact even when I try to dump the scen 26 Da Babes, it captures Scen 1 data. I will look to see if I am added or subtracting spaces.


Thank's again for your help.



Bradley7735 -> RE: Export to Excel (12/24/2009 8:18:10 PM)


quote:

ORIGINAL: Buck Beach

Thank's Bradley I have a tool "Open Command Prompt" in my Data Management program "Power Desk 7" that takes me to the Dos when I open it. C:/Matrix/WITPAE/SCEN. It is here it type Witploadae.exc/e/s111 (my saved file of DaBabes mod).

Maybe I am trying to do more than what I can. Here is basically what I am trying to accomplish. I had previously modify a scenario with a hundred or so entries (one by one using the Editor). I am trying to salvage my work by opening up that scenairo (saved to s110) and dumping it into the SCEN folder. I then want to swapped the info from one excel worksheet to another. However, when I dump it doesn't dump the info for the S110, it dumps it is the Scenario 1 data. As a matter of fact even when I try to dump the scen 26 Da Babes, it captures Scen 1 data. I will look to see if I am added or subtracting spaces.


Thank's again for your help.



Hi Buck,

You need spaces before the /

ex:

Witploadae.exe /e /s111



Buck Beach -> RE: Export to Excel (12/24/2009 8:23:35 PM)

Gotcha

Buck



Buck Beach -> RE: Export to Excel (12/24/2009 8:28:16 PM)







[/quote]

Hi Buck,

You need spaces before the /

ex:

Witploadae.exe /e /s111
[/quote]


YES, it dumped correctly when I spaced right. Thanks a million.

Buck



Bradley7735 -> RE: Export to Excel (12/24/2009 8:29:55 PM)

Awesome!! Finally, I'm useful for something more than warming a chair. [;)]



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.765625