Tag: MicrosoftExcel

"I know Excel"

How to copy-paste a table from Excel to WordPress without using plug-ins?

So, I tried to paste a table from Excel into WordPress, and I failed. Annoying – but not a big problem. I can just paste it into an existing table and it’ll “sort itself out”, right? Well, no. Exporting the Excel sheet as a html page and copy-pasting the table from there didn’t work either. Actually, copy-pasting a table just didn’t work at all. So… WordPress is unable to understand HTML tables. Is that really it? Well, no, again, it’s not. It just refuses to…Continue reading How to copy-paste a table from Excel to WordPress without using plug-ins?

"I know Excel"

How to change the delimiter when exporting CSV from Excel?

Recently, I needed to find a way to import data from an old Excel-file to a custom-coded system that could import CSV files. However, the data was fairly non-sanitized – containing commas, semicolons and other weird characters. I could define the delimiter used in the imported data – however, that would be useless if I wasn’t also able to define it in the export. With Excel, it’s not that simple, though. Excel, just like other Microsoft Office applications loves trying its best to respect the…Continue reading How to change the delimiter when exporting CSV from Excel?