Skip to content

Instantly share code, notes, and snippets.

@0red
0red / Centos7.md
Created September 3, 2024 09:38 — forked from unicornist/Centos7.md
CentOS 7 Server Setup including NginX, NodeJs, MongoDB, Redis, Docker, etc...

Note: For newer versions of NodeJS, Nginx and MongoDB, checkout their websites and update the related parts.

0.Pre-requisites

run all the commands in terminal as the root user (sudo su)

yum update
yum install -y epel-release
@0red
0red / excel_column_names.md
Created October 9, 2024 09:29 — forked from Ghostscypher/excel_column_names.md
Get the excel column name e.g. column 0 is A.

When working with excel and you need to know the column name given it's index for example column 0 is A, column 26 is AA etc. Also given AA reverse the it to get a column index of 26. A little bit into what each function does, get_cell_value takes in a string of a given excel cell e.g. A5 where A is the column name and 0 is the row index. It returns the row and column index as [5, 0] i.e. an array/tuple where 5 is the row index and 0 is the column index. In short row 5 column 0. The getColumnName takes in the column index and reeturns the string version of it. For example getColumnName(5) means get the string equivalent of column with a column index of 5 which returns E.

<?php