Only for questions on programming against Excel objects or files, or complex formula development.
Requirement : If the string in cell A1 contains "abc" as part of the string Then assign value "Green" Else if …
excel excel-formulaI have an Excel VBA macro which I need to run when accessing the file from a batch file, but …
excel vba batch-file command-lineI have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns …
excel excel-2007 excel-formula excel-2010 vbaHow do I open a file that is an Excel file for reading in Python? I've opened text files, for …
python excelI am currently using python 2.7 and trying to open an Excel sheet. When using the code below: import os from …
python excel win32comI'm trying to get the length of an array, yet I keep getting this error: Object required Am I doing …
excel vba ms-accessI am trying to write a value to the "A1" cell, but am getting the following error: Application-defined or object-defined …
vba excel excel-2007I am writing codes to export database from R into Excel, I have been trying others codes including: write.table(…
r excel r-faq