Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
GS Shortcodes
#7
One of my customers needed an easy way to embed XSL files in his site on regular basis.

I made him a solution using the GS Shortcodes , but I changed the structure a bit + a language help file, so I attach it here if you'll want to adopt it to the "official" plugin.

I used a class for reading Microsoft Excel (97/2003) Spreadsheets (http://code.google.com/p/php-excel-reader/) ... enhanced with a few fixes I had to adapt for proper UTF-8 ( for Multi-bite Langs - as Hebrew) , and for "empty table cells" ....

xls2html is enabeling you to embed XLS files as HTML tables in your site pages

You need to upload your xml file(s) to your data/uploads/xls/ directory, and specify the name of the file in the file="" section.
  • file => '' (Name of the xls file)
  • rownumbers => 'false' (show/hide top row numbers, defauld=false)
  • coletters => 'false' (show/hide side col letters, defauld=false)
  • sheetnum => '0' (number of the sheet to show from the file, defauld=0)
  • tableclass => 'excel' (the class of the table, defauld=excel)
  • tableid => 'excel' (the id of the table, defauld=excel)
The table keeps most of the original XLS file formats (font-color, cells background, etc' ...)

Ex: [xls2html file="" rownumbers="" coletters="" sheetnum="" tableclass="" tableid="" /]

I'm attaching it here , but if there will be a need I can make a stan-alone plugin out of this ... though the "GS Shortcodes" is enough if n00dles101 wants to add it ...

My version is attached + 2 screenshots: the table result in a page (Hebrew, sorry) and the help section I improved @ the admin side ...


Attached Files Thumbnail(s)
       

.zip   gs_shortcodes.zip (Size: 30.43 KB / Downloads: 17)
Reply


Messages In This Thread
GS Shortcodes - by n00dles101 - 2012-05-15, 05:25:34
Excel XLS Spreadsheets into TABLES with GS Shortcodes - by Tzvook - 2013-06-01, 01:53:09
RE: GS Shortcodes - by shawn_a - 2013-06-01, 01:57:58
RE: GS Shortcodes - by Tzvook - 2013-06-01, 02:12:26
RE: GS Shortcodes - by scootball - 2013-06-06, 07:33:42
RE: GS Shortcodes - by n00dles101 - 2013-06-06, 22:45:35
RE: GS Shortcodes - by Tzvook - 2013-06-07, 01:47:53
RE: GS Shortcodes - by marrco - 2013-06-19, 00:06:56
RE: GS Shortcodes - by Kein2009 - 2013-10-15, 00:31:33
RE: GS Shortcodes - by datiswous - 2014-02-10, 23:23:13
RE: GS Shortcodes - by datiswous - 2016-01-04, 20:02:58
RE: GS Shortcodes - by n00dles101 - 2016-01-05, 00:27:35
RE: GS Shortcodes - by jeckyl - 2016-07-21, 00:49:35
RE: GS Shortcodes - by datiswous - 2018-04-30, 08:40:12
RE: GS Shortcodes - by n00dles101 - 2018-04-30, 23:58:21
RE: GS Shortcodes - by shawn_a - 2018-05-01, 02:39:48
GS Shortcodes - by shawn_a - 2012-05-16, 00:14:27
GS Shortcodes - by n00dles101 - 2012-05-16, 07:04:11
GS Shortcodes - by n00dles101 - 2012-07-26, 07:36:41
GS Shortcodes - by Cerulean - 2012-10-13, 12:23:10
GS Shortcodes - by Carlos - 2012-10-13, 16:22:26



Users browsing this thread: 1 Guest(s)