Questions about excel
Read more about excel
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
Pandas read_excel with formulas and get values
So, I had some code running that opened a series of excel files and converted to dataframes using pd.read_excel, no issues. Just today, the files are now all displaying NaN instead of values. The ex...
John Taylor
Votes: 0
Answers: 1
How do I output the same type of value in VBA next to the same value?
I want to use VBA to get the values of columns A and B and output them to columns C and D as below.
Same names in column A are made into one and output to column C.
Same values in column B are kept a...
Sato
Votes: 0
Answers: 2
In Interop.Excel, the Worksheet.SaveAs has a CSV option. How can I use this if my *.xlsx file has line feeds in some cells (Alt+Enter)
Writing a c# app to digest some old spreadsheets. When reading an Excel file that contains line feeds (by using Alt-Enter while in a cell), I can't seem to use "Worksheet.SaveAs" to save a ...
Mike McCoin
Votes: 0
Answers: 0
Entering data from a userform to a table using first blank cell in a column
I want to enter data from my userform to a table. I foolishly thought I could do this the same way as when I entered it into a range. EDIT-my script actually does work to add the info to a table. I wa...
Samuel Lindemulder
Votes: 0
Answers: 0