Read only spreadsheet (like excel)

Resources Community Resources
#1

Welcome to the showcase and tutorial of Spreadsheet.
(I am not good with names)

most times when I build a game I lack a decent overview of what certain properties or settings are.
think of a tool folder with guns, and you want a list of the attributes “damage”, “Fire Rate” and “DPS”

but everywhere I looked, I couldn`t find a plugin that could make that overview…
so I made one myself.

step 1 “get the plugin”

step 2 open the plugin

afbeelding
afbeelding1919×277 36.5 KB

and you are greeted with the following screen

afbeelding
afbeelding803×608 22.7 KB

Step 3 Create a new table
Press the new button.
This will create a new folder in serverscriptstorage
and in this folder will be a module script
this module script will open automatically

afbeelding
afbeelding1556×521 83.6 KB

in this modulescript we are going to write the settings that we want.

the first function is the instances that we want to list
in this example all children of the folder Guns

function()
	return game.ReplicatedStorage.Guns:GetChildren()
end;

after the first functions comes the colums of what you want to see

in our case it is damage, fire rate, DPS and for showcase i added bullet color

	function(instance) 
		return instance:GetAttribute("Damage")
	end;

	function(instance) 
		return instance:GetAttribute("Fire_Rate")
	end;
	
	function(instance) 
		local dps = instance:GetAttribute("Damage") * instance:GetAttribute("Fire_Rate")
		return dps
	end;
	
	function(instance) 
		return instance:GetAttribute("Bullet_Color")
	end;

my entire script

afbeelding
afbeelding1555×592 101 KB

I now select the module script again and in the plugin, I press “Load”

afbeelding
afbeelding1555×881 151 KB

congratulations, you made your first spreadsheet.
in this spreadsheet, you can not edit, and the values do not auto-update.

there are some more advanced functions that ill list here. but try to get a feel for the plugin itself first.
gl and have fun

  • in the module script, when return a string while the instance == nil, this will replace the text “sort” at the top
  • pressing the 2nd column wil focus the camera to the instance
  • entering text in the filter box will filter out all items that does not have that text in that column
  • if you save your game, then open it back up. select the module script and press load… it will use those settings
  • you can rename the modulescript it just has to stay a child of the folder
  • you can add infinitive colums, they just become harder to read
  • i am new to this… if you find a bug… tell me a solution.
  • if you go over my code and ask me “Why did you do it this way” … there are definitely better ways, but this way I understand, I am open to improvements tho
2 Likes