167 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
I'm using python 2.7 win32com module to load an MS Excel worksheet from Python: book = xlApp.Workbooks.Open("myFile.xls") sheet = book.Sheets(1) Many methods and properties…
I want to import some data from an Excel file ( xls ) by using TADOConnection and TADOTable. I connect to file with no…
I need help on my Excel sheet. How can I declare the following IF condition properly? if A1 = "n/a" then C1 = B1…
Are there formulas to convert data in a column to a matrix or to a row? And to convert from/to other combinations? What about…
I was writing a routine to read from an Excel spreadsheet. I have just discovered thro that MS Excel spreadsheet that 1 microsoft second…
I have to download historical end of day data for a huge list of stocks. I found on the bloomberg excel add-in the function…
I'd like to write a table like this: ---------------- | Long Cell | ---------------- | 1 | 2 | ---------------- How to write the…
I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following…
I am trying to generate a CSV file on the client side using javascript. I've followed the answer on this stackoverflow question. I have…
My problem seems simple, I just want to make a column chart with 2 y-axes. When I do this, Excel automatically puts the columns…