excel-interop Questions
7
Solved
I have developed a console program in C# .NET, that uses Excel Interop.
The program works just fine on my development machine and in the windows server 2008, if I run it from command line.
When I ...
Riker asked 11/2, 2011 at 20:53
18
Solved
I'm having an issue with Excel Interop.
The Excel.exe doesn't close even if when I realease instances.
Here is my code :
using xl = Microsoft.Office.Interop.Excel;
xl.Application excel = new ...
Larcener asked 28/6, 2013 at 14:43
10
I am trying to convert a .xls file to an .xlsx file on the server-side using Microsoft.Office.Interop.Excel.Workbook class as follows:
workBook.SaveAs("FILENAME_HERE", XlFileFormat.xlOpenXMLWorkb...
Yellowgreen asked 27/2, 2014 at 7:52
2
I am using Interop to open an instance of Excel to retrieve some data. However the following line:
Application xlApp = new Microsoft.Office.Interop.Excel.Application();
is giving this error:
Sy...
Grahamgrahame asked 23/1, 2020 at 8:30
11
Solved
Microsoft.Office.Interop.Excel.WorkbookClass.SaveAs() method is working fine on Windows server 2003 and also on XP but not on Windows server 2008. I copied it as it is gave all Dll's and permission...
Whitmore asked 10/12, 2010 at 11:26
28
Solved
I am getting HRESULT: 0x800A03EC on Worksheet.range method. Number of rows are more than 70K. Office 2007.
Code:
Microsoft.Office.Interop.Excel.Range neededRange
= currentWS.Range[cell.Cells[1, ...
Weiner asked 17/8, 2011 at 21:31
3
Solved
I'm trying to set Excel cells using RGB values rather than the way I do it currently as i need to set cells to a specific colour rather than a set standard colour.
This is how i currently do it:
...
Platinize asked 26/7, 2017 at 8:40
22
Solved
I'm writing an application in C# that opens an Excel template file for read/write operations. I want to when user closes the application, excel application process has been closed, without saving e...
Unmoved asked 21/7, 2013 at 22:20
8
I know that there are different ways to read an Excel file:
Iterop
Oledb
Open Xml SDK
Compatibility is not a question because the program will be executed in a controlled environment.
My Requi...
Baste asked 21/10, 2012 at 8:36
2
Solved
As far as I can see, this is not a duplicate question, as the question here is about why the accepted answers of seemingly duplicate questions, do not solve my issue in what appears to be the same ...
Parturition asked 5/12, 2022 at 1:23
5
Solved
I have a bit of code that opens an xls workbook;
Excel.Workbooks workBooks;
workBooks = excelApp.Workbooks;
workbook = workBooks.Open(sourceFilePath + sourceFileName + ".xls");
I then get the wo...
Jenness asked 3/7, 2013 at 5:12
9
Solved
I have my code as follows :-
Microsoft.Office.Interop.Excel.Application oXL = null;
Microsoft.Office.Interop.Excel.Sheets sheets;
Application excel = new Microsoft.Office.Interop.Excel.Application...
Aporia asked 18/8, 2011 at 11:4
2
Solved
Is it possible to determine whether Excel is running in 32-bit or 64-bit from the Microsoft.Office.Interop.Excel.ApplicationClass?
EditThe solution should work for both Excel 2010 and Excel 2007
And asked 31/5, 2011 at 12:28
1
Solved
I'm using Visual Studio 2022. I have created a .net 6 project.
I added the COM references: Microsoft Excel 16 Object Library (Microsoft.Office.Interop.Excel) and Microsoft Office 16 Object Library ...
Rhoden asked 11/11, 2021 at 1:7
7
Solved
I need to access an excel file that is already open. I thought just inspecting the .Workbooks property that it would be there but it isn't. What is the right way to get a reference to the open work...
Bolt asked 13/7, 2011 at 16:58
6
Solved
While my C# program writes data continuously to an Excel spreadsheet, if the end user clicks on the upper right menu and opens the
Excel Options window, this causes following exception:
System.Run...
Richel asked 22/5, 2014 at 13:20
5
Can anybody tell me how we can add a hyperlink in Excel (2007 or later) from
a cell in one sheet to a cell in another sheet using Office Interop in .NET (c#)
For example: A hyperlink from Sheet1 C...
Sensual asked 26/8, 2009 at 10:34
13
Solved
Hi I am having a list container which contains the list of values. I wish to export the list values directly to Excel. Is there any way to do it directly?
Familist asked 5/2, 2010 at 9:45
2
Solved
I am getting a System.com_object error if I am trying to read the EXCEL cell which is empty. My code is :
public static List<OrderPC> getFilters(string fileCheckout)
{
List<OrderPC>...
Tsosie asked 15/11, 2012 at 10:56
7
Solved
I have started using the Excel interop assemblies that are provided by Microsoft for one of my C# applications. Everything is going fine, but there seems to be a lack of strong typing, and honestly...
Exudate asked 9/8, 2011 at 20:5
3
Solved
I'm trying to get a range from Excel, which has multiple areas specified, essentially I've got...
int StartColumn
int EndColumn
int[] ColumnsToSkip
When you combine these it's possible to produce...
Cally asked 27/5, 2011 at 16:31
8
I have user supplied excel files that need to be converted to PDF. Using excel interop, I can do this fine with .ExportAsFixedFormat(). My problem comes up when a workbook has millions of rows. Thi...
Manhunt asked 21/3, 2011 at 20:53
4
Solved
I have the following C# function in my project, which is supposed to open and return an existing Excel workbook object:
Application _excelApp;
// ...
private Workbook OpenXL(string path, string ...
Feat asked 8/7, 2013 at 15:46
4
Solved
I want to detect merged cells either in a row/entire sheet(preferable).Here is my code
Microsoft.Office.Interop.Excel.Application xl = new Microsoft.Office.Interop.Excel.Application();
Microsoft...
Evaevacuant asked 26/6, 2015 at 9:37
6
Solved
What I want to do
I'm trying to use the Microsoft.Office.Interop.Excel namespace to open an Excel file (XSL or CSV, but sadly not XSLX) and import it into a DataSet. I don't have control over the w...
Kliment asked 30/8, 2011 at 14:38
1 Next >
© 2022 - 2024 — McMap. All rights reserved.