FAQ  •  Login

LuaCSV [Export data from LUA to Excel]

<<

BurningBridges

User avatar

Naturally Aspirated

Posts: 378

Joined: Tue Oct 08, 2013 11:56 pm

Location: Berlin

Cars: Golf

Post Sun Mar 22, 2015 10:02 am

Re: LuaCSV [Export data from LUA to Excel]

trackpaduser wrote:Best way to export it to a proper Excel file would be with a VBA script made in Excel.

But, as you said, you can just open the CSV with Excel and then save it as an Excel file.


Of course I could also write it directly to Excel file, but that means you must have Excel installed. But that's a whole lot of effort for a little skript that you only run a few times ever. Shouldnt be too hard to follow the instructions and just copy the stuff.
<<

07CobaltGirl

User avatar

Queen of Track Building

Posts: 1613

Joined: Sun Dec 08, 2013 11:47 am

Location: Atlanta, GA, USA

Cars: Chevy Cobalt

Post Tue Mar 24, 2015 3:47 am

Re: LuaCSV [Export data from LUA to Excel]

It won't run on my laptop. Could you list the requirements for this to work?

I have Win7 x64 with .NET 4.5.1 (and .NET 3.5) installed. Anything more specific?

Here was my error. "LuaCSV" is extracted to "My Documents" folder, if that is of any significance.

  Code:
Description:
  Stopped working

Problem signature:
  Problem Event Name:   APPCRASH
  Application Name:   LuaCSV.exe
  Application Version:   1.0.0.0
  Application Timestamp:   55049e6c
  Fault Module Name:   KERNELBASE.dll
  Fault Module Version:   6.1.7601.18409
  Fault Module Timestamp:   5315a05a
  Exception Code:   e0434f4d
  Exception Offset:   000000000000940d
  OS Version:   6.1.7601.2.1.0.768.3
  Locale ID:   1033

Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
  C:\windows\system32\en-US\erofflps.txt
<<

BurningBridges

User avatar

Naturally Aspirated

Posts: 378

Joined: Tue Oct 08, 2013 11:56 pm

Location: Berlin

Cars: Golf

Post Tue Mar 24, 2015 6:44 am

Re: LuaCSV [Export data from LUA to Excel]

The only requirement is dotNEt 2.0 but it should work with your version. I think the problem is rather the LuaInterface.dll, wouldnt be surprised if its not 64 bit compatible (release date is 2004?).
Which reminds me I dont even know if I used the latest version :)
next time I will read about the topic, for now, you could just upload your models/engines as a zip and someone else will convert them to Excel, I mean someone with a red car in his signature :) (its barely 2 minutes work)
<<

07CobaltGirl

User avatar

Queen of Track Building

Posts: 1613

Joined: Sun Dec 08, 2013 11:47 am

Location: Atlanta, GA, USA

Cars: Chevy Cobalt

Post Tue Mar 24, 2015 7:31 am

Re: LuaCSV [Export data from LUA to Excel]

Yes, that seems to be the issue. LuaInterface.dll and Lua51.dll are 32-bit only. They would have to be recompiled and re-referenced for a 64-bit environment. There were some alternatives listed. NuLua is supposed to be the easiest one to use for this purpose. Maybe I will try it this weekend, but I don't know a thing about C#. It is different from C++ (which I do know) and more like Python, or so I have heard.
<<

BurningBridges

User avatar

Naturally Aspirated

Posts: 378

Joined: Tue Oct 08, 2013 11:56 pm

Location: Berlin

Cars: Golf

Post Tue Mar 24, 2015 7:56 am

Re: LuaCSV [Export data from LUA to Excel]

Ok that's it then.
It shouldn't be hard for you to do in C#. Copy the dlls to your VS project and add it via references. Just choose "browse to file" and include the namespace. You can also see in my sourcecode how I used the rather strange Lua class. There are probably better, and certainly faster ways but I am a beginner how to do use it. The return value is always undetermined, so I need to check types and cast a lot.
<<

BurningBridges

User avatar

Naturally Aspirated

Posts: 378

Joined: Tue Oct 08, 2013 11:56 pm

Location: Berlin

Cars: Golf

Post Sat Apr 04, 2015 9:34 pm

Re: LuaCSV [Export data from LUA to Excel]

It simply took too long until the Launcher version was updated, I am no longer in a position to continue this. I also think that it's the developers repsonsibility to provide a path to preserve user data, I am not going to do their work. Besides the car/engine format is not organized in a way that I can work with.
Previous

Return to Community Challenges & Competitions

Who is online

Users browsing this forum: No registered users and 17 guests