橋平礼の電験三種合格講座

過去50年分以上の電験三種の問題を解いて分かった、電験三種は今も昔も変わりません。過去問を解きながら合格を目指しましょう。

MENU

GO-AHEADの書籍(Learning VBA with Raspberry Pi)

 


Learning VBA with Raspberry Pi

f:id:hashi-rei-channel:20210813120232j:plain

Learning VBA with Raspberry Pi Amazon Kindle版

 

LibreOffice was also installed by default on Raspberry Pi Linux. The great thing about LibreOffice is that it's basically free. LibreOffice seems to be updated more frequently than OpenOffice. A programming language such as VBA is a prerequisite for AI and data scientist skills for IT technicians and people who work with things like Excel.

Digital transformation (DX) is the enrichment of people's lives through technology. In particular, Robotic Process Automation (RPA), which uses ICT technology to automate desk work, is being introduced. Some routine tasks can be expected to save up to 80% of time and increase productivity. Essentially, you're learning RPA, but if you haven't learned to program, it's a very difficult task. For this reason, you can increase your productivity by using Visual Basic for Applications (VBA), which comes standard with Excel, to streamline your routine tasks.

 This book is an introduction to VBA programming in LibreOffice on the Raspberry Pi.


1.Introduction -5


2. Raspberry Pi -6
 2.1 Raspberry Pi 3 model B
 2.2 Installing the Raspberry Pi OS
(1) Downloading the OS
(2) Connection to USB, HDMI, etc.
(3) Installing the OS
(4) USB memory
(5) Copying the screen
(6) When you want to connect to a wired LAN

3.Raspberry Pi -24
 3.1 Displaying "Hello World"
3.2 Calculating and displaying twice the input
 3.3 Calculating the Surplus
 3.4 Bit Operation
 3.5 binary number, octal number、hexadecimal number
 3.6 Calculating Real Numbers
 3.7 Exercises

4.Conditions and Loop -58
 4.1 Let's use an if statement (if statement-1)
 4.2 Let's use an if statement (if statement-2)
 4.3 Let's use an if statement (Select Case statement)
 4.4 Loop
 4.5 Let's use goto statements
 4.6 Exercises

5. array -87
 5.1 Programs with Arrays
 5.2 Programs with Arrays-2
 5.3 Programs with Arrays-3
 5.4 Programs with Arrays-4
 5.5 Programs with Arrays-5
 5.6 File Input/Output
 5.7 Exercise

6. String -121
 6.1 String-based programs-1
 6.2 String-based programs-2
 6.3 String-based programs-3
 6.4 String-based programs-4
 6.5 Exercise

7.Sub procedures (subroutines) -146
 7.1 Sub procedures-1
 7.2 Sub procedures-2
 7.3 Function procedure

Appendix  Form Controls -153
(1) Push Button
(2) Combo Box
(3) List box
(4) Option Button
(5) Check Box
(6) Spin Button
(7) Scrollbar
(8) Label

References -178