Luis Alfredo Porras Páez lporras

## GetTweets_GraphQL.json
query {
  twitter {
    ReactTweets: search(q: "ReactJs") {
      ...camposTweet
    }
  	GraphQLTweets: search(q: "GraphQL") {
    	...camposTweet
    	created_at
  	}
  	JavascriptTweets: search(q: "Javascript") {

## dependable_dropdown_with_macros.rb
require 'write_xlsx'

#workbook = WriteXLSX.new('write_xlsx_example.xlsx')
workbook = WriteXLSX.new('write_xlsx_example.xlsm')
workbook.add_vba_project('./vbaProject.bin')

dropdownSheet = workbook.add_worksheet('DropDown Values')
dropdownSheet.add_table('A1:A2', {
  data: [
    ['HOMBRES']

## lock_unlock_cells.vb
Sub unlockCells()
'
' unlockcell Macro
'
' Método abreviado de teclado: Opción+Cmd+e
'
 Dim chRng As Range
 Worksheets("Sheet2").Unprotect ("password")
 Set chRng = Worksheets("Sheet2").Range("E1:E100")


## macro.vb
Private Sub Worksheet_Change(ByVal Target As Range)
    Dim KeyCells As Range

    ' The variable KeyCells contains the cells that will
    ' cause an alert when they are changed.
    Set KeyCells = Range("A1:C10")

    If Not Application.Intersect(KeyCells, Range(Target.Address)) _
           Is Nothing Then

## data_validation_example.rb
require 'write_xlsx'

workbook = WriteXLSX.new('write_xlsx_example.xlsx')

dropdownSheet = workbook.add_worksheet('DropDown Values')
dropdownSheet.write_row(0,0,['open', 'high', 'close'])
dropdownSheet.protect('password')

worksheet = workbook.add_worksheet

## data_validation_list.rb
## AXLSX Gem Example
require 'axlsx'

excel = Axlsx::Package.new
wb = excel.workbook

months_sheet = wb.add_worksheet(:name => 'DropDown Values') { |ws| ws.sheet_protection.password = 'pa55w0rd' }
months_sheet.add_row ['value1', 'value2', 'value3']

wb.add_worksheet(name: "sample_sheet") do |sheet|

## OpenWithSublimeText3.bat
@echo off
SET st3Path=C:\Program Files\Sublime Text 3\sublime_text.exe

rem add it for all file types
@reg add "HKEY_CLASSES_ROOT\*\shell\Open with Sublime Text 3"         /t REG_SZ /v "" /d "Open with Sublime Text 3"   /f
@reg add "HKEY_CLASSES_ROOT\*\shell\Open with Sublime Text 3"         /t REG_EXPAND_SZ /v "Icon" /d "%st3Path%,0" /f
@reg add "HKEY_CLASSES_ROOT\*\shell\Open with Sublime Text 3\command" /t REG_SZ /v "" /d "%st3Path% \"%%1\"" /f

rem add it for folders
@reg add "HKEY_CLASSES_ROOT\Folder\shell\Open with Sublime Text 3"         /t REG_SZ /v "" /d "Open with Sublime Text 3"   /f

## ruby_ftp_example.rb
require 'net/ftp'

CONTENT_SERVER_DOMAIN_NAME = "one-of-the-ftp-server.thought-sauce.com.hk"
CONTENT_SERVER_FTP_LOGIN = "saucy-ftp-server-login"
CONTENT_SERVER_FTP_PASSWORD = "saucy-ftp-server-password"


# LOGIN and LIST available files at default home directory
Net::FTP.open(CONTENT_SERVER_DOMAIN_NAME, CONTENT_SERVER_FTP_LOGIN, CONTENT_SERVER_FTP_PASSWORD) do |ftp|
  files = ftp.list

## giphy.js
"use latest";
var handlebars  = require('handlebars');
var request     = require('request');

var View = `
<html>
  <head>
    <title>Giphy</title>
  </head>
  <body>

## ocr.rb
require 'base64'
require 'open-uri'
require 'net/http'
require 'net/https'
require 'json'

class OCR
  attr_reader :api_key, :image_url

  def self.scan(api_key:, image_url:)
	query {
	twitter {
	ReactTweets: search(q: "ReactJs") {
	...camposTweet
	}
	GraphQLTweets: search(q: "GraphQL") {
	...camposTweet
	created_at
	}
	JavascriptTweets: search(q: "Javascript") {
	require 'write_xlsx'

	#workbook = WriteXLSX.new('write_xlsx_example.xlsx')
	workbook = WriteXLSX.new('write_xlsx_example.xlsm')
	workbook.add_vba_project('./vbaProject.bin')

	dropdownSheet = workbook.add_worksheet('DropDown Values')
	dropdownSheet.add_table('A1:A2', {
	data: [
	['HOMBRES']
	Sub unlockCells()
	'
	' unlockcell Macro
	'
	' Método abreviado de teclado: Opción+Cmd+e
	'
	Dim chRng As Range
	Worksheets("Sheet2").Unprotect ("password")
	Set chRng = Worksheets("Sheet2").Range("E1:E100")
	Private Sub Worksheet_Change(ByVal Target As Range)
	Dim KeyCells As Range

	' The variable KeyCells contains the cells that will
	' cause an alert when they are changed.
	Set KeyCells = Range("A1:C10")

	If Not Application.Intersect(KeyCells, Range(Target.Address)) _
	Is Nothing Then
	## AXLSX Gem Example
	require 'axlsx'

	excel = Axlsx::Package.new
	wb = excel.workbook

	months_sheet = wb.add_worksheet(:name => 'DropDown Values') { \|ws\| ws.sheet_protection.password = 'pa55w0rd' }
	months_sheet.add_row ['value1', 'value2', 'value3']

	wb.add_worksheet(name: "sample_sheet") do \|sheet\|
	@echo off
	SET st3Path=C:\Program Files\Sublime Text 3\sublime_text.exe

	rem add it for all file types
	@reg add "HKEY_CLASSES_ROOT\*\shell\Open with Sublime Text 3" /t REG_SZ /v "" /d "Open with Sublime Text 3" /f
	@reg add "HKEY_CLASSES_ROOT\*\shell\Open with Sublime Text 3" /t REG_EXPAND_SZ /v "Icon" /d "%st3Path%,0" /f
	@reg add "HKEY_CLASSES_ROOT\*\shell\Open with Sublime Text 3\command" /t REG_SZ /v "" /d "%st3Path% \"%%1\"" /f

	rem add it for folders
	@reg add "HKEY_CLASSES_ROOT\Folder\shell\Open with Sublime Text 3" /t REG_SZ /v "" /d "Open with Sublime Text 3" /f
	require 'net/ftp'

	CONTENT_SERVER_DOMAIN_NAME = "one-of-the-ftp-server.thought-sauce.com.hk"
	CONTENT_SERVER_FTP_LOGIN = "saucy-ftp-server-login"
	CONTENT_SERVER_FTP_PASSWORD = "saucy-ftp-server-password"


	# LOGIN and LIST available files at default home directory
	Net::FTP.open(CONTENT_SERVER_DOMAIN_NAME, CONTENT_SERVER_FTP_LOGIN, CONTENT_SERVER_FTP_PASSWORD) do \|ftp\|
	files = ftp.list
	"use latest";
	var handlebars = require('handlebars');
	var request = require('request');

	var View = `
	<html>
	<head>
	<title>Giphy</title>
	</head>
	<body>
	require 'base64'
	require 'open-uri'
	require 'net/http'
	require 'net/https'
	require 'json'

	class OCR
	attr_reader :api_key, :image_url

	def self.scan(api_key:, image_url:)