Daniel J. Choi

Office 2007 MIME Types

Dev

Here’s a list of MIME Types for Office 2007 files (those pesky files extensions that end with an x). Useful for file type checking in web applications and the like.

  • .docm – application/vnd.ms-word.document.macroEnabled.12
  • .docx – application/vnd.openxmlformats-officedocument.wordprocessingml.document
  • .dotm – application/vnd.ms-word.template.macroEnabled.12
  • .dotx – application/vnd.openxmlformats-officedocument.wordprocessingml.template
  • .potm – application/vnd.ms-powerpoint.template.macroEnabled.12
  • .potx – application/vnd.openxmlformats-officedocument.presentationml.template
  • .ppam – application/vnd.ms-powerpoint.addin.macroEnabled.12
  • .ppsm – application/vnd.ms-powerpoint.slideshow.macroEnabled.12
  • .ppsx – application/vnd.openxmlformats-officedocument.presentationml.slideshow
  • .pptm – application/vnd.ms-powerpoint.presentation.macroEnabled.12
  • .pptx – application/vnd.openxmlformats-officedocument.presentationml.presentation
  • .xlam – application/vnd.ms-excel.addin.macroEnabled.12
  • .xlsb – application/vnd.ms-excel.sheet.binary.macroEnabled.12
  • .xlsm – application/vnd.ms-excel.sheet.macroEnabled.12
  • .xlsx – application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
  • .xltm – application/vnd.ms-excel.template.macroEnabled.12
  • .xltx – application/vnd.openxmlformats-officedocument.spreadsheetml.template

Read Next

How to Remove the Top Border from Drupal Tables

Dev

I’ve been very busy developing a couple projects over the past couple days, but here is a quick little trick to get around one of Drupal’s quirks. If you’re unfamiliar with Drupal, it’s a fantastic CMS (content management system) built on PHP and MySQL. For those blog-savvy among us, it is to general websites what WordPress is to blogs. I use Drupal to get sites up quickly and with great functionality, and I highly recommend it to anyone who is looking to build powerful, custom websites without “re-inventing the wheel.”

Anyway, Drupal has this strange quirk in its source that creates a small grey border on the top of tables inserted in a page’s content.  A quick trip to my inspector revealed how to remove the top border from Drupal tables.  Simply add the following line to your CSS.

body tbody { border-top: none; }

All there is to it. 🙂

How to Quickly Add Indices to Large MySQL Tables

Dev

Whenever a MySQL query contains a WHERE conditional, the database server must find all the matching rows before it can execute any operations.  In order to optimize this matching, a database administrator might define an index on any columns he or she knows will be used more frequently in WHERE conditions.

Adding an index to an existing table with many rows, however, can take a long time or even fail entirely. Here’s a quick tip to deal with those situations.

Continue reading
© 2023 Daniel J. Choi

Sliding Sidebar

My friends call me Dan.

Currently, building Recca.

Previously, co-founder @ Plastiq.

Recent Posts

Categories