phpExcel Error: Maximum 31 characters : Solved

I’ve recently been working with the phpExcel library as part of some ongoing work parsing xls files and processing the data. Importing some older xls files lead to an error I hadn’t seen before:

1
2
3
4
5
6
7
8
9
PHP Fatal error:  Uncaught exception 'Exception' with message 'Maximum 31 characters allowed in sheet title.' in /home/xyclops/includes/phpexcel/PHPExcel/Worksheet.php:406
Stack trace:
#0 /home/xyclops/includes/phpexcel/PHPExcel/Worksheet.php(657): PHPExcel_Worksheet::_checkSheetTitle('Some Old Title...')
#1 /home/xyclops/includes/phpexcel/PHPExcel/Reader/Excel5.php(730): PHPExcel_Worksheet->setTitle('Some Old Title...')
#2 /home/xyclops/includes/phpexcel/PHPExcel/IOFactory.php(193): PHPExcel_Reader_Excel5->load('./generatedfile...')
#3 /home/xyclops/xls_files.php(204): PHPExcel_IOFactory::load('./generatedfile...')
#4 /home/xyclops/xls_files.php(52): process_xls_file('./generatedfile...', '2008-01-02')
#5 {main}
 thrown in /home/xyclops/includes/phpexcel/PHPExcel/Worksheet.php on line 406

Given that I don’t want to preserve the name of the worksheet anyway, the fix is very simple: truncate the title when it gets checked.

Opening the Worksheet.php file, I added the following to the top of the public function setTitle($pValue = ‘Worksheet’) method:

1
$pValue = substr($pValue, 0, 31);

And there you have it. No more errors, automatically truncated worksheet names.

Hello world! I’m a Redesign in Progress

Moving the entire site over to WordPress. Got the old posts imported, now to update to the latest version and finish the new theme…

Xyclops Release xyCJXhelper – Beat Adblock with Affiliate Links!

So as you may be aware, CJ have launched CJXbeta, a new program that provides targeted adverts to blocks you can place on your pages.This is something I have been interested in working with, but what I found was that the code that CJ provide is easily blocked by AdBlock, which is no good! I operate in a relatively tech-savvy niche and most people know how to install an adblocker in their browser.So I went the other way, and used individual ads, because these I could mask and host, and get around the adblocking software.When CJ launched CJXbeta, I decided to look again at the ways I could defeat adblock while making use of the great convenience provided by the new CJX program, and I found a way to do it. I am offering that method in the form of an easily configured software library you can add to your sites: xyCJXhelper.About xyCJXhelperYou can read more about xyCJXHelper at http://www.xyclopsoft.com/go/cjx/, but here is an overview of the features:

  • AdBlock-defeating routines for more impressions
  • Even easier ad placement
  • Global configuration of CJX links
  • Customizable affiliate link encryption
  • Automated ad parameter creation for easier content-specific ads
  • Simpler management of your resources
  • xyCJXhelper dynamically hosts the ads(If you already have the ad image it will not be downloaded again but your impressions will still be recorded)
  • xyCJXhelper manages your affiliate links
  • All you change for each ad placement is the new CJX ad link
  • Encrypt links with your unique passphrase
  • Links are auto configurable to be NOFOLLOW and open in a new tab

Here’s the difference between the two approaches. Source: from here

Free SEO Tools On The Way

Way back when, I developed some SEO Analytics tools as part of a project with a friend/colleague of mine. Well, the time has come to leave that project behind – we did well but he’s leaving to start a fantastic new job, and I can’t run a service like this without devoting all my time to it.So, why should you care?Because this means that I’m going to take the code and turn it into free seo tools for the public. The stuff will be going up at http://seotools.xyclopsoft.com in the near future, so bookmark this blog, head over there and sign up to be notified when I release the tools.I need to take a look at what is convertable, but so far I am pretty sure we will have at least:

  • A free Google keyword position / PR ranker – check your site or competitors’ sites for keyword ranking
  • A free keyword density tool – I am pretty sure this has the ability to spider your entire site, but we’ll see how this gets implemented

So I need to clean up the code, and get it looking pretty (it was all backend analysis before, so all my outputs are full of data, debugging and ugly as sin), and then it will be released. I might do a beta trial just so that I can feel all 2.0 about it. Ha.Exciting times.

