Possible to generate Excel Spreadsheet from gcode files?

[Mjolinor]

As Cura saves your settings by default in current_profile.ini you can get the data from that. I use Linux so my default profile is stored in "/home/jd/cura/14.09/current_profile.ini. If you are using Micro$hite software I have no idea where it is stored but it will be somewhere.

Your starting point is to open that file and copy the first column for your headers in the excel sheet. Save the excel sheet so it will look something like this:

[profile_1]

layer_height

wall_thickness

retraction_enable

solid_layer_thickness

fill_density

nozzle_size

print_speed

print_temperature

print_temperature2

print_temperature3

print_temperature4

print_bed_temperature

support

platform_adhesion

support_dual_extrusion

wipe_tower

But it will be a lot longer.

Insert a row at the top for your model name:

Model name:

[profile_1]

layer_height

wall_thickness

retraction_enable

solid_layer_thickness

fill_density

Save that file as your main file.

When you have a model that you want to save the settings for you have to exit Cura in order for it to update the current_profile.ini file automatically.

Open your saved spreadsheet and select "insert > insert from file". Note I am using open office but it should be there in Excel if you are unfortunate enough to use that.

Select the current_profile.ini file from wherever it is on your computer. That will open an import dialog. Use "=" as the delimiter in order to get the data from the right side of the equal sign into its own column. It will then open a new sheet. Go to the new sheet in your spreadsheet software and select the cells that have the correct data. Note there may be more than one Profile in there, make sure you select the data from the right one, my Cura uses "Profile_1"

Copy that into the main sheet of your file and delete the new sheet that was created when you opened the profile file.

Give it a filename, probably your Gcode filename in the extra row at the top.

You end up with something like this:

Model name:	wibble.gcode	wobble.gcode
[profile_1]
layer_height	0.15	0.15
wall_thickness	1	1
retraction_enable	True	True
solid_layer_thickness	1	1
fill_density	0	0
nozzle_size	0.3	0.3
print_speed	50	50
print_temperature	225	225
print_temperature2	220	220
print_temperature3	0	0
print_temperature4	0	0
print_bed_temperature	55	55
support	None	None

You will be able to record a Macro to do the import but I doubt that an Open Office Linux Macro will work with Windo$e.

Attached is the spreadsheet I made while trying this, you can use as a starting point if it works for you.