Excel Ticker

Excel Ticker

22. August 2010
by Mourad Louha
5 Comments

Get the path and file name for a file location using formulas or VBA in Excel

I am currently studying some Windows Registry accesses from Excel & Co. A formula in an Excel sheet helps me to split these entries into its components; meaning the path elements and the value. The location where a file is … Continue reading

10. August 2010
by Mourad Louha
1 Comment

Read and write Excel and other Office documents with PHP

Sometimes, I also use PHP for implementing features for my websites. A very interesting and professional managed open source class library for reading and writing Excel documents in PHP is the “PHPExcel” project which can be found on CodePlex. For … Continue reading

5. April 2010
by Mourad Louha
0 comments

VBA Add-In for highlighting rows and columns in an Excel sheet

For some time now, I’m evaluating my web server log files with Excel 2010. Yes, there are many other good tools for analyzing logfiles on the market and I’m also using some of them. However, Excel 2010 provides the function … Continue reading