Excel Sheet Column Number and Title Conversion in C++
Excel Column to Number Given a column title as appear in an Excel sheet, return its corresponding column number. For example: A - 1 B - 2 C - …
Category: excel
How to Use VBScript to Delete Duplicate Excel Rows with Another Less Column Value
September 15, 2014
beginner, case study, code, code library, excel, implementation, programming languages, string, VBA, vbscript, windows scripting host
No Comments
In this article, I am going to share a easy and quick way to delete some duplicate rows (e.g. regarding column B) from a spreadsheet but the requirement is …
How to Create a Picture By Changing Cell Colors in Excel, using PHP and VBScript?
August 16, 2014
excel, http, implementation, Office, php, programming languages, VBA, vbscript, web programming, windows, windows scripting host
No Comments
The excel spread sheet is a powerful Office tool developed by Microsoft. The latest Excel supports maximum 1,048,576 rows by 16,384 columns, which i believe you will never ever …
Excel Tip: Faster Auto-complete
The Microsoft Excel is heavily used and widely used. There are so many tricks/tips that help make the spreadsheet powerful and easy to use. For example, suppose you have …
Using Forecast function in excel to predict or calculate a future value along a linear trend by using existing values
This is one of my favourite useful tips in Excel. Sometime, you have a less-accurate data set with a lower resolution. However, partial data cannot be fit into the program. …