Skip to content

Instantly share code, notes, and snippets.

Juan Salgado bgdos

  • Poly Material Mexico
  • Tecate, Mexico
Block or report user

Report or block bgdos

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@bgdos
bgdos / export-html-table-to-excel.md
Created Sep 13, 2017 — forked from umidjons/export-html-table-to-excel.md
Export HTML table to Excel in AngularJS
View export-html-table-to-excel.md

Export HTML table to Excel in AngularJS

myApp.factory('Excel',function($window){
		var uri='data:application/vnd.ms-excel;base64,',
			template='<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>',
			base64=function(s){return $window.btoa(unescape(encodeURIComponent(s)));},
			format=function(s,c){return s.replace(/{(\w+)}/g,function(m,p){return c[p];})};
		return {
@bgdos
bgdos / insertar.sql
Created Oct 7, 2015 — forked from punktoy/insertar.sql
ejemplo de store procedure dinamica en mysql para insertar
View insertar.sql
DELIMITER $$
DROP PROCEDURE IF EXISTS Insertar $$
CREATE PROCEDURE Insertar(
IN tipo INT,
IN tablas VARCHAR(1000),
IN columnas VARCHAR(1000),
IN inserciones VARCHAR(1000)
)
BEGIN
You can’t perform that action at this time.