Discount Network Cable, Coupons and Offers from Deep Surplus

Buying premium, overpriced cables is one of the biggest scams going today, in our opinion. Not so long ago we were offered a ‘gold-plated printer cable’ at a ridiculous markup. I guess gold has great compression qualities, eh?

Luckily, we, and now you, know better than to fall for those monster markup tricks.

Deep SurplusDeep SurplusDeep Surplus are the number one supplier of Discount cable, overstocked network cable and pretty much any kind of cabling you can think of. They sell:

  • Bulk Cable
  • Patch Cables
  • Network Connectors
  • Network Adapters
  • Ethernet Cabling
  • Cat5, Cat5e, Cat6
  • Fiber Optic
  • Cable and Satellite TV Wiring
  • Phone Network Cabling (Cat 3)
  • Cable Management and Raceway
  • Server Racks and Storage
  • Patch Panels
  • Cable Tools
  • Computer Cables
  • Audio Cables
  • And More…

They also offer Same Day Shipping with no hidden shipping charges, no restocking fee, no back orders, a 90-day return policy, and the best prices for cable you will find on the web, which is why we’re pleased to recommend Deep Surplus.

Get Discount Domain Names

When you’re looking for a domain name, what you really want is:

  • a reliable domain name seller
  • a usable control panel for managing your domain names
  • a cheap price
  • good quality support

We think that 1&1 provide all these and more.We use 1&1 as our source for domain names, and happily recommend them to our clients. They tend to be cheaper than other domain name sellers at least 99 out of 100 times, so we’d like to draw your attention to this special offer:Stop paying too much for domains! Reg. price $8.99. Click Here for Special $4.99 Discount Price. Plus free privacy + free email.Get discount domain names until the end of November by using the link above.

Get 15% Off 1 Year with PalTalk

Get 15% off 1st Year of Paltalk Extreme! Enter Coupon Code: PT15 As a small business, I collaborate with a bunch of other small businesses across the globe, so videoconferencing is vital to maintaining a personal connection. I’ve been trialling Paltalk for a while (they have a free trial) and it is an excellent application that meets my videoconferencing needs. Right now they have a great offer to save 15% – just click the link above – and of course you can trial the software first.Paltalk is currently my go-to app for videoconferencing both for business and personal uses.Description from Paltalk:Paltalk is the leader in video chat! Users can see, hear, and talk to one another instantly – anywhere in the world. Millions of people are chatting online.

  • Thousands of Video Chat Rooms
  • More than 20 categories
  • 4 Million friendly members
  • Create your OWN chat room
  • SuperIM: Video conferencing from any web browser
  • NEW: Guests can leave Video Voicemail

Get 15% off 1st Year of Extreme! Code PT15


Free live voice and video chat. Thousands of chat rooms to choose. Download Paltalk Now For Free!

WordPress Theme Store – New Free Theme -”Spring Greens”

Xyclops software opened their new Theme store today!We’re starting with premium pre-built and custom WordPress themes and installation, and in time we’ll expand to Blogger, Joomla, Drupal, and Magento themes. We’ll also be offering free themes via the site, so be sure to check back from time to time!Check out our first free theme: “Spring Greens” in our store right now!

 

Update: Due to the amount of custom themes we’re asked to create vs vanilla theme sales, we’ve decided to pull the store to save server resources for more exciting projects. In time we’ll make sure our prebuilt themes get converted to WP 3.* compatibility, get them hosted and have them all available for free download. We’ll add a new post once these are live.

Add Widgets to Your WordPress Theme: How-to

Adding widgets to your own WordPress theme is incredibly straightforward, and involves only a few simple steps.In this article I’ll explain exactly how you can go about adding easily-customizable content to your WordPress themes. (more…)

Convert an HTML Template to a WordPress Theme: How-to

Though WordPress has a huge number of themes available, I often get clients asking me if it is possible to take a standard HTML / CSS template and transform it into a WordPress theme.The answer is yes, and to do the basic conversion, it is affordable and fast.The way I convert a template to a WordPress theme involves a few easy steps. In this post, I’ll explain how to get a simple conversion underway. (more…)