A number of years ago, I wrote a Java application which was designed to convert CSV to XML format. The trick being to create an efficient, effective XML document based on the headers of the CSV data. It didn’t turn out well, but I ended up with something that worked and got me started into…
Read moreExcel and WPF
I do a lot of programming. It’s what I do for a living, and it’s also what I do to relax. I know, for many of you, that probably sounds really weird; but I discovered a few years ago that I was dreading waking up in the morning. That was also the time that I…
Read moreExcel and Sharepoint – Revisited
A few months ago, I wrote this blog entry here where I talk about logging into SharePoint, verifying a particular file exists, checking for a lock on the file, and informing the user of the result. Well, after much ado, I finished it. With a lot of swearing, cursing, and hating of SharePoint in general. What…
Read moreExcel VBA, SOAP, XML and SharePoint – Verify a File Exists (Updated July 25, 2013)
This last week I have been hard at work on a project for a client. Essentially, the client needed an excel macro which would accomplish this:
1. Open a worksheet found in a predetermined location on a SharePoint Server.
2. Do some stuff with it.
3. Save the worksheet back to the SharePoint Server.
It seems pretty simple, doesn’t it? SharePoint is Microsoft, Excel is Microsoft, you’d think the two would talk to each other easily; or that Microsoft would build in various classes and methods associated to make linking Excel to SharePoint simple.
Read more