ExcelJS: how to get active Sheet
How to get active Sheet Get position of active Sheet: var active = workbook.Workbook.WBView[0].activeTab Get Sheet name of active Sheet: var activeSheetName = workbook.SheetNames[active] Get…
Latest Topics
PHP: see only 20 uploaded files at a time
By default, you can upload 20 files via a single request. If you want to upload more than 20 files, you should need to modify…
Escape double braces {{ }} in Mustache template
In case you use template in template , example: server Nodejs uses Mustache, client uses Handlebars HTML: You will get error like: Solution: You can…
PHP check if page is accessed with HTTPS
This code supports Cloudflare:
NestJS: ipinfo middleware
Dependency: @sansamour/express-ip File middleware/ip.ts File app.module.ts
How to push an existing repository to a repository on Github
Step 1: goto website Github to create your new repository example: https://github.com/sansamour/express-ip Step 2: login github with github-cli Step 3: git init Result: Step 4:…
How to build and publish a Typescript package to NPM
Step 1: init package Example: Result: Step 2: install typescript Result: Step 3: configuration Typescript: Result: Step 4: edit file tsconfig.json Step 5: write your…
PHP: How to get real client IP address
Read more: How to get real client IP address when you use Cloudflare
Git: Ignore files that have already been committed to a Git repository
Step 1: update file .gitignore Step 2: git rm -r --cached . Step 3: git add . Result: Step 4: Commit it: git commit -m…
Github: Can’t push to a remote repository on my Github
Since August 13, 2021, we can’t push to a remote Github repository by using username and password You must use Github CLI to login your…