Top "Excel" questions

How to count the number of rows in excel with data?

column A has data like this (ie frequent blank cells): HEADING <-- this is A1 kfdsl fdjgnm fdkj gdfkj 4353 …

.net vb.net excel vba excel-interop

Using Pandas to pd.read_excel() for multiple worksheets of the same workbook

I have a large spreadsheet file (.xlsx) that I'm processing using python pandas. It happens that I need data from …

python excel pandas dataframe

Excel CSV. file with more than 1,048,576 rows of data

I have been given a CSV file with more than the MAX Excel can handle, and I really need to …

excel csv split max rows

Convert date field into text in Excel

I have an Excel file which has a column formatted as date in the format dd-mm-YYYY. I need to convert …

excel excel-formula worksheet-function

How to merge rows in a column into one cell in excel?

E.g A1:I A2:am A3:a A4:boy I want to merge them all to a single cell "…

excel vba

VBA check if file exists

I have this code. It is supposed to check if a file exists and open it if it does. It …

excel vba file file-exists

How to turn a string formula into a "real" formula

I have 0,4*A1 in a cell (as a string). How can convert this "string formula" into a real formula and …

string excel formula evaluate

How to open an Excel file in C#?

I am trying to convert some VBA code to C#. I am new to C#. Currently I am trying to …

c# .net excel vsto

How can I concatenate strings in VBA?

This question comes from a comment under Range.Formula= in VBA throws a strange error. I wrote that program by …

excel vba

How to suppress Update Links warning?

I'm trying to write a script that opens many Excel files. I keep getting the prompt: This workbook contains links …

excel vba