Questions about excel-interop
Read more about excel-interop
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
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
Limit Unknown excel range and stop IEnumerable function
I am working on an Excel based C# project where I have to put a whole column of data into a single dimensional array but I am unable to find proper way to do so.
The code I have used is although worki...
ankit goel
Votes: 0
Answers: 1
Formatting Excel sheet row color based on a cell value
i have a grid with column of orders numbers,
with this columns i check excels file,
if specific cell in the excel file is empty - the row will be red else is will be green.
but i dont why everythis is...
Ari Perez
Votes: 0
Answers: 1
Getting a COM class factory Path not found exception when the path clearly exists
I'm trying to use Microsoft.Office.Interop.Excel library to convert a csv to an xlsx.
This is the function I am using
public static string ConvertToXlsx(string _sFilePath)
{
string _newFilePath = _sFi...
NortziHead
Votes: 0
Answers: 1