This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Step 1. Make a copy of the spreadsheet in an empty directory. Rename the extension to .zip | |
Step 2. Extract the zip file. | |
Step 3. In the extracted contents, goto the folder \xl\worksheets\ | |
Step 4. There should be one xml file per sheet? I editing "sheet1.xml" with NotePad++. From nearly the very end of the file, remove the tag that starts with: | |
<sheetProtection | |
My entire tag was as follows: | |
<sheetProtection algorithmName="SHA-512" hashValue="ALciNBSIqRcjDiFbCuyWoGk4iOcC/ZRKnEjwEVi1skb6G5JbHhp+QVZ9+rlPVbGILOS7lYiCvJmR4Q7IuSphXA==" saltValue="8OVKXrG0VacLOLVztUpEYw==" spinCount="100000" sheet="1" objects="1" scenarios="1" selectLockedCells="1"/> | |
Step 5. Save the file. Open the ZIP file in 7zip, find the same file, drag and drop, save, exit, rename the file back to (xlsx) and open |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#File: file.list.txt | |
#/path/to/file/1.txt | |
#/path/to/file/2.txt | |
#/path/to/file/3.txt | |
#! /user/bin/env bash | |
while IFS="" read -r p || [ -n "$p" ] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Display links when the <a> has no text value but the href attribute has a link: | |
a[href^="http"]:empty::before { | |
content: attr(href); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"auto_complete_delay": 5, | |
"auto_complete_selector": "source, text", | |
"color_scheme": "Packages/Color Scheme - Default/Monokai.tmTheme", | |
"create_window_at_startup": false, | |
"extra_file_exclude_patterns": | |
[ | |
"*.pyc", | |
"*.pyo", | |
"*.exe", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
touch -d "2016-01-01 00:00:00" /tmp/date.start; | |
touch -d "2016-12-31 23:59:59" /tmp/date.end; | |
sudo find ./ -type f -newer /tmp/date.start ! -newer /tmp/date.end -exec rm {} + |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Imprime el directorio indicado en 7 columnas | |
"ls /etc | pr -T7" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Muestra los 10 comandos que más utilizas y el número de veces que los has usado. | |
"history| awk '{print $2}' | sort|uniq -c| sort -r -n|head" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Cómo encontrar archivos en un directorio que NO SEAN imagenes en #linux: | |
find . -type f -exec file -i '{}' | grep -v "image" \; |