You are currently browsing the archives for posts tagged as Excel.

Inserting An Unknown Number Of Excel Rows Into MySQL With VBA

I’ve been asked how to insert an unknown number of lines of data from an Excel spreadsheet into MySQL. I thought that rather than answer that question in a comment reply, I might as well create a sample Excel spreadsheet with the solution already in place.

Of course, I will explain the rationale behind my method in this article first 🙂

Read the rest of Inserting An Unknown Number Of Excel Rows Into MySQL With VBA »

Excel Worksheet Removal Using VBA

I deal with Excel spreadsheets a lot in my work, but strangely I found that I never shared anything regarding MS Excel on HTNet! Well, this ends today.

I’m no fan of Microsoft, but I honestly think that their Office suite is the best office productivity software package bar none. And out of all the members in the Office suite, Excel is simply the best among them. There’s really a lot you can programmatically tell it to do.

One of most common ways to automate tasks in Excel is by using VBA. You can read more about VBA on Wikipedia.

Read the rest of Excel Worksheet Removal Using VBA »