In this Blender tutorial, we have discussed how to convert some excel data into a 3D line graph with animation. We will use a script for this operation - in fact two. The scripts are given below, just scroll down. Please watch the video for the complete tutorial. If you have any question on this tutorial, please leave your comment below.
๐๐๐ญ๐๐ก ๐จ๐ฎ๐ซ ๐๐๐ญ๐ ๐๐จ๐ฆ๐ฉ๐๐ซ๐ข๐ฌ๐จ๐ง ๐๐๐-๐จ๐ง ๐ โข Create Excel to Data C...
๐๐จ๐ข๐ง ๐จ๐ฎ๐ซ ๐๐ก๐๐ง๐ง๐๐ฅ ๐๐จ๐ซ ๐ญ๐ก๐ ๐๐ฅ๐๐ง๐ ๐๐ข๐ฅ๐ & ๐๐๐๐ข๐ญ๐ข๐จ๐ง๐๐ฅ ๐ฉ๐๐ซ๐ค๐ฌ ๐ / 5minutesblender
๐
๐จ๐ฅ๐ฅ๐จ๐ฐ ๐ฎ๐ฌ ๐จ๐ง ๐๐ง๐ฌ๐ญ๐๐ ๐ซ๐๐ฆ ๐ / 5minutesblender
๐๐ก๐๐ง๐ค๐ฌ ๐๐จ๐ซ ๐ฒ๐จ๐ฎ๐ซ ๐๐จ๐ง๐๐ญ๐ข๐จ๐ง๐ฌ ๐ donorbox.org/5-minutes-blender
==================================================
๐
๐ข๐ซ๐ฌ๐ญ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ: ๐๐ก๐ข๐ฌ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ ๐๐ง๐๐๐ฅ๐๐ฌ ๐๐ฅ๐๐ง๐๐๐ซ ๐ญ๐จ ๐ซ๐๐๐ ๐๐ซ๐จ๐ฆ ๐๐ฑ๐๐๐ฅ ๐๐ข๐ฅ๐๐ฌ.
๐๐จ๐ฎ ๐ง๐๐๐ ๐ญ๐จ ๐ซ๐ฎ๐ง ๐ข๐ญ ๐จ๐ง๐ฅ๐ฒ ๐จ๐ง๐๐ ๐๐จ๐ซ ๐ฒ๐จ๐ฎ๐ซ ๐ฆ๐๐๐ก๐ข๐ง๐ ๐๐
๐๐จ๐ฐ๐ง๐ฅ๐จ๐๐ ๐ญ๐ก๐ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ ๐๐ซ๐จ๐ฆ ๐ก๐๐ซ๐ ๐ bit.ly/5mbexcel2blender
๐๐ก๐๐ง ๐ฒ๐จ๐ฎ ๐ ๐๐ญ ๐๐ง ๐๐ซ๐ซ๐จ๐ซ: If the first script does not run correctly, you'll get an error in the second script (like "Module Not Found" error). The most common source of error is insufficient access on your device, so it is advisable to execute this script from an admin account on your machine. If the error still persists, I suggest you to use the portable version of Blender (follow the steps given here ๐ bit.ly/5mbexcelscripterror) This always works. Or you can skip this and directly go to the 3rd script given below that uses a CSV file instead of Excel.
๐๐๐๐จ๐ง๐ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ: ๐๐ก๐ข๐ฌ ๐ข๐ฌ ๐ญ๐ก๐ ๐๐๐ญ๐ฎ๐๐ฅ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ ๐ญ๐จ ๐๐ซ๐๐๐ญ๐ ๐ญ๐ก๐ ๐๐ง๐ข๐ฆ๐๐ญ๐ข๐จ๐ง.
๐๐จ๐ฎ ๐ง๐๐๐ ๐ญ๐จ ๐ซ๐ฎ๐ง ๐ข๐ญ ๐จ๐ง๐๐ ๐๐จ๐ซ ๐๐๐๐ก ๐๐ฑ๐๐๐ฅ ๐๐ข๐ฅ๐ ๐๐
๐๐จ๐ฐ๐ง๐ฅ๐จ๐๐ ๐ญ๐ก๐ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ ๐๐ซ๐จ๐ฆ ๐ก๐๐ซ๐ (๐๐ฅ๐๐ง๐๐๐ซ ๐.๐, ๐.๐, ๐.๐ & ๐ก๐ข๐ ๐ก๐๐ซ) ๐ bit.ly/5mb3DxlsGraph
Download the script from here (Blender 3.4 & below) ๐ bit.ly/5mb3DgraphOldxls
๐๐ก๐ข๐ซ๐ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ: ๐๐จ๐ฎ ๐๐๐ง ๐๐ฅ๐ฌ๐จ ๐ฌ๐๐ฏ๐ ๐ฒ๐จ๐ฎ๐ซ ๐๐ฑ๐๐๐ฅ ๐๐ข๐ฅ๐ ๐๐ฌ ๐ ๐๐๐ ๐๐ข๐ฅ๐ ๐๐ง๐ ๐ฎ๐ฌ๐ ๐ญ๐ก๐ ๐๐จ๐ฅ๐ฅ๐จ๐ฐ๐ข๐ง๐ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ ๐ญ๐จ ๐๐ซ๐๐๐ญ๐ ๐ ๐๐ ๐ ๐ซ๐๐ฉ๐ก ๐๐ซ๐จ๐ฆ ๐ญ๐ก๐๐ญ ๐๐๐ ๐๐ข๐ฅ๐. This is recommended if you are getting an error while running the above script. In this script, you need to mention the CSV file path instead of Excel, and all other things remain the same.
๐๐จ๐ฎ ๐ง๐๐๐ ๐ญ๐จ ๐ซ๐ฎ๐ง ๐ข๐ญ ๐จ๐ง๐๐ ๐๐จ๐ซ ๐๐๐๐ก ๐๐๐ ๐๐ข๐ฅ๐ ๐๐
๐๐จ๐ฐ๐ง๐ฅ๐จ๐๐ ๐ญ๐ก๐ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ ๐๐ซ๐จ๐ฆ ๐ก๐๐ซ๐ (๐๐ฅ๐๐ง๐๐๐ซ ๐.๐, ๐.๐, ๐.๐ & ๐ก๐ข๐ ๐ก๐๐ซ) ๐ bit.ly/5mb3DcsvGraph
Download the script from here (Blender 3.4 & below) ๐ bit.ly/5mb3DgraphOldcsv
==================================================
We have many more tutorials that can help you learn Blender like a professional. You can go through the following playlists for the relevant topics:
๐ ๐๐ฅ๐๐ง๐๐๐ซ ๐
๐จ๐ฎ๐ง๐๐๐ญ๐ข๐จ๐ง ๐๐จ๐ฎ๐ซ๐ฌ๐ ๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ:
If you are absolutely new to Blender, take this foundation course.
โข Blender Foundation Course
๐ ๐๐ฅ๐ฅ ๐๐ ๐๐ฅ๐๐ฌ๐ฌ๐๐ฌ ๐๐จ๐ ๐๐ญ๐ก๐๐ซ ๐๐ง ๐๐ง๐ ๐๐จ๐ฎ๐ซ:
โข Blender Foundation Cou...
๐ ๐๐ฅ๐๐ง๐๐๐ซ ๐๐ข๐ฉ๐ฌ ๐๐ง๐ ๐๐ซ๐ข๐๐ค๐ฌ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Blender Tips & Tricks
๐ ๐๐๐ฌ๐ฒ ๐๐จ๐๐๐ฅ๐ฌ ๐
๐จ๐ซ ๐๐๐ ๐ข๐ง๐ง๐๐ซ๐ฌ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Easy Models For Beginners
๐ ๐๐๐ญ๐๐ซ๐ข๐๐ฅ๐ฌ ๐๐จ๐ฎ ๐๐๐๐ ๐๐ง ๐๐ฅ๐๐ง๐๐๐ซ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Materials You Need In ...
๐ ๐๐ฅ๐ฅ ๐๐๐ฑ๐ญ ๐๐๐๐๐๐ญ๐ฌ ๐๐ง ๐๐ฅ๐๐ง๐๐๐ซ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Text Effects In Blender
๐ ๐๐๐ฆ๐๐ซ๐ ๐๐จ๐ฏ๐๐ฆ๐๐ง๐ญ & ๐๐๐ญ๐ญ๐ข๐ง๐ ๐ฌ ๐๐ง ๐๐ฅ๐๐ง๐๐๐ซ:
โข Camera Movement & Sett...
๐ ๐๐ฌ๐๐๐ฎ๐ฅ ๐๐ข๐ ๐ก๐ญ๐ข๐ง๐ ๐๐๐ญ๐ฎ๐ฉ ๐๐ง ๐๐ฅ๐๐ง๐๐๐ซ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Useful Lighting Setup ...
๐ ๐๐ข๐ ๐ข๐ ๐๐จ๐๐ฒ ๐๐ก๐ฒ๐ฌ๐ข๐๐ฌ & ๐๐ข๐ ๐ข๐ ๐๐จ๐๐ฒ ๐๐จ๐ง๐ฌ๐ญ๐ซ๐๐ข๐ง๐ญ๐ฌ:
โข Rigid Body Physics in ...
๐ ๐
๐ข๐ซ๐ & ๐๐ฆ๐จ๐ค๐ ๐๐ข๐ฆ๐ฎ๐ฅ๐๐ญ๐ข๐จ๐ง ๐๐ง ๐๐ฅ๐๐ง๐๐๐ซ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Fire & Smoke Simulatio...
๐ ๐
๐ฅ๐ฎ๐ข๐ ๐๐ข๐ฆ๐ฎ๐ฅ๐๐ญ๐ข๐จ๐ง ๐๐ง ๐๐ฅ๐๐ง๐๐๐ซ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Fluid Simulation in Bl...
๐ ๐๐๐ฌ๐ญ๐๐ซ๐ข๐ง๐ ๐๐ฅ๐๐ง๐๐๐ซ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Mastering Blender
If you want to watch our own creations in Blender, you can also check out the following channel where we regularly upload videos on Animation, Space Exploration and AI.
๐๐ฎ๐ซ ๐จ๐ญ๐ก๐๐ซ ๐๐ก๐๐ง๐ง๐๐ฅ ๐ฅ๐ข๐ง๐ค: / @thealienworld
#Blender #Animation #Tutorial #Excel
Timestamp
00:00 Create a link between Blender & Excel
00:56 Convert an excel file into 3D animation
02:32 Further enhancements with Python
29 ะธัะฝ 2024