Cheat Engine Forum Index Cheat Engine
The Official Site of Cheat Engine
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


Exporting the Cheat Table to Excel?

 
Post new topic   Reply to topic    Cheat Engine Forum Index -> Cheat Engine
View previous topic :: View next topic  
Author Message
mg_01
Cheater
Reputation: 0

Joined: 28 Jan 2018
Posts: 41

PostPosted: Fri May 28, 2021 4:00 pm    Post subject: Exporting the Cheat Table to Excel? Reply with quote

Hello, I was wondering if it were possible to export a series of highlighted and copied addresses into Excel or a spreadsheet program?

It'd be really nice top keep the same format of "Active/Desc/Address/Type/Value" when it gets pasted into Excel. I was wondering about ways to do this and came up with:

1) Can Excel be programmed to read the constant-XML that CE produces, so it will automatically parse it and organize it when it gets pasted?

2) Using Powershell or something with Regex to parse out the sections into a CSV or list.

3) Using Lua directly through CE -- Maybe writeToClipboard?

Thanks!
Back to top
View user's profile Send private message
TheyCallMeTim13
Wiki Contributor
Reputation: 50

Joined: 24 Feb 2017
Posts: 976
Location: Pluto

PostPosted: Fri May 28, 2021 4:27 pm    Post subject: Reply with quote

You could just use lua to create a comma separated value file which Excel and Libreoffice Calc can load. And I'd go with lua, you can even add a menu item that runs the export function.
_________________
Back to top
View user's profile Send private message Visit poster's website
mg_01
Cheater
Reputation: 0

Joined: 28 Jan 2018
Posts: 41

PostPosted: Fri May 28, 2021 6:50 pm    Post subject: Reply with quote

I think the easiest way for what I need is to just copy-paste chunks of my CT table and paste them into Excel 'cause it has an XML-parsing system.

I had used writeToClipboard, but it capped out at 200 entries. I also did something with a Lua script that wrote a CSV, but i couldn't figure out how to format it.

Anyway, thanks.
Back to top
View user's profile Send private message
TheyCallMeTim13
Wiki Contributor
Reputation: 50

Joined: 24 Feb 2017
Posts: 976
Location: Pluto

PostPosted: Fri May 28, 2021 7:51 pm    Post subject: Reply with quote

It's just "data 1,data 2,data 3\r\n", it's a simple format.
https://en.wikipedia.org/wiki/Comma-separated_values

_________________
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Cheat Engine Forum Index -> Cheat Engine All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group

CE Wiki   IRC (#CEF)   Twitter
Third party websites