Step 1, download the excel add-on from here. Step 2, Unzip the file. Step 3, Open your spreadsheet on EXCEL. Step 4, Double click “DXL.xlam” to load the add-on. Step 5, Click “DataXL” on the top right and then Click “Ranges“, choose “Split Range into sheets” from the menu. Step 6, Choose how many rows Read More
Month: June 2020
Split an EXCEL workbook into multiple workbooks by VBA
You may need to split a large workbook to separate Excel files with saving each worksheet of the workbook as an individual Excel file. For example, you can split a workbook into multiple individual Excel files and then deliver each file to different person to handle it. By doing so, you can get certain persons Read More
HOW TO ENABLE GZIP COMPRESSION IN APACHE
by: Karal Max The mod_deflate module provides the DEFLATE output filter that allows the output from your server to be compressed before being sent to the client over the network. mod_deflate is the replacement of mod_gzip which was used with an older version of Apache. ENABLE GZIP MODULE IN APACHE By default, Read More
Redirect Request from HTTP to HTTPS (Apache)
original: https://cwiki.apache.org/confluence/display/HTTPD/RedirectSSL Let’s say you want http://www.example.com/secure/ to always be sent over SSL (I presume here that both the normal and the SSL vhost have the same content). You could do this by linking to the correct page from within your HTML pages… but there will always be some user who will sneak by it that way. Read More
2 Solutions for still showing “not secure” via HTTPS (with SSL)
Overview A common issue after adding an SSL certificate is that your browser still shows your site as insecure. This most often happens because there are links on your page that still point to HTTP instead of HTTPS. For example, look at the following code to link an image. <img src=”http://www.example.com/images/pic_mountain.jpg” alt=”Mountain View”> Notice how Read More
WinSCP Not Showing Hidden Files
WinSCP Not Showing Hidden Files Do you have “Show Hidden Files” option enabled? By default, WinSCP comes with the option “Show Hidden Files” set to true.but sometimes it comes with this option disabled. To activate this option to see hidden files, press: Ctrl+Alt+H or you can also activate this option by going to: preferences => Panels => Show hidden files Read More