Download table content in xcl format using java script


//JavaScript function for downloading in excel format

<script type="text/javascript">

var tableToExcel = (function() {
  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 function(table, name) {
    if (!table.nodeType) table = document.getElementById(table)
    var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}
    window.location.href = uri + base64(format(template, ctx))
  }
})()
</script>


//Html with table format for binding with the script.

<input type="button" onclick="tableToExcel('testTable', 'W3C Example Table')" value="Export to Excel">

<table id="testTable" summary="Code page support in different versions of MS Windows." rules="groups" frame="hsides" border="2">
                                           ... Table content ...
</table>



helpfull-link: http://jsfiddle.net/insin/cmewv/

Comments

Post a Comment

Popular posts from this blog

Setting up Orthanc server on Ubuntu 16

Setting up Orthanc server on Ubuntu 16. # How to compile, install and run newest version of Orthanc DICOM server # from Github source in Ubuntu 16.04 LTS cd sudo apt-get update sudo apt-get install build-essential unzip cmake mercurial uuid-dev libcurl4-openssl-dev liblua5.1-0-dev libgtest-dev libpng-dev libsqlite3-dev libssl-dev libjpeg-dev zlib1g-dev libdcmtk2-dev libboost-all-dev libwrap0-dev libcharls-dev libjsoncpp-dev libpugixml-dev doxygen qupzilla sudo rm -rf Orthanc* sudo apt-get purge orthanc git clone https://github.com/jodogne/OrthancMirror.git mkdir ~/OrthancBuild cd ~/OrthancBuild/ cmake -DSTATIC_BUILD=ON -DCMAKE_BUILD_TYPE=Release ~/OrthancMirror/ sudo make sudo make doc ./Orthanc --version ./Orthanc & qupzilla http://localhost:8042/app/explorer.html # press ESC key twice to ignore warning messages about Mozilla Firefox # when using the file upload function Original Post AT:  https://mark911.wordpress.com/2016/07/13/how-to-compile-i...
Read more

How to install COMODO SSL Certificates for NGINX

Image
DO ALL THINGS ON LIVE NOT ON LOCAL SERVER Setting up a SSL Cert from Comodo ================================= Step 1: Create new example key and CSR files openssl req -new -newkey rsa:2048 -nodes -keyout example_com.key -out example_com.csr This gives you two files: * ``example_com.key`` -- your Private key. You'll need this later to configure ngxinx. * ``example_com.csr`` -- Your CSR file. Now, purchase the certificate [1]_, follow the steps on their site, and you should soon get an email with your *PositiveSSL Certificate*. It contains a zip file with the following: * Root CA Certificate - `AddTrustExternalCARoot.crt` * Intermediate CA Certificate - `COMODORSAAddTrustCA.crt` * Intermediate CA Certificate - `COMODORSADomainValidationSecureServerCA.crt` * Your PositiveSSL Certificate - `www_example_com.crt` (or the subdomain you gave them) DO ALL THINGS ON LIVE NOT ON LOCAL SERVER Step 2: Go To orders, and Click on order detail and then re issuing the certificate ...
Read more

start, stop and restart Nginx (with proper installation guide for Nginx server)

Image
Step 1: Install Nginx Nginx is available in Ubuntu's default repositories, so the installation is rather straight forward. Since this is our first interaction with the  apt  packaging system in this session, we will update our local package index so that we have access to the most recent package listings. Afterwards, we can install  nginx : sudo apt-get update sudo apt-get install nginx After accepting the procedure,  apt-get  will install Nginx and any required dependencies to your server. Step 2: Adjust the Firewall Before we can test Nginx, we need to reconfigure our firewall software to allow access to the service. Nginx registers itself as a service with  ufw , our firewall, upon installation. This makes it rather easy to allow Nginx access. We can list the applications configurations that  ufw  knows how to work with by typing: sudo ufw app list You should get a listing of the application profiles: Output Availa...
Read more